[dba-SQLServer] Copy a database using a storedprocedureorfunction

ROTFL.  Liz, you are a nice lady.  

I will be honest with you, being in the laity I find BOL useless.  The
explanations are endless loops of code that does not run as typed, and
references to other entries of code that does not run as typed, and pages of
arcane syntax that are no doubt useful to those more directly involved in
SQL Server.  There is a good reason that there are aftermarket books (which
I own AND READ) to explain this stuff.  I have read chapters Chapters 11, 12
and 13 of Robert Vieira's excellent Beginning SQL Server 2005 Programming
and I am slowly learning, but no surprise, the question I asked is a bit
beyond what a book like that can even consider.

As I have clearly stated, I am not an SQL Server admin, programmer, manager
or anything else.  I just use it, quite successfully all things considered.
Even your example doesn't directly help me much, though it certainly
provides me with syntax that might eventually get me there.

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
Elizabeth.J.Doering at wellsfargo.com
Sent: Thursday, March 27, 2008 10:12 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Copy a database using a
storedprocedureorfunction


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