We're already in mixed mode and thanks for the link. Another option would be to write a script that would get a list of all SQL logins and then...

We ended up following robertk's suggestion and set up a scheduled SQL job to run the SSIS package from a command like this:

dtexec.exe /FILE "d:\Program Files\Microsoft SQL Server\90\DTS\Packages\mySSIS_job.dtsx" /MAXCONCURRENT "...

We use Litespeed for SQL Server for backups and I was hoping to see those features included with SQL 2008 Standard (e.g. backup compression/encryption). I also hope to see...

The error log got wiped when I reinstalled SQL Server. Once this problem started I wasn't able to take any backups so I'm not sure how I'd recover the...

We weren't able to do anything with msdb via SSMS or t-sql and it was discovered that tempdb was hosed as well. I ended up just detaching the user...

Any attempt at a restore fails with the message:

Database 'msdb' cannot be opened. It is in the middle of a restore. (Microsoft SQL Server, Error: 927)

Thanks for your reply. That was actually one of the first things I tried. I started the service with "start sqlservr.exe -c -T3608" and then I was able...

One more question about the placement of transaction log files. What is the most important?

1. Having the transaction logs, data, OS etc on a separate controller/channel?

2. Having the transaction...

Thanks. I will download a evaluation copy and check it out. Anyone else have experience with SQL Data Compare?

Thanks for the links. I will check them out as I'm not sure how to calculate how large the tran log needs to be and maintain that size. ...

Here is some additional info about the RAID controller:

Controller Smart Array 6400 Controller

Bus Interface 64-Bit PCI

Controller Location Slot 10

Array B

Array Type...

Thanks for everyone's reply. The OS is on a separate mirrored set using the on board controller. The data and logs are on a RAID 5 array on...

Correct, but in both cases that stored proc would have to be present in the user databases where I need to reindex. What I'm trying to achieve is to...

I would like to schedule a script to perform reindexing on a regular basis. Something like this: http://www.sqlmag.com/Article/ArticleID/96059/sql_server_96059.html

The script mentioned above doesn't allow you to specify a...

Thanks for your response. This works great for short commands but I run into syntax errors when I paste in a large chunk of code, such as to create...