I installed SP3a and it seems to work again... Thanks for the brain cycles.

Guarddata-

Thomas is correct.  If this is just an example of something that actually requires dynamic SQL - look at the sp_executesql and use output parameters to get the results.

Guarddata-

OR

INSERT INTO C ( ID, slVarChar, BID )

SELECT A.ID, a.somelongVarChar, B.ID

From B

Join A ON A.somelongVarChar LIKE '%' + B.someshorterVarchar + '%'

Guarddata-

Depends on your queries. Also - at one point, an "empty" string was not possible but always had at least one space (seems like that was a default for...

I appreciate the input. I was hoping there was something I had missed.

Guarddata-

Correct on the restore with Move...

There should be no problems with the logins if you stay in the same Enterprise Manager control

Guarddata-

Yep - the backup and restore should work. Good luck with it all!

Guarddata-

Wish I were home - I have version 7.0 there.

A couple of observations...

1) You can't stop the services or enterprise manager won't work. Do everything without stopping the services.

2)...

I'm running the SQL2000 version, but believe it is the same in this instance.

Right-click on the database. Under the "All Tasks" option there should be a detach database option.

Once...

VGillingham

1) If you have the ability to reinstall Enterprise Manager, Query Analyzer should be part of that.

2) You can detach and reattach via Enterprise Manager

3) I have also been in...

Sure - I understand that. From a performance perspective, I have found the OUTER JOIN to be much better when there are lots of rows. The NOT IN...

Like a lot of things...it depends.

For example, if all you need is to delete the entry after 48 hours if the status is active, you can create a stored procedure

CREATE...

Yeah - null handling in these types of queries is wierd. For example...

select * from table1 where id not in ( null )

will produce no results. The problem...

It appears that you have an interface where the user reviews the records that have been inserted app. Rather than writing the message into the data itself, you may...

What kind of error messages are you experiencing? Have you tried reloading the client software?

Guarddata-