Viewing 15 posts - 39,346 through 39,360 (of 39,717 total)
Why worry when the databases appear? Maybe just scan for "new" databases and run the backups? Or just schedule the backups for a short period of time after they will...
November 1, 2001 at 10:07 am
I discovered if you uncheck he "7.0 forma" button on the options tab, the source fields are accessable in the transformations tab.
Steve Jones
November 1, 2001 at 10:04 am
yes. the -E will make a trusted connection. If the user installing the program has not been setup in SQL Server, it will fail.
Steve Jones
October 31, 2001 at 5:07 pm
I agree with Andy. I think that this does have a place in meeting business rules or needs. There are times where I would like to allow someone to bulk...
October 31, 2001 at 11:01 am
October 31, 2001 at 10:56 am
If you create the clustered key using the new
filegroup, the data will move. You can then drop the clustered key if you want (not recommended.
Steve Jones
October 31, 2001 at 10:40 am
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
Viewing 15 posts - 39,346 through 39,360 (of 39,717 total)