You need to have the package locally. You can import it to your project in BIDS by right-clicking packages and choose Import Package. Navigate to the server and select the...

I view & change the owner_sid in sysjobs to 0x01 which is sa, thanks.

Can I check without kicking of the job & vewing sp_who2.

Yeah the event log says:

Exception happened when running extended stored procedure 'xp_sysmail_format_query' in the library 'xpstar90.dll'. SQL Server is terminating process 144. Exception type: Win32 exception; Exception code: 0xc0000005.

It's blank, I've had try null and the results are the same. The source is varchar(6) and the destination is a flat file.

Never mind I figure out what the problem is, the database was set to Simple and not Full.

My statements is:

Select * from LinkingServer..Databasename.TableName

Since I'm going from a 32 bit SQL Server 2000 machine to a 64 bit SQL 2005 Server I believe I need to...

I've tried a windows login and a sql login.

I'm still receiving the 7314 error message And I ran: osql -E -S linkservername -i "\\Path\instcat.sql" on both servers.

Because sp_send_dbmail, allow me to type what the Subject Line should say instead of having "SQL Server Message" And I am using sp_executeSQL.

The Plain has been created via GUI (Management Studio)

Ok, I'm using sp_send_dbmail but the if my maintenance plain is creating a text document with the date and a runtime as the name of the file how do one...

I have the job set up as to "Notify Operator when job is completed" and the end, that's the last task and I'm wondering should is that the way...

The logic work but I had to change "-30" to "-60" to get within the last 30 days, I wondere why?

closedate datetype is 'datetime'.