What is the error are you getting?

Thanks, great script... my only change was to return the correct size of backups on servers using backup compression. I basically just changed this line.

select @backupsize = coalesce(compressed_backup_size, backup_size)

I believe in teaching a man how to fish rather than giving him a fish.

1. Go to http://www.google.com

2. Type: SQL Server Security Best Practices

3. Hit Enter

Clustering

Use:

exec sp_change_users_login @action= 'AUTO_FIX', @usernamepattern = 'username';

Only real downside of using the "master" as the default is that if the user is not paying attention o what database they are connected to and not using a...

Is the same as this issue you posted about?

http://www.sqlservercentral.com/Forums/Topic1034234-391-1.aspx

Thanks Perry, I voted on that link. I guess the idea of me ever using this in my Live environment is not going to happen anytime soon.

I would be interested in this too. Anyone got a script to remove the jobs, ssis pkgs, etc. ?

Noel... you just saved me from banging my head on my desk for another 3 hours.

Wow... now I feel really DUMB. :angry:

I did figure out my own problem, and thought I would share it since it took me (i hate to admit this) a...

I just realized I posted this in the SQL 7/2000 forum... I meant to post in 2005/2008. Moderator... please close this and I will repost it in the proper...

Google: Sql Server service principal name

Did you run DBCC UPDATEUSAGE already?

Reporting Services is not instance specific. You point it to whatever instance you want in the RS Config.

Say for example SERVER1\InstanceA has the ReportServer and ReportServerTempDB databases...