The only real way to audit deletes would be to set up an audit table and use the DELETE trigger to populate it based off of the sysprocesses data.  You...

Is the purpose of locking the recordset in TableA so that you ensure that only the rows that have been summarized into TableB get updated or flaged in TableA or...

It looks like you have been attempting to cut/paste or attach screen shots to your posts.  Can you post your exact error message that you are getting now.  What account...

What is the error message that you are getting (exact syntax).  Also, check the account that it is trying to start up under, is it a local account, localsystem account,...

What about the MSSQLSERVER service?  This is the one you need to be concerned with.  Make sure it is running.  If it cannot start or is not running, that is...

Man, you all work too much.

SET @Manual_Overtime = 'Find New Employment'.

I work my 40 and go home.  There are occasions where we need to work late to help out a...

You may need to post your table DDL for both tables. 

This will work given there is only one CveContacto, CvePaga, and CveFactura value for each grouping of CvePricipal, CveSistema.

SELECT SUM(ISNULL(CveContacto,0)),

    SUM(ISNULL(CvePaga,0)),

    SUM(ISNULL(CveFactura, 0)),

    CveSistema,

    CvePricipal

FROM tblPosition

GROUP BY CvePricipal, CveSistema

Here...

I'm not trying to sound condescending here, but make sure when you install, that you do not select client tools only and make sure that the SQL Server service is...

So what I'm hearing is that you can add other registrations to your EM if they are remote SQL instances, but when you attempt to register your local instance, it...

When you open EM and look at your SQL Server Groups, does it show a 'Local' server registration?

SELECT Restore_Date

FROM MSDB..RestoreHistory

WHERE Destination_Database_Name = 'YourDBName'

In SQL Server, you cannot issue a rollback unless you have first issued a begin transaction command.  A simple update statement outside of a begin/end transaction will still be part...

Another thing to note is that inserting 1000 values does not necessarily mean 1000 round trips.  Test this out in QA and see. 

Then using dbo.split will not scale either.  Whether you are using a table variable (as dbo.split is) or a temp table, you must insert your values into it.  The table...