Personally I would go the scripts route as you have a record of the changes made. Manual would be my next suggestion. Merge may cause issues.

"Don't roll your eyes at...

Look for SQLGUI.dll on your HD and do REGSVR32 on it to register it. May have a registry entry problem. If that does not work you may need to reinstall...

I have tried the split keyboards and have to say I love them except the fact i am a hunt and peck typer and this forces me to try to...

Try deleting the current backup file or rename and then run this.

BACKUP DATABASE [Campus6]

TO DISK = '\\secondary_server\ABTSql\campus6Live.bak'

WITH

INIT ,

NAME = 'Campus6'

and try to restore. I just want to...

Have you tried stepping thru in debug on the app to see if there is something specific that happens? Also try adding SET NOCOUNT ON to the SP.

"Don't roll your...

Should have created a job under SQLAgent that you can disable or delete. Names usually easy to find.

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

Can you post the tables DDL as I want to test here a bit better than just shooting in the dark? Also have you installed any other patches maybe security...

What is the command structure for doing your backup? You may have a corrupted file. Or even what versions of SQL is each server?

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

There was an MSDE 1 that shipped somewhere but I don't remember and was basically MSDE SQL 7.0, however MSDE 2000 should be able to remain compatible with 7 at...

Have you tried recompiling the DLL and replace. Also when you finish with one SP are you closing the connection and reopening? Switching open and closed has caused this to...

Test with this to see if the same thing happens. I am wondering if something is happening to the auto_id value in the cast blowing it up.

CREATE PROCEDURE usp_auto_test

(

@auto_id VarChar(36)

)

AS

BEGIN

Declare...

I tested your case issue and find no problem with it. There has to be something on their end causing it. Do a hand query and post all that happens...

If you hear otherwise let me know. Now you may want to consider getting an MSDE version of SQL which has a few less features, checkout http://www.microsoft.com/SQL/howtobuy/msde.asp . Reason is...

Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q63605 , this should help you.

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

Usually you by licenses in blocks of 5 clients. How do you currently have SQL licensed thou, if not developement license. Price also depends on your version check out http://www.microsoft.com/sql/howtobuy/production.asp...