Is there a particular reason you app cannot support alternate code pages. The reason for your error is the difference in the character set availble in those code pages. I...

Notice the difference here

EXEC SP_EXECUTESQL @SQLSTRING, N'@num_rows int', @num_rows=0

and

EXEC SP_EXECUTESQL @SQL_STMT, N'@CHECK_CONSTRAINT_VALUE VARCHAR(200) OUTPUT', @CHECK_CONSTRAINT_VALUE OUTPUT

Your varibale is not designated for OUTPUT.

"Don't roll your eyes at me. I will...

Try this variation, should work nicely without the need for the extra varibale.

Plus if you get a select then it has to be in the exists statement where that value...

A simple way is to utilize one of the MS system sp's to cycle thru the DB's.

sp_MSForEachDB '

USE ?

EXEC sp_dropuser ''MyUser'' '

This will go thru all the databases and remove...

The data is stored in an image datatype in sysdtspackages but have not looked at an extracted version to see what it looks like. However, if you right click the...

If you have not done so already you should do the latest Service Pack. There is a known issue with SQL 7 that was fixed in one of the SPs,...

Not sure, but try attaching to another server to see if you can get it up. Also, the master may have it marked as suspect, try sp_resetstatus with it down...

If the records do not have anything to identify them then you have two options. One add an IDENTITY column to the end and query for the maximum unique value...

You might could query out the rest by either doing the as a subquery or as part of the query.

WHERE (termnum IS NOT NULL AND username IS NOT NULL AND...

Not sure, can you post the VBScript making sure o remove security info. I need to see how you got to this poitn and what may be missing. Maybe Andy...

If you name the column it would appear in the same on all tables then you can quickly do like so.

sp_MSForEachTable '

PRINT ''?'' --For easy reference.

SELECT * FROM ? WHERE...

It happens, posting once pretty much will guarantee a view of it as mos folks use the Active Threads item to view the discussion board (at least I do).

"Don't roll...

Shahgols what version of SQL are you running and at what SP level, also what OS and SP level. I got your dump and too note of

--- 1st chance Access...

I personally try to find a set based or cursor solution only when performance will show a gain with enough impact to warrant. Yes sometimes set based solutions can be...

Glad you found a solution for yourself just wanted to go a step further on one comment. Gregory Larsen's would look like this and may offer some bennifits in the...