usually faces the problems like sql server is taking more memory or CPU usage is high due to sql server , and i checks the parameters like 1)whether...
Dear all, where can i get the link to download the sql server 2000 analysis services Service Pack 3 (i have sql server 2000 Service pack 3...
The Query, SELECT OBJECT_NAME(id) as ObjectName, USER_NAME(uid) as UserName, protecttype, action, USER_NAME(grantor) as Grantor FROM sysprotects...
Hi all, I am new to SQL server. today i found that one SPid was blocking itself in the sysprocesses system table. in wht synario it is possible..?...
dear all,<br /><br />i m having SQL Server 2000 Standard Edition on my production server.<br /><br />now i want to deinstall Standard Edition and...
Please can anybody know any <b>SQL Monitoring Tool</b> which will take of <br /><br /><br />- Capacity Planning(Disk Space, CPU Usage, Memory...
Dear ALL,<br /><br />Please can anybody tell me <br />if i lost the datafiles and logfiles of the master database.[<img...
Separate names with a comma.