Viewing 15 posts - 2,311 through 2,325 (of 2,462 total)
please read below articel..you will idea to configure Linked server
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 24, 2008 at 6:01 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 24, 2008 at 3:25 am
hi
Insert into webdb.database_name.dbo.table_name
seelct * from table
this will work
bhuvnesh
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 24, 2008 at 1:41 am
Can u provide the trigger script and sample data from the table associated with that trigger...after that anyopne can porvide you better help 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 24, 2008 at 12:17 am
can anyone provide any help !!!!!!!!!!!!!!!!!
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 17, 2008 at 11:31 pm
no buddy ......Nothing like that !!!
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 2, 2008 at 9:05 pm
so i cannot insert that SQL table data into Excel(Placed at local drive)
Am i right ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 1, 2008 at 1:42 am
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2008 at 6:29 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2008 at 5:34 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2008 at 4:39 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 28, 2008 at 2:06 am
hi ken,
thanks it works:)
but can u explain the whole scenario.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2008 at 5:33 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2008 at 5:10 am
thanks buddy it works !!!!!!!!!!
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 10, 2008 at 12:04 am
hi mahesh ..iys not like that i have liniked the server buyt still this error occurs..
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2008 at 10:34 pm
Viewing 15 posts - 2,311 through 2,325 (of 2,462 total)