Yes you can, but you have to give a different name to your restored DB.

RESTORE DATABASE [TEST_restored] FROM DISK = N'K:\TEST.bak' WITH FILE = 1,

MOVE N'modeldev'...

I had the same problem, so I just added a step to be executed on after any step failure.

This is a TSQL Job step that catches the last job history...

How did you transfer the DB?

Did you detached and attached or did you restored?

If you used any of those ways to move your DB to another server, then you ...

Your best way is yo use Database Specification Audits to track your NO DML statements.

You can enable it at a certain time and disable with the job at specified time.

This...

Make sure that you have the right Oracle Client installed.

I know we had problems because the ORA client was a 32 bit version and the Oracle Instance was an x64.

try...

Delete the replication jobs if any and run the sp_subscription_cleanup procedure

No sir,

you are pretty much stuck with that solution, unless you want to create another table with the new structure and then do an insert into, but that will take...

sysusers Contains one row for each Microsoft Windows user, Windows group, Microsoft SQL Server user, or SQL Server role in the database.

http://msdn.microsoft.com/en-us/library/ms179871.aspx

while syslogins contains the login account.

Having a login does...

If you do not want to allow gaps and you know what the gaps are, you can use the "SET IDENTITY_INSERT" statement to insert data into the identity column manually.

Here...

The Best way is for you to add a Try Catch statement.

Look at the image below, there is a code intended to fail and show you the line number on...

You have to use a trigger to monitor DDL changes on any table.

I used the below trigger to monitor any changes to any tables, including the user who made the...

Click on Start --> Run: Type SSMS

if you did install it will open up, or you can get a free version from Microsoft website:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796]

If you are using a Domain account to run your services,

Follow these steps:

1) Change the password in AD

2) Change the Password on the Node2 Services

3) Force a Failover from Node1...

Here is a Trigger that I created and currently use on SQL 2005 and 2008.

It monitors when someone creates a new DB and emails me the information, including the create...

First create the user in the database, the issue this statement.

Make them members of database role 'db_datareader'

and grant them access to create views and SP.

They will not have access to...