WITH (HOLDLOCK XLOCK ROWLOCK) is probably what you're looking for if you don't want anyone to be able to read the row.

You can try disabling page locks for the index your query is using maybe and then try the UPDLOCK clause to make sure the row still gets locked;

ALTER INDEX <INDEX_NAME>

SET...

You can use the WITH UPDLOCK clause in your update query.

There's a good thread on it here;

http://stackoverflow.com/questions/1921091/thread-safe-sql-transaction-how-to-lock-a-specific-row-during-a-transaction

You can maybe look at building an array using the ISDATE() Function, or updating a flag field to return invalid entries...

i.e;

You can export the table to a test area, and...

It's pretty difficult to distinguish what part of the date corresponds to month or day or year, when you use free text entry, but a good place to start, if...

As with most things in SQL Server, it's more of an art than a science.

Simple answer is, "it depends".

In most cases, where tempdb is handling relatively small objects where statistics...

Ah yeah should have read the title...likely to be a driver issue if trying to connect to/from Oracle.

May be path related, tnsnames related or driver related.

Check those first and you...

If the log shipping chain is broken and you don't have copies of all logs from the primary database, you have to take a full backup of the primary database...

Any suggestions at all for either removing the user references altogether (outwith the web front end, which I am encountering the failure on), or for resolving the duplicate issue?

If anyone...

It depends on how many other users are using a generic login like "sa".

The audit results will only be as good as what goes into it.

If app connections are made...

So you're basically wanting to kick users out if they haven't worked on the table in the previous 3 hours?

Or are you just wanting to flag records which haven't been...

When you say "side by side," do you mean that you're going to install a 2012 instance on the same box, or that you're basically going to have a separate...

You've basically not uninstalled cleanly.

Go to Add/Remove Programs and make sure the 2 features coming up in the error message are removed.

If you've "deleted some of the directories" and these...

What type of connection are you trying to make?

Just to a SQL 2012 server?

sp_configure show_advanced_options, 1

reconfigure

Then just run sp_configure

Look for the xp_cmdshell "configured" value.

If it's 0, its disabled, if its 1, its enabled.