Be careful when using the upsize tool.  It will create the tables and come 90 - 99% of guessing the properly data-types and sizes (usually closer to 99%)

UNfortunately, ANY PKs,...

Another thing to check might be as simple as what does this user have up and running that others dont....

May be some "unofficial" software has crept onto the machine either...

I think the problem might be the fact that the tran1 doesn't really do anything in the example.  Have you tried having it INSERT a record into a "play" table with...

Personally speaking I prefer Allen's method.  Table variables UNLESS used for small lookup only type stuff I have found to be BAD..  I know we debate this all day long...

Sounds like MrSQL gave you the first half and your 2nd half you need to

DELETE FROM table2 WHERE AccountID IN

(SELECT T2.AccountID

  FROM table2 T2

    INNER JOIN table1 T1 ON...

Try researching

EXEC sp_change_users_login 'Auto_Fix', 'UserNameHere'

More information in BOL

What about something like the following?

SELECT [name], '01/01/1900 00:00:00' Processed INTO #dbnames

  FROM master..sysdatabases WHERE [name] NOT IN ('master', 'model', 'msdb', 'tempdb', 'northwind', 'pubs')

SELECT * FROM #dbnames

DECLARE @Loop INTEGER

DECLARE...

Please post replies to :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=127183

same question and will help maintain thread.

the .ldb is autocreated by Access when an Access DB is opened.  Sounds like the Access DB is not being closed upon completion of the DTS package.

I would check the...

I would also make sure that the job owner has access to the databases and has permission to backup the databases.

Have you tried a tab delimited output or comma delimited output with the extension of CSV?  I know that I did this at my last company and never had to...

Couple of things to check

1. Are you typing the server name in correctly?  ie NOT \\Server but Server
2. Are you attempting to connect to an instance?  ie Server\inst2
3. Do you have the...

As far as I can tell you cannot start it via native SQL commands.  Did find this in BOL

sqlagent Application

The sqlagent application starts SQL Server Agent from the command...

Can you build in a step that does a "sleep" step or modify the unzip step to not start until all 4 files are there?

I think that you can do the following:

SELECT (EXEC sp_help_job @job_name='job', @job_aspect='JOB') INTO #tempTable

Or some variant thereof.  Should be able to find more info in BOL OR...

You could query...