I would suggest you start off by looking at the execution plan of the select statement to ensure that it's not doing a table scan or some other horribly inefficient...

Here's a good thread I found on the Microsoft forums that you can use as a backout plan of 2005 to 2000:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1

Scroll down to PanosTz's post.

HTH,

John

I would store all the user profile data in AD, where the user profiles are. If you wanted to store this data in SQL, you would have to then...

Setting Auto Update Statistics to True doesn't create new Statistics, Setting Auto Create Statistics to True does. Make sure you set both options to true to get the full...

I'm with rubes on this issue. I avoid bit columns like the plague. In a 2000 environment I had tables with 4 million rows with an isActive (Bit)...

Well to give you a hint to the size of the database with the minimal project I described above, BizTalk installs 5 databases upon installation. Here are the databases...

Are you talking about upgrading SQL 2005 to, say, the 2008 beta or something?

To what scale will your BizTalk solution be used? We use BizTalk at my company, albeit for one function. However that one function is running all the time,...

SELECT 32/10 -> 3

SELECT 32%10 -> 2

Is that what you're looking for?

John

Thanks for the suggestions, but I solved the issue with a stroke of dumb luck.

It looks like the problem was because my SQL instance was on the passive...

Any luck with fixing this?  I am also running into this problem with a few accounts in the server, including the sa account.  I've tried resetting the passwords with the ALTER...

So any luck on fixing the problem? I'm experiencing the same issues with a few jobs that I have running. They all import data from a DB2 data...

I'm sure we all have our own opinions on this, but why would you ever append usp_ or sp_ in front of a stored procedure. I've not worked on...