Thanks

but now i m geeting below error

"

Msg 206, Level 16, State 2, Line 39

Operand type clash: uniqueidentifier is incompatible with int

"

actually

[reg_opt_stub ], [qstn_stub], [evt_stub]

all above...

please read below articel..you will idea to configure Linked server

http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/5/

hi

i m not sure about the error you got ...but seeing your script ..i found that

u r not using full quoted identifier query

like

insert into [linked_server_name].[database_name].[dbo].[table_name]

select * from...

hi

Insert into webdb.database_name.dbo.table_name

seelct * from table

this will work

bhuvnesh

Can u provide the trigger script and sample data from the table associated with that trigger...after that anyopne can porvide you better help 🙂

can anyone provide any help !!!!!!!!!!!!!!!!!

no buddy ......Nothing like that !!!

so i cannot insert that SQL table data into Excel(Placed at local drive)

Am i right ?

Actually ,,,if i have a database with total size 100gb ,used : 87 gb and free 5 gb

then

i would shrink it upto 80 gb

Sorry i made a mistake i always do shrinking if datafiles

but is the main issue if i shrink the data file the related log...

yeah i do agree with ur points

But the thing is that the kind of database structure we have ,on every release(on every 4 month) some tables are dropped ,some...

only two ways are there

1. database snapshot can help you if you have implemented that

2. restore that database bak up with another name , transfer that tables by SSIS...

hi ken,

thanks it works:)

but can u explain the whole scenario.

thanks

but i cant take table variable or temp table ? i need to use local variable .

but if atlast i go with local variable will there be performance difference...

thanks buddy it works !!!!!!!!!!