I'm just glad that the statement written is ALMOST grammatically correct english versus.  IF articles written in past THEN ELSE....

Put square brackets around it:

[primary_db_server\sql2000]

sp_changeobjectowner 'some1.object', 'sa' ???

please see comments in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=161630

#TEMP tables do not show as being able to be selected as SOURCE/DESTINATION.  There are two ways to get around this.

Have you tried assigning the DEFAULT for the column that you want to populate to be NEWID()??  This way you don't have to worry about it?

This is one feature that SQL2K5 has finally been able to provide SANS dynamic SQL..

Try using the Search on the toolbar, type Domino, select all three options and search.  Several articles on what you are looking for

SELECT TOP 1 DateFirstEntered FROM Status

WHERE DateFirstEntered > DateCompleted

ORDER BY DateFirstEntered ???

Is SQL Agent configured as a DOMAIN account or localsystem?  I would change SQL Agent to be DOMAIN account ...

#1 creating sp_name stored-procedures are not good.  The system tries to search master 1st and then your user database

#2  Are you explicitly creating as dbo and looking for dbo in...

Check the job history of the job and it will tell you the step it failed at (click the show detail checkbox).  From there you will have to examine WHAT...

The problem is basically... This won't work.  SQL interprets your passed in parameter as a LITERAL and not an ARRAY.  There are 2 different ways to approach this. 

1.  Create a...

I prefer using the Jimmy Hendrix extended producedure "Purple Haze"...

Try this

Dim MyDate, MyShortDate

MyDate = "1969-10-19"   ' Define date.

MyShortDate = CDate(MyDate)

MsgBox MyDate

MsgBox MyShortDate

Don't ask why this works and the other doesn't....