Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases?
Can you give me some DBCC command options?(Database
consistency check) - DBCC CHECKDB - Ensures that tables in
the db and the indexes are correctly linked.and DBCC
CHECKALLOC - To check that all pages in a db are correctly
allocated. DBCC SQLPERF - It gives report on current usage
of transaction log in percentage. DBCC CHECKFILEGROUP -
Checks all tables file group for any damage.
in user parameter property we have list of values.can we
write select query for binding?
for example::
select empno from emp where deptno=:deptnum
:deptnum is first parameter it displays distinct dept nos.
if i do like this it is giving error::
bind variables are not allowed in the select statement
36
Explain the family trees and connection by clause
40
How would you determine who has added a row to a table?
81
Is the After report trigger fired if the report execution
fails ?
what’s the difference between Covering Indexes and Clustered
Indexes ?
how to use clustered index small ?
50
i made a table whih contain a column "Photo" with image
data type and i want to insert the byte of a picture
present in my hardisk using insert statement in that
colum... so what will be my insert statement?
50
HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT
QUERY OR MULTIPLE GROUP QUERY ?
along with your userid / name. ThanQ
Site Map