Is the question really dumb or has nobody done it before? LOL

Here is the script I came up with to finalize the permissions on all of our servers. If someone would like to add some error handling please do so.

EXEC master..sp_dropsrvrolemember...

It couldn't be that simple, could it???? @:-)

I did some testing in SQL 2008 and found a way around the sysadmin role. Here is the minimal permissions needed for backup and restores.

Server Level Permissions:

*dbcreator

*public

Database Level Permissions:

*db_backupoperator

*db_denydatareader

*public

Here...

Here is what I finally did to accomplish task:

navigated to the folder containing all the Stored Procedures

Ran the following command c:>\dir /b >c:\SP_File.txt

********* SP_File.txt ************

vm_my_StoredProd1.sql

vm_my_StoredProd2.sql

vm_my_StoredProd3.sql

vm_my_StoredProd4.sql

~ truncated

**************************

Opened the SP_File.txt in...

Thanks for the reply but I need something I can take with me to justify the seperate LUNS for tempDB and Logs.

It makes sense now. Thank you for the replies!

My college professor told me that the varchar data type doesn't take up disk space but it does affect memory allocation. Is that not true?

They also created a clustered...

Those results look normal but you'll have to run the tracert when you are getting the time-out errors. Are you sure that was test across the WAN from PlantA to...

You have a networking issue like the others have stated. Use two different workstations and ping two different servers at the same time. This will tell you if its...

The first couple steps is process-of-elimination.

Run the following command from a workstation that is getting the errors.

C:\>ping -t MYSQLSERVER>c:\monitoring.log

Let the ping process run all day and make sure you...

How often do the errors occur, once or twice a day or every 15 minutes?

Is everyone in the plant getting the errors or a selected few?

What time of day...

It was an orphaned account in the MSDB database. The following two commands fixed it.

exec sp_change_users_login ‘report’

EXEC sp_change_users_login 'Auto_Fix', '##MS_PolicyEventProcessingLogin##',NULL, 'Password01!';

Are your disk spindles shared with other applications? Does it happen to be a NetApp SAN?

Thanks for the reply but I had a blonde moment there. I combined two different questions I was going to ask. I'll re-write them later from home.