That's correct at the DR site there is an identical server where all volumes are replicated at the disk level from one SAN to another SAN over two OC3 pipes...

I didn't say it wasn't possible its just hard to do and as you indicated spending time fiddling around with Process Mon and Reg Mon to make it work doesn't...

To clarify, I use MS clustering for local failover high-availability in an active-passive configuration and no way implied clustering as site failover alternative. For failover to our remote site which...

I would simply say because its Windows. Have you ever tried to run Windows XP without being an admiin?  Its pretty damn hard thanks to the way MS designed OS. On our...

I use clustering over database mirroring. Clustering has its issues also but at least I can use without rewriting the client applications to be DM aware.

Like most SQL Servers...

Nice summary of database mirroring as side note I came with 13 reasons why you wouldn't use database mirroring:

1. Disk space – unlike SQL Server...

Other than the lead in statement, SQL 2005 has been released nearly three years ago when in fact it was released in November 2005 making it only 20 months I...

I had the same issue using bulk insert via share, since the application uses a SQL login I just tested and used the SQL login. If you have to use...

Nice article, here's a list of free/open source tools I've used:

Quest Comparison Suite for SQL Server -- Free version

DBDesigner4 -- (http://www.fabforce.net/dbdesigner4/) Data modeling tool generates MySQL scripts from diagrams,...

I don't think there is an easy native way to do this in SQL Server. Recently I was trying to do some pattern matching on a text field and after...

This thread isn't anything that requires a reply as I do not need help. This is forum is used for sqlservercentral suggestions and to more fully explain my suggestion: When...

That's correct, however the syntax should be

for /f %i in (c:\servers.txt) do sqlcmd -S %i -i C:\myscript.sql

Also you could use osql instead of sqlcmd

A simple Windows command line will work:

for /f %i in (servers.txt) do SQLCMD -S %i -i C:\myscript.sql

It sounds familiar, I've seen some of the Lumigent (Log Explorer and auditing product) use procedures with LE% in the name. Are you running either of these products?

Sometimes restricting access to dbo doesn't work considering some applications have dbo access to the database. In addition single user mode will almost never work if the application reconnects quickly,...