I looks like the problem was with trying to run the restore procedure from the Database I was trying to restore.  One I moved it to the master database everything...

Thanks for the info

I will try the -g.  I think this make sense based on BOL since one of the areas failing is SQLMail which needs to load a .dll. ...

I looked at your script and I think I now see the problem:

change this table to

create table #tsysxlogins (

 [srvid] [smallint] NULL ,

 [sid] [varbinary] (85) NULL ,

 [xstatus] [smallint] NOT NULL ,

 [xdate1]...

Am not quite sure about this.  The script I have is just for getting the encpyted password off one server and updating the password on another.  We had other scripts...

The query I wrote assumes:

1.  The logins are already on both servers

2.  The logins have the same "Name" on both servers

3.  Only the password is transffered

4.  It is transffered from...

Note: the system turned one of my Close parens into a weird happy face.

I have used this script to pull passwords off one server ( the old production server) and...

Well I finally figured this out.  I am using the Queryout option in BCP to run an sp.  It turns out the problem was caused by a case statement in...

There is a problem in BCP handling querries with temp tables correctly.  I am not exacly sure what causes it.  All I know if that you will have to redesign...

The issue here is actually quite simple .  When you do an if statement it applies to either:

1.  The statement immediately following the if

2. ...

look at the bol for xp_sendmail. You have to have the email setup correctly on the server, but once this is done just pass you query into the xp_sendmail...

The following is what I use to handle optional Parameters:

SELECT * FROM Customer

WHERE coalesce(CustName, '') = coalesce( @CustName, CustName, '')

and coalesce(CustCity, '') = coalesce( @CustCity, CustCity, '')

and...

If the warning is causing problems, just do an "Is not Null" on the Aggrated value in the where clause. I know some .asp code really does not like...

I figured this out. If I turn No Count off and then back on again. It flushes the buffer.

There are at least two ways to do this. Easy but may not too effiecient. Just call replace and replace 16 blanks with one blank. Then call...

When using floating point numbers. The underlying data is stored in a Base-2 binary format. Remember from back in your math classes that is is not always possible...