I meant updating sql server 2008 R2 database with sql server 2000 (i.e. 2000 >2008) ?

I successfully restore the 2000 database into 2008 but what i need to know is...

Ok...waiting for an helpful repli which will be a treat for me......

msdb...database is in SQL data folder but dont know how to restore packages and got a link which helped...

I used DTs packages to update destination database and I simly execute it by selecting a package > right click >execute package.

Error occur due settings not done for Tranfer Data...

Any article specific to my iisue that can help me out ?

we are using DTS packages currently to update my online database and need to update the same...

Oh! but thanks and I will sure do that ....but i am quite a newbie to linked server etc:-)

I checked your link and trying the solution provided....

but need to know as it has any limitation or dis advantages on database transactions etc

Thanks alot 🙂

I tried ur solution but stilll code return the same result as my query return ....

MY Trigger CODE:

ALTER TRIGGER [dbo].[TRG_MessageInBox]

ON [dbo].[messagein]

FOR INSERT

AS

BEGIN

DECLARE

@visId int,

@gsmnoV nvarchar(30),

@gsmnoO nvarchar(30),

@msg nvarchar(160),

@gsmnot nvarchar(30),

@sendert nvarchar(30),

@receivert nvarchar(30),

@msgt nvarchar(30),

@senttimet nvarchar(30),

@receivertimet nvarchar(30),

@referencet nvarchar(30),

@statust nvarchar(30),

@operatort nvarchar(30),

@msgtypet nvarchar(30),

@voltage nvarchar(30),

@north nvarchar(30),

@east nvarchar(30),

@mtime...

Thanks alot for responding and I check its perfect but do i need to add 'XX' to my string as My string is a message from another table ?

I...

thanks

Thanks alot for the links related to triggers ,As I am serching for some useful stuff related to trigger but didnt got anything related to that

I am new to triggers and also to T-SQL,just did simple queries with joins in sql server.Ii dont have any idea of that 🙁

code resolve my problem regarding insertion except it split Luman i.e. 0.372 value from string and saved in mcompraser column i.e. 1 in given string,and shows null in mluman...

those two foriegn key column can map,If i know how to map others .

I select ka fk column values by selcting them with some criteria and map theses key with...

Where and how to map my table column name with the values that are splitted from the code :

INSERT INTO @details_Tb(mvoltage,mnorth,meast,mtime,mtemperature,mheight,mcompraser,mluman)

VALUES (............................)