You might want to verify your backup. Below is the link to a simillar issue

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=115255

I agree with Corbin regarding SAN failures. We didn't have any outage in the first one year but have had over 6 outages in the last one year. They were...

You can execute sp_changedbowner 

e.g. db_name..sp_changedbowner 'sa'

Just a short summary. If you want to use more than 2 GB of memory, you will have to do the following

1) Add /3 GB switch in boot.ini to let your...

Do you have any switches in boot.ini file /3 gb or /PAE

I cannot think of anything which can affect the exisiting installations.

Jeff,

we have the same security model for our developers but we also grant them db-securityadmin. FYI. With secuity admin, users can only create roles and grant permissions to user defined roles....

Below are couple of articles you might want to take a look if you want to remove builtin\admin group and run clusters or Fulltext Search service.

For Clusters :

http://support.microsoft.com/?id=263712

Full text Search...

I think that you mighte be having some locking issue. When you put your database in single user mode, you are the only user and hence the procedure runs faster. But...

I believe you should be good with option 1 as you don't have any index and the field is also varchar()

Below are some of the options

1) Try detaching and re-attaching the database and see if it helps.

2) put the database in emergency mode and script out all the data.

3) restore...

Not sure with T-SQL but you can do the below through DMO. If you are not faimiliar with DMO, save the file below as  .vbs and execute it.

dim osqlserver

dim sSQLserver

dim susername

dim spassword

set...

Try executing sp_spaceused for each table and check if any of the tables have lot of free space in it. You can then rebuild your index to get rid of...

I think Novac' solution is the best way. You can use sp_helptext but it has a restriction for procedures above 4000 characters long

1) Take your resources offline.

2) Go to the command prompt and change your directory to the  installation folder of your sql say c:\prog*files*\micr*sql ser*\

3) Change the directory to mssql\binn

4) Enter...