A little vague as I am not quite sure what you are asking here.

I still doubt that ecommerce sites use your email address as a primary key. This is a volitale attribute subject to change, and isn't one I would use. ...

Start here: http://msdn.microsoft.com/en-us/library/ms177410(v=sql.90).aspx

As Sean said, TRUNCATE is a logged operation. TRUNCATE, however, does not fire DELETE triggers on tables. If you need to know who is deleting data from the...

eamonn.byrne (9/17/2012)

---

Jeff Moden (9/16/2012)

---

Before you use it,...

You would need to break the mirroring and reestablish it using the new port numbers.

Also, after modifying your code to use the table variable provided by the OP, it only returned one row, not both rows (one with backscan = 0 and one with...

CELKO (9/15/2012)

---

>> I'm having trouble isolating some rows in a table. Its an audit table that can have the same values repeated in some fields [sic: columns are not fields]....

stanlyn (9/15/2012)

---

Hi Lynn,

Disregard my prev message. Looks like its sql server's inability to give accurate feedback in real time. Your process completed with the expected results and...

CELKO (9/15/2012)

---

Oh, yes, VINs, good idea except it is only unique during a 30 year time span. That would be a great choice for a primary key to represent...

That's because of a bad cut and paste on my part:

with BaseData as (

select

county_pagekey,

image_tif as bin_data,

'TIF' as bin_type,

...

In a test environment, give this a try:

with BaseData as (

select

county_pagekey,

image_tif as bin_data,

'TIF' as bin_type,

...

CELKO (9/14/2012)

---

It was worse than that! First, the damn thing does not have a check...

CELKO (9/14/2012)

---

Thank you for proving (once more) that you can't take the theory to the practice in a correct way. How can you suggest to use a random number...

Problem is you don't always have that choice.