Revenant (6/20/2012)

---

Sure. If a prospective employer...

Hugo Kornelis (6/20/2012)

---

tommyh (6/19/2012)

---

If one wants be really picky "Depends on File System" is actually the right answer.

You can install 2012 on FAT32 and that have a limit to...

The install guide does say that it will be installed side-by-side with earlier versions though, if they already exist on your...

Ugh, I didn't realize that had been depreciated.

Thanks for the question Tom!

Excellent question, thanks Hugo!

There always seems to be a lot of confusion around this.

Interesting! Thanks for the question, and thanks for the additional explaination of the type conversion Hugo!

Very interesting, thank you!

If you are using pass-through authentication with AD accounts and find it occasionally gives you an authentication error, check the time on your servers. The time on both SQL...

Is the server link using pass-through authentication?

I didn't think I'd ever use it either (I can't stand XML), but I've actually run across it twice...

That's a bit frightening. Good to know. I'm glad I've never run into this!

I was a bit concerned they were going to make it available on-line only.

Glad to hear that's not the case.

I used to use the sys.objects table and use Row_Number() to generate arbitrary sequences, but that is dependent on the number of rows in the sys.objects table.

Now I do something...

If you want to avoid using a temp table, you could use a table variable.

Interesting... so you have to roll back an entire project even if you only need a previous version of a single package?