Or you can get the properties form the Connection event in a trace, even from the Existing Connection event. They show in the text column. You can also get them...

Check the connectoin settings, specifically the ANSI settings. When these are different, you will get different execution plans for the same query.

did you compare the execution plans? That'll tell you what's going on better than anything else.

ksharpe (3/9/2011)

---

Do you mean by qualifying, specifying the db and table names? if so, I've tried that and still get the error.

Here is the query:

SELECT [ProductID]

...

Sounds like you're not table qualifying the columns in the WHERE clause. Add the table and you should be fine.

tgarland (3/7/2011)

---

Besides the obvious filegrowth setting issues mentioned previously, one thing I found was there was not much use of filegroups. One of the things I like to do...

Which? Three different things were mentioned.

sqldba_icon (3/9/2011)

---

Grant Fritchey (3/9/2011)

---

In general, the way you can tell something is parameter sniffing is not simply if it runs faster or slower, that could be contention or any number...

So for each column in a 200 column table, you need to get a row from a different table in order to understand what that column actually is? Yikes. That...

You're in a great position for a side-by-side upgrade. It's the better approach for upgrading anyway. Install the 2008 server, restore the the 2000 databases to it and then do...

Based on what you wrote (and yes, I read it too), you have two options. First, set up a serveri-side trace as Gail has already suggested. Second, you can try...

We've been using it quite a while with no issues. I suppose it's remotely possible that you could mixed data if you had a lot of transactions all trying to...

In general, the way you can tell something is parameter sniffing is not simply if it runs faster or slower, that could be contention or any number of other things....

It's Grant, and you're welcome.

Beyond validating connectivity and running the DBCC checks, no, there's nothing to do at the database level.

As far as the server goes, you're going to want to migrate all your...