Phil Parkin (6/20/2011)

---

GSquared (6/20/2011)

---

Phil Parkin (6/17/2011)

---

If you write a lot of T-SQL, consider doing yourself a favour and omit the readability words (AS is one) - it soon becomes second...

Contact their support desk is all I can suggest.

Please don't double-post. You asked the same question in multiple forums, and there's no need to do that. It just fragments the answers and discussion.

You can't directly have a foreign key reference two tables. On the other hand, you shouldn't need to.

If tblMap has a foreign key to tblSurvey, on the survey ID,...

Are you familiar with writing select statements in T-SQL?

Build your select statement, including your Where clause, then put Insert into your target table on top of it.

Are you moving rows...

As always, the problem with these "this post was the solution" features is that the next post, or one twenty posts later, may very be a better solution, or may...

james.morrison 19355 (6/20/2011)

---

You could just dump the results of SP_WHO2 to a table in a DBA database.

Run that in a job schedule for a week or two. Then search...

I'm going to guess that one or more of the tables you are checking against have a significant number of rows in them.

What's the actual purpose of the constraint? ...

The other thing you can do is run a server-side trace filtered for that database ID, and use that to identify processes and commands connecting to it.

This will identify things...

Here's something I built for SQL 2005 upgrade testing. It should work for 2008 as well. It will find any compile-time problems with procs and UDFs, and can...

I've always put SQL Server's binaries in the default location in Program Files on C drive. Can't think of any reason to do otherwise.

Jeff Moden (6/20/2011)

---

Considering that he recently recommended FK's on First and LastName columns and he still uses a While Loop/Push Stack to convert from an Adjacency...

Ditto.

Most of the problems with "Agile" are based on the fact that what they're really doing is Cowboy Coding, and calling it Agile in order to have a buzzword for...

The free version is limited to 1 Gb of RAM, regardless of how much/little data you have, no way around that.

There are ways around the storage limit, but they're technically...

I'm the one who recommended the "go to the store and find some answers" method.

When I was originally learning SQL Server, the "SQL Server Bible" series by Paul Nielsen was...