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...

Ahhh, if I could hide posts...

I regret not building this in early and forcing developers to re-implement it over the years.

Jim has a good explanation. In short

a) backup started

b) transaction committed (insert/update/delete)

c) backup complete.

Anything that happens before the backup is complete is included.

I fail to see how read locks to a temp table or to a user are substantially different. Perhaps you can list? There are huge sites, places like MySpace, the...