[dba-SQLServer] Copy a database using a stored procedureorfunction

Elizabeth.J.Doering at wellsfargo.com Elizabeth.J.Doering at wellsfargo.com
Thu Mar 27 09:11:35 CDT 2008


I am embarrassed to be held up as any kind of example in this company of
experts. 

I searched BOL for 'copy database', something that I do regularly
instead of bringing my simple questions to gurus.  I got an answer from
BOL in less time than it took JC to formulate his original question.
Which, coincidentally, is much much less time than all the combined
rants on this topic.  

Of course, I've found much to learn, even in the rants, which is what is
continuously wonderful about this list.


Thanks, 


Liz 





-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, March 27, 2008 8:15 AM
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] Copy a database using a stored
procedureorfunction

Yes, Robert, it was a huge waste of MY time, and undoubtedly yours.  It
just shows how little you read from my posts.  I have clearly stated
that I know nothing.  Your response is two pages of stuff that I have no
clue what it is and am entirely incapable of understanding, then you
state that is only half the solution and it is now time for me to go
write the other half.

OTOH look at Elizabeth's solution.  It apparently works and is compact
and readable.  And no snotty "now go learn enough to be worthy to be in
my presence" comments.

Yes, Robert, it was a huge waste of MY time, and probably yours.  

I have no doubt that you know this stuff, you are just useless to me.
It is not my fault that you are useless to me BTW.  

Take off your Priest robes, roll up your sleeves, get the "tone" out of
your voice and write simple code with explanations of what it does and
you could be helpful.  Until such time, do not bother to respond to my
requests for help because you are useless to me, and you are just
irritating (apparently your intent).  

If you want to be treated as the professional that you seem to be, act
like it.

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert
L.
Stewart
Sent: Thursday, March 27, 2008 8:55 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Copy a database using a stored procedure
orfunction

John,

So the code I sent you for a parameterized stored procedure to do
everything except the restore was "less than useful."

I apologize for the "huge waste of everybody's time" (including
mine) to give you a good, solid, viable way of solving your problem.

Robert

At 09:33 PM 3/26/2008, you wrote:
>So yea, for some reason I do find this list less than useful.  A full 
>day of lectures, and ONE response that actually looks like it might be
helpful.
>Thanks Elizabeth!


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

Liz Doering 
elizabeth.j.doering at wellsfargo.com 
612.667.2447 


This message may contain confidential and/or privileged information. If
you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose, or take any action based on
this message or any information herein. If you have received this
message in error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.





More information about the dba-SQLServer mailing list