See the bottom 2 articles referenced in my signature for an explanation of how to do it. Here is some code that should work:

IF OBJECT_ID(N'temp_tests', N'U') IS NOT NULL...

Here's code that does it dynamically so you don't have to change the code when you add attributes. The only thing I don't do is provide a set order...

Not to nitpick, but what if there are milliseconds on the date? You are much safer using >= and < when dealing with dates.

Yeah, definitely do not do the convert to varchar as that totally changes things, let SQL Server do a data compare. Also, be careful with BETWEEN. Check out...

I'd recommend something like this:

DECLARE @temp TABLE (fullname VARCHAR(50))

INSERT INTO @temp (

fullname

)

SELECT

'Doe, Jon'

UNION ALL

SELECT

'Doe Jane'

UNION ALL

SELECT

'Smith Tom...

Yeah, I know you were trying to be funny. I actually almost used unclebiguns here on SSC when I signed up, but decided I wanted to be more professional...

You can see the DISABLE TRIGGER command using SQL Trace (Profiler). It comes through as TextData in the SQL:Batch* and SQL:Stmt* events, it does not have a specific event....

Alvin,

You can refer to me as unclebiguns, I don't mind :-D. I would have provided more in the prior post, but I was on my iPod at the time...

nothing earth shattering and whatever was...

Been hanging around Celko?

Sure you can index on a varbinary column. I would guess, I have not tested, that it might be fastest to run the encryption on a parameter and do...

Duplicate post. Please answer here.

What VPN client are you using?

You might want to check to see if the one with the problem has SPN's setup correctly.

What does sp_lock return for the update SPID? Every question ALZDBA has asked is relevant.

It depends on exactly what you are trying to do with the data. You could do linked servers or use SSIS to copy data to a new database.