I haven't done this in a while but doesn't

(col_c, col_d) In (val1, val2)

translate to

col_c IN (val1, val2) OR col_d IN (val1, val2)

which I may be wrong but if that...

First off these two don't match

FETCH NEXT FROM crsPart INTO @part_id,

@ccNo,

@LastStatementDate,

@LastAccountSummary

UPDATE FDE_TRANHISTORY SET LAST_STMNT_DATE = @LastStatementDate,

LAST_SUMMARY_DATE = @LastAccountSummary

WHERE accountnumber = @cardno

I have four variables of which two are...

If you are using SQL 7 the the previous will work but you cannot use a table variable. Instead you need to create a #temp table then parse each into...

I don't recalll it being the case but could be a known issue needing a Service Pack install. If you have the latest and greatest service pack then use SQL...

This happened to me previously where I was getting the the code for a carriage return and the code looked like it was inline to SQL. I don't remember from...

Sorry you cannot do this. You could do with a temp table then add a int IDENTITY column and use a while loop with variables to move the data from...

Another possibility, DBCC may see errors but not report an underlying issue. Specifically if you have a drive with bad sectors. This from what I have had to deal with...

Try

sp_MSForEachDB '

PRINT ''----------------------------''

PRINT ''?''

PRINT ''----------------------------''

EXEC ..sp_change_users_login ''report'''

Should give a nice output for all the DBs and allow you to see what data is from where.

"Don't roll...

Sorry the tool was built with the Server aspect in mind not really the database. No matter what you do it goes out and gets all the data thru various...

I don't believe you can.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Yes, MSDE is Microsoft SQL Desktop Edition.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Not really any specific books that do that. This site and http://www.sql-server-performance.com have been most usefull to me. A lot of things are learned by experience and testing as each...

Sorry, no go. Only one distributor database per publisher. Try using profiler to monitor the transactions for a specific spid or database but I haven't tried and don't have in...

It may be a threading issue. Or DB2 is busy and has not returned the data. If you can get details see if the queries are still running on the...

Take a look here, I believe if not the same in 6.5 then there is something similar. http://www.sqlservercentral.com/columnists/bknight/renameserver.asp

"Don't roll your eyes at me. I will tape them in place." (Teacher...