On a related note: http://www.troyhunt.com/2012/07/heres-why-we-keep-getting-hacked-clear.html

Send to your boss if you still use ASP.

Send to your developers if they don't know about that stuff.

Did the upgrade complete? Are you are R2? It's not clear what's broken exactly.

Also, do you mean you cannot apply SQL Server 2008 R2 SP 1 to the server? There...

Congrats.

sysjobs - http://msdn.microsoft.com/en-us/library/ms189817.aspx

No code this year. There hasn't been for a few years as I haven't been able to work out a deal with PASS that makes sense.

We will likely do a...

I'm in, just slow to register. In the UK for now. Will take care of this when I can

I'd follow Anthony's advice. This is definitely a security issue of some sort. I suspect your installer is somehow running into either incorrect rights, or some impersonation issue.

Full backups don't affect log backups. As long as you have a full to start LS, and all the logs since the full, you are OK.

I would think so, but IIRC, you need to log in with the DAC to avoid these triggers and disable them.

The first checkpoint will break things, as Gail noted. Doesn't matter if you have transactions.

To add to Perry, is you want to separate indexes, you need separate physical drives. Not separate drive letters or LUNs, but physical drives if you are looking for performance...

Didn't see the All Star game, but surprised with Verlander's highlights (or lack of) and no offense. A few great catches by the NL, so congrats to them.

This work? http://www.timeanddate.com/library/abbreviations/timezones/

A framework would be nice.

Looking to fill a hole, or a partial hole, in dealing with time zones in T-SQL.

GSquared (7/10/2012)

---

Should the code be sensitive to Daylight Time vs Standard Time (US), or should it rely on "EDT" vs "EST" in the input?

If sensitive without the input being modified,...

My advice, read the MS docs and lists of skills. If you know them, practice, if you don't, go learn them.

If you don't know much, then go get a book...