Hi,

Check out the below link on how to resolve Dead-lock things.

http://www.code-magazine.com/Article.aspx?quickid=0309101

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

The best thing is export the source tables with all the grants,Primary key,Foreign Keys and Indexes.

Or

use the below syntax

Ex:

ALTER TABLE ORDERS

ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID);

Thanks --...

Hi,

When you are doing date comparision convert the date to specific format. Can yu post the Table structure with Datatypes.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

Check out the below link. This has the script to change all the object owners.

http://johnnynine.com/blog/HowToChangeTheOwnerOfAllTablesInADatabase.aspx

Thanks -- VJ

http://dotnetvj.blogspot.com

Hi,

When ever you do operations on the Date, Always use convert(varchar, GETDATE(), 101) function to take only date part. Coz in your query you have "=" operaor in this case...

Hi,

As per the database design policy you should not concatinate the fields. May be right now you dont have any requiremnts to update these values but later if there is...

Hi,

In simple words its not possible.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

First of there is no problem with your order by clause. The results are sorted based on the Order by Clause. In your query you have "campaign_id" which is unique....

Hi,

Check out the below link,

http://www.sqlteam.com/article/more-trees-hierarchies-in-sql

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

either you can use columns or * or 1 with EXISTS clause.

The EXISTS clause is based on TRUE or FALSE. it doesn't depend on columns. If you use column names...

Hi,

It would be better if you store this SQL query results into Temprary table and use the table to delete the records from activity table.

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

the order of the where condtions doesn't play interms which one to execute first. It depends on the columns which you are using in where condition has indexes or not....

Hi,

I am not sure what problems you are facing, but check out the below link

http://msdn2.microsoft.com/en-us/library/ms186273.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi,

You can use UNIQUE constraints to make sure that no duplicate values are entered in specific columns that do not participate in a primary key. Although both a UNIQUE constraint...

Hi,

what kind of relationship you have in between A & B?

Thanks -- Vj

http://dotnetvj.blogspot.com