Got it

Select * from Xyz where Customer_Id in (Select Customer_Id

from Xyz

Group by Customer_ID,Product_ID

having  Count(Customer_ID) >= 2 )

check sp_trace_create

Yes I have done UNION and a join to get other missing column. But I do need to find out the duplicate values for each column

Strange I don’t see the mail icon, even after i installed the Out look client on the server. Is there some thing that we need to do to see...

I take my word back. Actually the tables are not exactly the same however there are some common columns. I need all the common columns + one more...

Got it

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=132290

May the status is closed and there is active customer data for that customer

Got It

Select emails from EmailTable where

Emais <> '' AND

( patindex('%[^-.@0-9a-zA-Z]%', emails) = 1

OR emails NOT like '%.%'

OR emails NOT like '%@%'

OR...

Thanks Steve. That help little bit. Here is what I come up with

Select customer_id,email_address from  Emailtable

Where                                                                                                                              -

 (email_address  Not like '%.%' OR...

Thanks Bill. I agree with you

You don’t need to drop and recreate. Simple check the box “Clustered” it will automatically converts to clustered PK. I did this a while back in EM for a...

You can convert a non-clustered PK to Clustered PK even though there are chilled tables referencing the parent table. It might take longer time depends on how big is...

You sure can take the file backup in the EM. You just have to specify which FG or File you want to take the backup. Don’t forget to take...

In general Indexing makes your log file to grew depends on your recovery model. If you want to keep your log file small re index first and then shrink...

Make sure your database is not a simple recovery model. You can not use FG backup for a simple recovery model database