When dts packages are run as jobs, the security context that the packages run under usually changes.  When you run the package manually you are using your login id and...

Ha, nothing like reading the post first d'oh.

To get to the most powerful script generator, right click on the DATABASE NAME, highlist TASKS and finaly choose GENERATE SCRIPTS.  This brings up a script wizard that will allow...

Are you positive that your server is not using a 64 bit processor?  The 64 bit AMD's also run 32 bit apps seamlessly.  Check the processor.  This typicaly error occurs when...

The email did not reach me.

When I get this error message it is usualy telling me that the dbservername cannot be resolved.  I usually start at the network layer with a ping of the dbservername...

Interesting.  The developers may be using named transactions to allow recovery to that point, similar to a point in time recovery.  The RESTORE will remain in LOADING status if you...

The additional time would come from one of two likely sources.  The first is a change in the navigation within the GetChilds stored procedure.  Perform Display Estimated Execution Plan and...

Thats the second time my reply was lost.

Check the named pipe, this is everything after \\.\PIPE, by default its \sql\query.

xp service pack two autoamticaly enables the windows firewall and...

I had to take out the following line to get it to work

rst.Open cmd

The subselect is not necessary, get rid of it, as is the UNION statement get rid of it and add your INNER JOINS directly to your initial SELECT statement.  This...

In SQL books online under locking hints.  You add a with statement and the locking you wish to be applied.  Following is a quick example.

SELECT au_lname FROM authors WITH (NOLOCK)

Can you step through the logon process with the Studio debugger and check that all variables are populated correctly?  I had a case where the USERID went NULL in the...

My first reply was lost, I'll try again. 

ADO.NET is a DB API.  I view this as a layer on top of TSQL.  Since SQL Server always logs changes to...

The master is the pestiest, the database has to be in single user mode, so no other processes can be running.  Start the instance in single user dbo more.  I've...