If you can take a backup after the "went down" part, that is your "tail" and you can use it to restore to a point in time right before the...

In addition: making this in into an uncommited isolation sounds risky!!!

SQL Logins are not "replicable" at least in the standard replication meaning. You can script them out and apply them as you often as you need them though.

Check Your network conectivity ...

Refresh the connection because your windows socket was closed.

Now for the UNDOCUMMENTED:

USE master

exec sp_MS_marksystemobject 'YOURPROCEDURENAME'

USE...

As far as I know that was possible in 2000 only.

For functions you needed additional steps. see:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01l1.asp

In 2005 I don't think this is feasible and I am sure system...

If BUILTIN\Administrators is still there, add your(or any known account) to Windows Domain Admin. Then use that account to log in and reset the sa password.

Cheers.

So far In my experience this kind of paging does not work for large sets. The real solution has always been a combination of finding the First page and let...

because what was logged was just sp_cursor;1 and you probably don't know what each SPID was doing ( 55 and 59 ) at the time, you start by identifying the...

I think the Trigger is the way to go *but* if the transaction rate is too high I would vote for the index. In adition you should convert your "union"...

only if the agent that you are modifying is not setup to run continuosly

ALTER TABLE FCT_MACHINE_EVNT_DTL ADD [WAS_TERMINAL_SESSION50] [bit] DEFAULT 0 NOT NULL WITH VALUES

--- Only one pass

One word: OUTSTANDING!

Or

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

BEGIN TRANSACTION

SELECT * from table

COMMIT TRANSACTION

SET TRANSACTION ISOLATION LEVEL READ COMMITTED

I always make tempdb the default database for all users