Viewing 15 posts - 1,726 through 1,740 (of 1,790 total)
Andy, Your suggestion is right on the mark from what I have seen. I'm not sure who started the rumor that AD could be a viable store for data other...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 5, 2001 at 8:10 am
Brian,
Great article. One which I will use to now define my job better with management. Just hope that the "Hybrid" title does not stick in the industry. Maybe their should...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 5, 2001 at 7:41 am
One more in agreement with Nigel. Have an identical setup to what he described for the very reason that you don't know what type of read only querying is going...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 1, 2001 at 11:25 am
I inherited this pain on two servers and I could never begin to understand why it would come into being in the first place. Andy - I appreciate your real...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 29, 2001 at 7:21 am
Microsoft Technet states the following;
"Use sp_attach_db rather than sp_attach_single_file_db to attach a database with
multiple log files. You cannot attach a database that has been created with
multiple log files without also...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 26, 2001 at 3:15 pm
Hey Alan - Long time no see! Actually I have two in excess of 18 Gig and one that is rapidly growing to the size of 35 Gig where it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 26, 2001 at 3:06 pm
Somebody else may have a better / different way of doing this but, I usually use a transform task or a bulk insert task to put the file contents into...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 26, 2001 at 9:13 am
I will usually slap a print in there so that I can see what I am about to run and troubleshoot any formatting issues here. An example using Andy's submission...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 25, 2001 at 8:06 am
bobl - You stated that the "trigger fires the job, and the package works; but the job won't run the package" Have you tried running the job directly from EM...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 24, 2001 at 1:43 pm
quote:
And while you're at it, unless you absolutely have to, do not turn on Case Sensitivity. With both, you will end...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 18, 2001 at 1:47 pm
David,
Very cool!! I love learning neat little tricks like that. Thanks!!!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 11, 2001 at 7:47 am
Ooops! Sorry I meant Steven!!!!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 11, 2001 at 7:47 am
select @@version will get you the information you are looking for.
Versions are as follows
SQL Server NoSP ...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 10, 2001 at 2:41 pm
Both are 7.0! Thoughts? TIA
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 10, 2001 at 2:27 pm
I ordered a set from MS some time ago and have yet to receive. So, go with Andy's option as you will get it quicker!!!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 10, 2001 at 7:39 am
Viewing 15 posts - 1,726 through 1,740 (of 1,790 total)