Viewing 15 posts - 5,986 through 6,000 (of 7,429 total)
How are you handling the export itself. Thru DTS or a user end application. In either case the query recordset can come from a straight sql statment or view or...
May 9, 2002 at 10:49 am
Unfortunately like you I find nothing else on this either. I was just taking the standard stab.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
May 9, 2002 at 9:36 am
If it is an ActiveScript you should be able to invoke from inside DTS or even a Job use Operating System Command.
"Don't roll your eyes at me. I will tape...
May 9, 2002 at 9:28 am
Sorry it does not support macros at this point. There is probably a similar tool out there but I don't know of one.
"Don't roll your eyes at me. I will...
May 9, 2002 at 7:21 am
Sorry, you have to go back and set each existing login to use the new language. Default language only affects new logins.
Excert BOL
quote:
May 9, 2002 at 6:14 am
Check you references to make sure it is using the right DTS component. May not be locating due to a version difference.
"Don't roll your eyes at me. I will tape...
May 9, 2002 at 5:55 am
I have not heard of any bottleneck issues related to Logouts. The only issue I think would be a high number of logouts and logins for the same user repeatedly...
May 9, 2002 at 5:46 am
Usually you can start a DB in single user mode or the server itself in single user mode. But if you have connections until they go away they can lock...
May 9, 2002 at 5:41 am
Coding standards are great but seems you always have someone who just plain ignores them. Which is a shame.
As for DTS I suggest you make a name that will organize...
May 9, 2002 at 5:36 am
I have tested with Diskeeper and say it is a great utility and only saw issues when server load was high (note: Windows 2000+ defrag utility is based on Diskeeper...
May 9, 2002 at 5:27 am
The mention of grouped procedures is a plus in your article. However I do not use for version control. For me these are queries that I related to one another...
May 9, 2002 at 5:08 am
Personally my goal it to limit most queries to 180- seconds for any major query run, if it cannot be done in that timeframe as most of the major queries...
May 9, 2002 at 4:59 am
Another spot people miss is did they connect to the DB in EM. Close EM to release connection or change DBs.
"Don't roll your eyes at me. I will tape them...
May 9, 2002 at 4:47 am
Cpu utilization in relation to what? Mostly no but you can get some cumulative times and estimates.
"Don't roll your eyes at me. I will tape them in place." (Teacher on...
May 8, 2002 at 8:02 pm
Viewing 15 posts - 5,986 through 6,000 (of 7,429 total)