Using a leading wild card is going to slow things down. Sometimes in cases where you need it full text search is a decent option.

Andy

Not that I know of. Im currently seeing this on something Im working on as well (the network error part), looks like we have one segment with a lot of...

I agree, use dbo only except in extraordinary cases.

Andy

If the object is not qualified with an owner, it tries to find an object belonging to the current user, if that fails it tries dbo.object. If that fails it...

You'll have to loop through the dbs and execute once per db. Alternative would be to add the user to a server role.

Andy

Changing the lock timeout isnt going to help a lot, better to fix the problem. Start by running sp_who and checking the blocked column - it will give you the...

Just because Im curious, why would you move back to SQL 7?

Andy

If you're connected as sa shouldnt matter what the permissions are. What error do you get when you try the insert?

Andy

Interesting reading. I still think the biggest downside I see in trying to make dynamic sql static is the loss of readability (to me anyway).

Andy

You might consider stuffing the values into a table, then having a job run the stored proc using those values - that way you can run it in the context...

SQL2K has a server config setting that lets you set the default data and log paths. Other than that, what I use is a small app that prompts user for...

Shoot, sometimes I dont even agree with me! No problem at all with disagreeing.

The only reason we had multiple versions out was that some of the features required extended testing....

Possibly you could roll your own. I use embedded sql logins for most of my apps, downside is that one way or other updating them is a pain. I think...

Merge would be ok, as would transaction with immediate update/queued updated.

Andy

Well, it was all about time. We had one primary db for development and initial testing, a second db for more substantial testing. At times that seemed like too many,...