You need to chech the timstamps of the dll's in your binn directory against microsofts list of file timestamps for SP2. There may be other ways to go about it,...

Carl, In SQL, global search and replace for procs is a query useing the command replace run against the right sys table...

Edited by - Scorpion_66 on...

The openquery method is what we use. Works fine.

This is another example of EBCDIC to ASCII conversions that has issues. We encounterd several cases of things like this. Write a BCP input file and strip the last character...

You can do it by creating a linked server with an aliased name then write all your code against the aliased name.

For example:

In Development the server name is DEVSERVER

Alias a...

In the case of a few small traces rather than a large one, it is true that overall the load on the server will be greater. However, the data collections...

I guess more people do the convert than I thought......may not be the best way, but looks like its the accepted way.....

With the select and the update in seperate statements, I believe its possible for two occurrances of this to grab the same row, and the last one to update the...

When you use standby, you should give it the undo file name. That will fix your problem.

I convert my dates to a varchar(12) which drops the timestamp off, then back to a datetime for sorts, order by's, etc....

Don't take this to be the best solution, but...

I agree with antares686. I believe the queries he suggested, which reduce the nesting, will help a great deal.

However, 23 foreign keys is the problem. Why in the world are...

Profiler does place a noticable measure of overhead on any server its run against. The more data and columns in the trace, the more of a load on the server....

It does not have to be in the where clause to lock the column. That was not the reason for suggesting that course, I don't believe.

I believe it was suggested...

I think Gregs answer would be the most efficient. Pad the insert queries to build a common structure. This could even accomodate the ASCII structure you need. Use a Key...

Why are you using a cursor to insert records into a table. If it were to be done with a set based operation, you could left join the table being...