Viewing 15 posts - 39,091 through 39,105 (of 39,456 total)
October 31, 2001 at 10:37 am
This seems like a lot of work. What are these procedures doing? Perhaps we can suggest an easier solution.
Steve Jones
October 31, 2001 at 10:32 am
The other alternative is to import the data into SQL Server into a second table. Then
update the first table from the second table where rows match.
...
October 31, 2001 at 10:31 am
Thanks for the followup and sorry we could not help.
I think in this case you may want to make a permanent table for storing this data. You could prevent collisions...
October 31, 2001 at 10:29 am
Andy and I have a great article coming out on this, but basically, I feel we should view a cerification like a college degree. It is a base level, not...
October 31, 2001 at 10:28 am
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
Viewing 15 posts - 39,091 through 39,105 (of 39,456 total)