Viewing 15 posts - 4,486 through 4,500 (of 7,191 total)
craighenderson (5/31/2012)
I really only want the data from the PC - and to make sure it isnt accessible on the PC anymore
In which case, you will indeed need to detach...
May 31, 2012 at 5:17 am
But then you still have the database online when you restart SQL Server. Wasn't the idea of the exercise to detach it? If you just want a copy...
May 31, 2012 at 5:00 am
Craig
You may need to use the -S parameter in sqlcmd to specify the server, if you use named instances or non-default ports.
John
May 31, 2012 at 4:43 am
Wow! Took a while to get my head round that, but when I did, it made sense. An INSERT statement has to succeed or fail as a whole,...
May 31, 2012 at 4:30 am
The phrase "beer cooler" is anathema to me, since 90% of beers worth drinking here in the UK are served at room temperature (or certainly no colder than cellar temperature)....
May 31, 2012 at 4:13 am
OK, thanks for all the replies. Plenty to think about here.
Hugo Kornelis (5/30/2012)
May 31, 2012 at 2:55 am
Craig
Does the database have the same name in each case? Why not write an sp_detach_db script that your people can execute on each server? To make it even...
May 30, 2012 at 9:07 am
Hugo Kornelis (5/30/2012)
John Mitchell-245523 (5/30/2012)
I must admit I'm surprised that having SET XACT_ABORT OFF is the default.
I am not. I prefer to be able to handle my errors myself; SET...
May 30, 2012 at 8:49 am
Craig
Probably the easiest way (especially if you are going to do this more than once) is to create an SSIS package to loop through all the servers and detach the...
May 30, 2012 at 8:08 am
I must admit I'm surprised that having SET XACT_ABORT OFF is the default. I take the point that READ COMMITTED breaks the rules of isolation anyway, but I find...
May 30, 2012 at 7:41 am
Right, if it's still not working then run the package in Visual Studio and watch for where it fails. You can then concentrate your investigation in the correct place....
May 29, 2012 at 4:54 am
2)advance editor for ole db destionation -----input.output tab---external columns
-----data type :dt_str
lenght--1
Did you change this as well? You need to go through your whole data flow and make sure that...
May 29, 2012 at 4:40 am
Jim
Connect to the Integration Services server in SSMS, expand the list of running packages, and stop the one that is over-running.
Edit: that's not the best way of doing it on...
May 29, 2012 at 2:32 am
There's your problem, then. You're trying to fit 255 characters in a char(1) column. The column in your table needs to be varchar(255) and the columns in your...
May 29, 2012 at 2:22 am
What is the longest string in column 2 of your text file?
John
May 29, 2012 at 2:05 am
Viewing 15 posts - 4,486 through 4,500 (of 7,191 total)