Go to each node type Start --> Run --> services.msc

Check if SQL Server 2005 is installed and running.

Verify the service path and compare to what you find in the cluster...

You were missing a comma to separate the sorted columns ORDER BY @SFIELD, @SFIELD_TYPE

DECLARE @NEW_SEARCH_STRING VARCHAR(250)

DECLARE @SORTFIELD VARCHAR(50)

DECLARE @SORTFIELD_TYPE VARCHAR(5)

SET @SORTFIELD = 'PRODUCT_NAME'

SET @SORTFIELD_TYPE = 'ASC'

SET @NEW_SEARCH_STRING = 'nfl football'

DECLARE...

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%5D

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...