[dba-SQLServer] Copy a database using a stored procedure orfunction

jwcolby jwcolby at colbyconsulting.com
Wed Mar 26 10:40:56 CDT 2008


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
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: Wednesday, March 26, 2008 9:21 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Copy a database using a stored procedure
orfunction

Paul,

Probably not.

John,

There is no such thing as a SQL Server USER. If you do not want to hire a
DBA/SQL Programmer, then you are it, like it or not.

3rd party tools are there for a reason. They were there for Access also. If
you don't like the FREE tools, buy one that you do like. Since you have no
idea what the previous versions of SQL Server were like, you have no
reference point for the current version.  I have used and programmed with
SQL Server since 3.21. It has come a long, long way since then.

I gave you a 2/3's completed solution, written as it should have been, in
T-SQL. Stop the bitching and complaining. If you need help, you have
received it from this list. But, I have to agree with Francisco, you got the
help even if you are enabling spamming and junk mail.

Robert

At 08:25 PM 3/25/2008, you wrote:
>Date: Tue, 25 Mar 2008 19:25:44 -0600
>From: "Paul Nielsen" <pauln at sqlserverbible.com>
>Subject: Re: [dba-SQLServer] Copy a database using a    store
>         procedureorfunction
>To: "'Discussion concerning MS SQL Server'"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID: <004401c88ee0$51061230$f3123690$@com>
>Content-Type: text/plain;       charset="us-ascii"
>
>But you are using version control for all source code including DDL 
>code, right?
>
>-Paul
>
>
>
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of 
>jwcolby
>Sent: Tuesday, March 25, 2008 7:03 PM
>To: 'Discussion concerning MS SQL Server'
>Subject: Re: [dba-SQLServer] Copy a database using a store 
>procedureorfunction
>
>I am not criticizing anybody, I am simply pointing out that there are 
>many different jobs.  Mine is not SQL Server Administrator, nor SQL 
>Server programmer.  Mine is SQL Server user.  SQL Server is an 
>immensely powerful system where the human interface is just emerging 
>from the stone age.  Like anyone familiar with the stone age tools, 
>they are good enough to get the job done, if you happen to be familiar 
>with the stone age tools.  If you are familiar with high powered rifles 
>and razor sharp knives,and airplanes to get to the hunt, the stone age
hunting tools are ... well.. Stone age.


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




More information about the dba-SQLServer mailing list