I think you're confused. There's no such thing as standby mode.

If the server is not being used, it's just not being used. It's not in standby mode. You would take...

What is standby? There is no status for a database as standby (http://msdn.microsoft.com/en-us/library/ms190442.aspx)

Is this a part of replication? Mirroring? something else?

A database needs to be online in order to take...

What do you mean by standby database?

I hope so. The first item is people finding people that are in similar situations as you are.

I'm not sure what happened, but I have added back the last code snippet and final para.

Any administrator can disable logins.

I think both are great. The developers at MS can help you understand how things work, and why. And you can influence them to perhaps think about how you use...

Michael Valentine Jones (7/26/2010)

---

It would by handy if SQL Server had an enhanced IsNumeric function that you could pass a specific target data type to, but that's the way it...

That's why I leave my phone upstairs, or down, sometimes when I need to write and think.

We've also turned ours off at offsite meetings, which has helped.

1434 UCP is needed for named instances unless you specifically set ports for them.

If you choose other ports, and you can. We have used 51433 in the past. You...

I think you'd do

exec xp_cmdshell 'del ' + @file + ' /Q'

xp_cmdshell is seen a security risk. I'd set a proxy, and limit the rights of this account to just...

This should depend on your regional settings, but I wouldn't be surprised if all checks on this return 1.

We can only hope it will....:w00t:

Wow, you are on a roll. Very nice.

Makes me think I need to get writin' a bit more.

Brandie Tarvin (7/26/2010)

---

Here, Jeff! Grab this bottle of Brain Bleach!

The...