I would suggest grouping of your SQL Servers and having one accout per group.  For example, you could use one account for all Developement Servers, One Account for Test Servers,...

The Bug Mentioned by Chris is fixed in Hotfix of SQL Build 780 and is documented in KB artile http://support.microsoft.com/default.aspx?scid=kb;en-us;812915 .  If your SQL Server build is above 780, the...

If you are getting space related issues, I assume that you are trying to rebuild all the indexes on the table (or Database) at once.  Try these steps

Drop the Non...

The Process you followed works perfectly fine, but I would like add few points of caution here.

These steps should be followed as  a last resort because the script uses 2 very dangerous...

Hi,

The Best way to trouble shoot General Slow Performance of SQL Server is to look for any obvious reason that you could point to like any changes since the last...

As long as the SQL Server is running, no body can copy the files, even if I login with the SQL Server Startup account.  If the SQL Server is stopped,...

The issue is because these objects are owned by a different user, not the user who is trying to execute the query. 

It may also be the case of orphan...

Re creating the Clustered indexes (Tables) and Non clustered indexes is the best way to distribute your existing data.  you may also move all non clustered indexes to the new table...

For some reason SQL Server is not able to identify the index. 

Run sp_help <tablename> and see if it shows this index name or not.

if not, run DBCC CheckDB (<dbname&gt

You need to protect MDF files using the NTFS Secutiry.  Grant access rights on the SQL Server Data Folder to the SQL Server Startup Account only and Remove access rights...

Nitin, could you please explain the issue in detail. 

If you do not want others to have access to your database, remove the database access to those logins and they will...

It seems to be some kind of "In Memory" corruption, i.e the page is getting corrupted while being read from disk to RAM (either due to some issues in RAM...

It seems that there is some issue with your MSDB database, probably TLog / Data Files are either full or corrupt.  Please take a look at the Errorlog for any errors...

SQL Enterprise Manager does not refresh automatically.  Try refreshing the Job by right clicking on the "Jobs" on left side pane and selecting Refresh, or by right clicking on the...

One common reason for this behavior is that SQL Server could not find / access the Transaction log file of the database.  check out your ErrorLog for errors (something like "Device...