Viewing 15 posts - 9,181 through 9,195 (of 9,728 total)
You want scary documentation?
Google "SA Account" or "SA Account best practices". This should come up with plenty. Especially since so many worms & viruses use the SA account...
January 10, 2008 at 4:37 am
And then there are global temp tables that start with 2 pound signs (##d). These tables are available to any connection using the database so long as there are...
January 10, 2008 at 4:21 am
You're also going to have to create your destination data source before you do anything. Once you've done that, add a Data Flow Task to the Control Flow. ...
January 10, 2008 at 4:16 am
You know, it occurs to me to add a few more replies to the original post.
RE Q#2) Yes & no. If you're new to SQL 2k5 or haven't used...
January 9, 2008 at 4:15 am
The only way that kind of lazy works IRL is if you have a boss that doesn't care if you can actually adminster or develop on SQL Server and allows...
January 9, 2008 at 4:05 am
Thanks for the response, Steve. I'll just use the general search again, then.
January 8, 2008 at 9:20 am
As far as question # 1 goes, make sure you download the errata for the book (regardless of version) before studying. Every version of the book has its...
January 8, 2008 at 7:33 am
FORFILES?
I haven't heard of that command. It works in the command shell?
January 8, 2008 at 3:46 am
To address the original question (though xp_cmdshell can be a major security hole)...
-- This code removes the previous day's backup from this folder
--BIG NOTE: This code is dependent on the...
January 7, 2008 at 11:03 am
Well, I updated my Batch size and Max Commit to 10000 and set my sources as queries. Started the run about 1 & 1/2 hours ago and already I...
December 19, 2007 at 10:45 am
I am filtering in the source by Deselecting all the columns. DIdn't think about the effect that would have... I should probably change that to a query instead.
I did...
December 19, 2007 at 8:44 am
Microsoft doesn't usually tell how they score the tests, but 700 or more has to be the total score you get in order to pass (I believe).
Used to be you...
December 19, 2007 at 7:40 am
Well, I passed. Should have rescheduled though. I hurt my back a few days before the exam, so didn't do as well as I wanted to because all...
December 17, 2007 at 3:48 am
Timothy,
You have a lot of good points. Unfortunately, per the privacy policy at my workplace, I have to inform X number of people to get the request signed off...
December 14, 2007 at 12:47 pm
Viewing 15 posts - 9,181 through 9,195 (of 9,728 total)