Viewing 15 posts - 39,106 through 39,120 (of 39,456 total)
You would have to write something to move all objects and data. There is a DTS task that will do this, perhaps you could schedule the package and use sp_start_job...
October 30, 2001 at 12:36 pm
Paul, thanks for the followup. That's good to know. Is it on all your XP boxes or is it this one alone?
Steve Jones
October 30, 2001 at 12:35 pm
There is no "define columns" on the destination tab. There is a "create" button that allows you to define a table.
the problem, however, is in defining the transformations. There is...
October 30, 2001 at 12:33 pm
I'll admit the error handling is low here. I could add some in ActiveX easily, though http://ftp.exe isn't great for doing this.
I really wanted this solution because I can deploy...
October 30, 2001 at 9:02 am
Personally I hate cursors for doing work, but they are extremely handy in "one time" situations. The nature of this type of problems doesn't really work well in any situation...
October 29, 2001 at 4:40 pm
The constraints and such will still raise their own error. as far as I know, you cannot change this. You have to trap for it and replace the SQL error...
October 29, 2001 at 2:37 pm
October 29, 2001 at 2:35 pm
Not necessarily. There may need to be routing changes as well in the default gateway.
I can ping my def gateway, but one of my servers is on a another LAN...
October 29, 2001 at 2:33 pm
Alternatively, if this is something you will do and not change, or something that is a snapshot of data and not subject to concyurrency issues, you can create a temp...
October 29, 2001 at 11:14 am
If you want all items between today and some sepcified date, then DATEDIFF will work.
This script:
-- today - today's date
-- future date - end of time for which we search.
create...
October 29, 2001 at 11:08 am
Two ways:
1. you can schedule the 1st of the month (or any day) and say every 12 months. Easy in the GUI, have to search in BOL for the script,...
October 29, 2001 at 10:48 am
October 29, 2001 at 10:41 am
October 29, 2001 at 10:41 am
Also, Inside SQL Server by Kalen Delaney is a good resource for this. Pg 926.
Steve Jones
October 29, 2001 at 10:39 am
So far I haven't found one (I'd like to do this as well), but I'll keep looking. Pls post if you find one and I will do the same.
Steve Jones
October 29, 2001 at 10:36 am
Viewing 15 posts - 39,106 through 39,120 (of 39,456 total)