What do you mean by "a built-in SQL Server datestamp"? Do you really think that Microsoft hid code that puts a date/time stamp on every row of data?

SQL...

Your table is being replicated and you want to do this? That means every change has to be sent to the subscriber table and done there also.

You are better off:

1....

Well, since there's no electricity and probably not an endless supply of batteries....my list would have to be the CDs that I really love to listen to:

Top three would be...

As said, the problem was with your master database. Here's a few reasons that might have occurred:

1. The hard drive was removed without SQL Server being properly shutdown.

2....

No. As the BOL says:

sp_changedbowner

Changes the owner of the current database.

-SQLBill

You can't do what you are asking. You cannot query the log file (.ldf).

You can truncate the log file, but not by date or anything else. ...

When I suggested going to Services and restarting them, I did not mean the SQL Server service tool.

Go to Start>Control Panel>Administrative Tools>Services

or right click on the My Computer icon, select...

Open up the job and see what step 1 is. If it runs a DTS/SSIS package, just find that package and see what it does.

-SQLBill

Exclusive mode pretty much means SINGLE_USER mode.

-SQLBill

To put it in multiuser mode you say:

If I try enterring

Alter database RB_Data_Services_MSCRM

set single_user with rollback immediate;

That is the code to put it in single_user mode, not multi_user mode. Try:

ALTER...

Why are you using %% (%sam%, etc)?

If you are searching a text field %sam% will return:

balsam

sam

same

sample

samuel

Instead, do % sam %.

-SQLBill

I think I would have:

1. dropped the primary key

2. ran the update

3. recreated the primary key

I BELIEVE what happened is that, since it was part of a primary key, before...

No problem. I was just going to ask if you had checked to see if:

1. there was a firewall between the domains.

2. if the SP was being run by...

How do you know it is hung? Just because SQL Agent Job monitor shows it executing doesn't always mean that it is. Try doing a Refresh of the job...

First thing to do.

Go to Services on the system. Find the MSSQLServer and SQLServerAgent service. Both need to be started, check that they are.

If they are started, try restarting...