[dba-SQLServer] Copy a database usinga storedprocedureorfunction

ROTFL.  I would RECOMMEND his book to you guys.  I can't say for sure
because I don't own it, but I suspect that it starts at a level already over
my head.  You gotta crawl before you can walk, and I am still crawling.

The other thing to remember is that I do use TSQL, and I have come a long
way, and gotten a whole ton of stuff working without using any advanced
features of TSQL.  My database is REALLY simple.  No transactions, no locks,
no rollbacks, no usernames, no groups, no passwords.  It is just me and my
server, on a private network, looking at HUGE single tables.

Would advanced TSQL help me?  I am sure it would.  Would it be worth the
months or years learning it?  Not in my opinion.

There is still hope for me.  And I have come a long way already, especially
considering I sit in a room by myself all day slogging through this stuff.
I read, and I Google, and I play and I get frustrated, and I come here when
all else fails.

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 Eric Barro
Sent: Thursday, March 27, 2008 10:44 AM
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] Copy a database usinga
storedprocedureorfunction

Hehehehe...John, maybe you should go buy Paul Nielsen's SQL Server 2005
BIBLE!

Now *THAT* might get you into the priesthood yet. There's still hope for you
John! And that's the good news!!! LOL...

Ah yes...a little humor does help. BUY IT NOW!!! DO IT! Hahahahhahahaha.... 

-----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 7:28 AM
To: 'Discussion concerning MS SQL Server'
Subject: Re: [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