Viewing 15 posts - 39,106 through 39,120 (of 39,466 total)
I agree. If you are a SQL DBA without Inside SQL Server, you are missing a great resource.
Steve Jones
October 30, 2001 at 8:49 pm
October 30, 2001 at 1:48 pm
Some memory leaks (v6.5). In 7 there were some problems in stored procs with the creation of a temp table within code. Seemed to be fine if created at the...
October 30, 2001 at 1:47 pm
Check that.
On the options tab, uncheck the v7.0 format button and your source columns should appear.
Steve Jones
October 30, 2001 at 12:47 pm
I'd agree to also use a temp table or a staging table. Personally I dislike temp tables, there have been issues in the past with them.
Steve Jones
October 30, 2001 at 12:46 pm
October 30, 2001 at 12:42 pm
I agree with that. Just wanted him to be aware that he may need a network admin.
Not trying to disagree, just trying to add some more info.
Steve Jones
October 30, 2001 at 12:41 pm
I prefer backup and restore, but attach is nice also.
There is an aritcle on the site here:
http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp
Steve Jones
October 30, 2001 at 12:39 pm
Might be better to use an ASP page to insert a "start" value in a table. Then let a scheduled task check for this and run the stored procedure. Let...
October 30, 2001 at 12:38 pm
October 30, 2001 at 12:36 pm
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
Viewing 15 posts - 39,106 through 39,120 (of 39,466 total)