Jeff Moden (8/6/2009)

---

I've not confirmed my plane reservations but I'm 99.99% sure that I'm going to be in Lil' Rhody from 9/6 to 9/12. That means that I'll be...

Jeff Moden (8/6/2009)

---

Grant Fritchey (8/6/2009)

---

I recognize...

Yep, absolutely. Every one is running a different instance. You can't have them share an instance. Each is a different code base showing different versions from @@Version.

Yes & no. You can work directly with the files in source control through SSMS, but you can't work directly with database objects IN source control, no such thing. Source...

Team Foundation Services or (shudder) Visual SourceSafe will both work. Understand, you'll be versioning the scripts that define the objects in the database, not the objects in the database themselves....

How many places was this posted? This is the third that I've seen.

Many, maybe most, of the people who read the forums & answer questions regularly hit most of the...

I'm running 2000, 2005, 2008, Compact and three different versions of Express, all on the same desktop. Luckily I'm only accessing one or two a time or the machine would...

That could be the compile time and the time needed to move the data from disk to memory and from there to your machine. All that adds up. Instead of...

It does depend on what you're trying to do. You can save a query as a view, a procedure, a function... If it's just a pre-defined select statement, you probably...

A CTE can be used multiple times within a single statement, but it can't be shared across statements. If you need to use it twice, you'll either have to create...

I recognize that mood. Have fun!

While I may be that old, I did get my start in IT a little later than...

SSHHHHHH!

I'm feeling a bit stupid. I thought RPG = Role Playing Game.

We've been using Microsoft Visual Studio Team Edition for Database Professionals. It allows us to hook right into the existing development metholodogies with labelling, version control, build #'s, the works....