I wanted to do something similar to this myself. I could not get it to work and was finally told by someone from MS (at least they said they were),...

Do you run all of these and get no errors?

DBCC CHECKDB

DBCC CHECKCATALOG

DBCC CHECKALLOC

How about a Chkdsk on the disk where the DB files are stored?

Chris

It seems that Reports Server can't use Windows Authentication, because Reports Server appears to pass it the authentication for the web server, not the authentication from the IE user hitting the...

If your company is subject to Sarbanes-Oxley, you may not have the option of letting developers or anyone else run free in the database. If this is the case it will force...

I went through this tutorial, and while everything went smoothly through most of the article, at the end, when I deployed the report, it fell down. It does not want...

I have run into this in Enterprise Manager.  In some cases you will need to delete the user from the SysUsers table in the problem DB manually with "Delete From...

Network Appliance is our NAS vendor. They also do SAN, it just depends on the controller(s) used in the device.

http://www.netapp.com/solutions/nas.html

http://searchstorage.techtarget.com/sDefinition/0,,sid5_gci214410,00.html

http://searchstorage.techtarget.com/qna/0,289202,sid5_gci916335,00.html

Chris

For what purpose is the backup to disk? Most backups are to tape. The biggest two reasons for backing up to disk are 1. because this is the fastest way...

So what about 1434, UDP? 1434 has always been closed off to the Internet on my network, but someone, likely an oblivious client with a dial-up connection, made a path for...

It's unfortunate their labels aren't tattooed on their foreheads, though. It would save us some time.

Chris

It ISN'T an advantage, if you want speed and connectivity. I was trying to be politically correct. The advantage is the redundancy and space. This was how they were doing it...

Yes, a mapped drive is possible, but not usually feasible, because the drive must be mapped under the user profile that SQL Server runs under. For this reason we use...

jtshyman

Yes to all. We have a gigabit segment here, connecting the SQL Servers to the Network Appliance Filers, and store a lot...

I'm not expert, but this sounds like a use for the Instead Of option on a trigger (SQL 2000). If your Instead Of trigger catches the update, you can check...

Jonathan,

Keep in mind that the reason you are doing the delete in batches, as suggested above. is to allow a commit to happen, but continue to run your delete. This allows...