[dba-SQLServer] Copy a database using a stored procedure or function

John,

What I take offense with is the attitude of "Help me, but let
me rant about how difficult it is."

A priest no. But at one time, I was a licensed minister in
one of the mainstream denominations.  :-)

Spam and junk mail are never valid. Think of the trees and
bandwidth wasted.

Ask the questions and leave the commentary out.

You have your expertise at classes, etc in Access. I have a lot
of experience there also. I have a client management system,
DB in SQL Server, that I have developed over the last 10+
years. A number of social service agencies use it. When I chose
to use SQL Server, I did not whine about how hard it was to use.
Now, as a DBA and SQL programmer, I continue to be amazed at
what SQL Server can do.  And, I still do some of my FE work in
Access, but am moving to .Net for that.

Comparing SQL Server to dBase II is like comparing a skateboard to
a Cadillac. Everything evolves in the programming world. Just not
at the speed you want it to.

Robert


At 10:41 AM 3/26/2008, you wrote:
>Date: Wed, 26 Mar 2008 11:40:56 -0400
>From: "jwcolby" <jwcolby at colbyconsulting.com>
>Subject: Re: [dba-SQLServer] Copy a database using a stored procedure
>         orfunction
>To: "'Discussion concerning MS SQL Server'"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID: <001201c88f57$c8ba7a10$0201a8c0 at M90>
>Content-Type: text/plain;       charset="us-ascii"
>
>Robert,
>
>Making judgments about what I do for a living is unhelpful and in fact
>downright inappropriate.  Peoples careers range from terrorists to Catholic
>bishops.  I don't see you becoming a priest.  ONE thing that I do is a
>database for a company that sells address lists to companies that send bulk
>mail.  I also write databases for non-profit organizations that help parents
>of children with disabilities.  And many other databases.  I am not killing
>people, I am filling a very valid request of a very valid company.
>
>Bitching, yea I am guilty.
>
>To say that I do not know what the previous versions are like is not true
>and beside the point.  I know what dbaseII was like in 1985 and I expect the
>tools 23 years later to be superior (in user interface).  SQL Server
>(interface) is BARELY superior to dbase II in a few areas and much worse in
>others.  You can make excuses for the tool all you want, it still SUCKS.
>Call it bitching if you want, I am simply calling your favorite spade a
>spade.  It SUCKS.  Alright?  Not complaining, simply stating the obvious.
>Having spent your entire adult life working in it may make it SEEM (to you)
>like it doesn't SUCK but, in fact, it SUCKS.
>
>Now, if you wish to take offense at my stating that the tool sucks, have at.
>Notice that Gustav pretty much also stated that the tool (interface) sucks.
>Rant at him a bit why don't you.
>
>The emperor has no clothes, though he remains a pretty powerful emperor.
>
>John W. Colby