I don't understand your question. If you have a file (or a table in your database) with column mappings, then you have to seek in this table for a corresponding...

You can use system views sys.objects and sys.columns to check, if the columns exist in your tables

Information on views:

http://msdn.microsoft.com/en-us/library/ms190324(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms176106(SQL.90).aspx

I looked in the system procedure sp_add_job where the error comes from. you have an output variable @jobId.

EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'Job1',

@enabled=1,

...

JPster (11/27/2008)

---

when i actually ran the script it creates a job for the first DB and gives the error for the rest of the DBs, but if i ran the...

I can tell you, that on the SQL server 2000 the rowguid columns will not be removed

Left(Coalesce(@String, '') + '----------', 10)

You can achieve this with following query:

Select *

From tempTable

Where ID <=

(

select MIN(ID)

from tempTable T1

Where

(

select Sum(TmePeriod) from tempTable T2 Where T2.ID <= T1.ID

) > 20

)

But I'm not sure,...