Thanks for your reply Adriaan.. But here I want to audit who has access that particular table at a particular period of time. Is there any way to...
Hi all, Basically I will enter the login and password from the application and in turn it will check for the table in SQLServer 2005 of that...
The database size is 250 GB. This is the new index i am creating....
The hardware configuration is O/S : Microsoft Windows Server2003, Service Pack2 Processor: Intel Xeon CPU,2.00 GHZ RAM : 2GB SQLServer : SQLServer...
Hai sathya, thks for the information. Here I am creating nonclustered index only, and also I haven't run any of the DBCC commands and Backup commands...
Hai all, I am creating a index for a table which is containing 20 lakh records for a single column. It is taking a very long time to create that....
Hai, I have cancelled the updation operation on one of my tables in one database, in the Query Analyser, as it is takes a long time for more than 9...
Dear all, Please guide me what is the impact on writing the query as count(*) or count(1) in the select query,as both of them will show the number of...
Separate names with a comma.
