First, you should be working in a development/test environment and testing your queries before ever getting them even close to a production system.

Next, you can wrap the process in a...

When you attach the database to SQL Server 2005, the database engine upgrades the files. If it did not perform this upgrade - the engine would not be able...

Okay - that is good. Glad we could help.

Lookup SHRINKFILE in Books Online, but here is how you would do it:

Use ReportServerTempDB;

Go

-- get the logical name of the file

Select *

From sys.sysfiles;

DBCC SHRINKFILE(logicalfilename, size);

Replace logicalfilename with the...

The downside to this is that your procedure could only be run for a single server at a time. Trying to run it from multiple connections will cause problems because...

How about using this:

ALTER DATABASE database_name

SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 };

Florian Reischl (3/25/2009)

---

RBarryYoung (3/25/2009)

---

I do these kind of scripts (a lot) and I always concatenate them all together using either the Variable method or the XML method.

The Variable method is...

Yes - on a failover you would have to manually configure those tasks to include the partner database.

When reporting services is installed, the databases created use the default recovery model for that instance. Which is of course the recovery model defined on the model database -...

Flo, with all due respect I think you are working too hard to avoid using a cursor here. Administrative tasks such as creating users in a set of databases...

First issue - you have...

Don't drop the BUILTIN\Administrators group at all - just remove sysadmin access. Yes, this still allows public access to the instance, but does not allow access to the databases...

Jerry - yes, you can specify the full address yourself because you are an administrator and have that ability. However, a normal user would not have that ability and...

Are you on SQL Server 2005?

You are welcome - glad it worked. I just wish MS would expose those settings in the configuration instead of having to find it in the config file. ...