select a1.* from a1 left join a2 on a1.stoptime = a2.stoptime where a2.stoptime is null

This would also work for tables without the same structure, as long as the tables can...

Is 'sqlagent' a SQL account on the linked server with at least read permissions on the required tables?  If you are trying to use a windows account, it won't work...

You can store the results of a stored procedure in a table.  Here is an example from one of my procs:

insert into temp_who exec sp_who

You have to have the table...

You will get the error when TOTAL_LOGIN_TIME is equal to TOT_WAIT_TIME

Kathi

I'm not sure what your question is.  Is it how to pass in the date?

This is how you create a procedure with a parameter:

create proc usp_MyNewProc @myDate dateTime as

In your...

You may need to run sp_change_users_login in the database that you have moved.  I can't tell from your details, but the fact that you are thinking about moving master makes...

I would also try to open the tables from another workstation.  Maybe there is a problem with EM where you are running it.  Also, try to open a table in...

You do deserve to be a DBA!  When you had a problem you couldn't figure out, you went to the right place for help.

The new path must be on the server you are trying to restore to and the folders must already exist.  So, check to make sure this path, H:\mssql\data\data\  exists on...

Look at methods URLEncode, URLDecode, HTMLEncode and HTMLDecode.  One of them should do what you need to do. 

There is a method called URLDecode in ASP that you can use to translate from the HTML.  I think it is a member of the server object.

When you run the DTS package manually, you are running it as whoever you are logged in as.  Can you log in to the SQL Server using the Co-domain/sqlserver account...

Hmmm, now that I think about it, my last response is not the problem, since the DTS package starts to run.

Did you right-click on the package to create and schedule the job using the wizard or did you create the job manually?  I always create the job manually using this...

Check to make sure that sa is the owner of the job.