Viewing 15 posts - 241 through 255 (of 2,268 total)
pull the power plug and see what happens
this is assuming you have tested this setup in a test environment first.
September 20, 2011 at 8:10 am
if your table names are not fully qualified with the database names, then you could write
USE DB_that_does_not_exist
or similar
at the top line of the query window to force...
September 20, 2011 at 7:57 am
vinayak.v (9/20/2011)
Thanks Steveb ...Is there any process to sync two database
except replication, third party tool ... ?
I always use SQL data compare from Redgate , excellent...
September 20, 2011 at 7:11 am
vinayak.v (9/20/2011)
But ... how to enable and disable the foreign key in script ...
Dont bother with this, they are there for a reason just insert the data the in...
September 20, 2011 at 7:06 am
engrshafiq4 (9/20/2011)
yes the tables are in the same server...how i can write update statement?
go read BOL it is all in there..
September 20, 2011 at 7:04 am
use T-SQL insert into
or
SSIS
from one db to the other..
September 20, 2011 at 6:55 am
engrshafiq4 (9/20/2011)
Now How i can copy whole data from one column in one table and replace the old data in other table'column?
you can do this in SSIS, by using the...
September 20, 2011 at 6:52 am
Cadavre (9/20/2011)
It seems that your DDL script, which I'm sure you provided after visiting SSC more than 200 times, has somehow become detached and in its place is...
September 20, 2011 at 6:29 am
engrshafiq4 (9/20/2011)
Actually when i am going to sqlserver i do not have SQL Server Business Intelligence Development Studio....although i configuration manager i do have ssis having state running
BIDS shouldn't be...
September 20, 2011 at 6:23 am
engrshafiq4 (9/20/2011)
in this case
SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls',...
September 20, 2011 at 6:09 am
engrshafiq4 (9/20/2011)
@SSCrazyi can not use this...no option in my sqlserver2005....can u pls guid me a litle bit?
you can install ssis from the setup disk.
September 20, 2011 at 6:07 am
sqlzealot-81 (9/20/2011)
steveb. (9/20/2011)
i would avoid SQLmail especially since you are runnig SQL 2008.
Why is this? It is a deprecated feature for future versions. However it works in 2008 R2...
September 20, 2011 at 6:05 am
why is there a restriction to use one data flow task?
it makes no sense and means that you will end up having to code SQL statements to do...
September 20, 2011 at 5:12 am
i would avoid SQLmail especially since you are runnig SQL 2008.
September 20, 2011 at 5:10 am
Viewing 15 posts - 241 through 255 (of 2,268 total)