Hi

just try for Triggers.

Hi

use union...

See the example as follows:

create table #a

( sno int not null,

sname varchar(10)

)

create table #b

( sno int not null,

sname1 varchar(10)

)

create table #c

(

sno...

Hi

Check this link...

http://www.sqlservercentral.com/Forums/Topic183187-5-1.aspx#bm183979

Thanks

jaypee.s

Hi

Tell me why do you want to create foreign key like this....

Please check this link...

http://www.dbforums.com/archive/index.php/t-1097776.html

http://msdn.microsoft.com/en-us/library/ms175464.aspx

http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

Thanks

jaypee.s

hi

First change the datatype as varchar and datime.. it will work...

create table #a

(a text

)

alter table #a

alter column a varchar(10)

alter table #a

alter column a datetime

[font="Comic Sans MS"][font="Comic Sans MS"]Hi

This link may be useful to you...

http://msdn.microsoft.com/en-us/library/ms190920.aspx

http://blogs.msdn.com/ikovalenko/archive/2006/12/03/alter-database-alter-collation-forced.aspx%5B/font%5D

Thanks

jaypee.s[/font]

Hi

Please post the exact error description...

You can use like this, with in a transcation.

if object_id('Table Name') is Not Null

Begin

Drop Table Table NameEnd

Go

if object_id(column nmae) is Not Null

Begin

...

Hello

If object exists, u can proceed.

For example..

if exists (select * from tempdb.dbo.sysobjects where name like ''USFRET..v_ProdExtend_Exclude#')

Then go ahead for insertion...

This way you can check for all object....

Thanks

jaypee.s

Hello you can do replicate for the same table name and same data types which exisits in both the databases or servers.....

For example :

If you have table A in...

Hi sathish

We can do by query..

Select * into databasename.dbo.tablename_bakcup

from tablename....

by this we can take a back of one table... not with tools.

Hi

Take a full backup of database1 and restore in database2. and use Transaction Replication.(real time) for both the database in sync. When ever the inserte, delete, update happens...