If this is a conversion from te old situation to a new one (OLTP) create a table using a LOOP scanning you old DDL and rebuild the new table dynamicly. Afterwards...

Try evaluating SpotLight on SQL server ( Quest soft ) as a sophisticated graphical tool or try MOM ( very complicated ).

Just a thought...

GKramer

Ask for the properties of the database / Option tab / restict access / select members of DB_Owner.

First be sure to communicate this action to the current active users.

GKramer

Read the BOL on this ( or brows thje Internet ) there's a lot of info there.....

GKramer

why using 1500 unio's ??

You can better create a temp table with two columns and fill this one up using a loop starting with 1,171 and ending with 1,1671 and...

The QOD makes me focus on specific parts of SQLserver 2000 and I try to learn from this. As an Oracle DBA for several years I started working with SQL server...

I agree,

Its maybe an option to show them both.

Guus

ruchirdhar,

As you described this is the way the DDL changes have to be made. ( Drop, alter, re-create ) hurray for Microsoft. There is a more sofisticated...

Just signed up last week and looking backward to the QOD's and found this one, my commend ( although I gave the correct answer (3)&nbsp

Just signed up last week and looking backward to the QOD's and found this one, my commend ( although I gave the correct answer (3)&nbsp

Hi,

You want to recreate a database incluiding the data.....right.

You can use ;

Backup and restore within SQl server 2000.

The exportfunction in the Enterprice Manager ( incl ODBC ) to almost any type of databases.

Or you can...

Hi,

If you are dealing with a N to N relation on table PERSON and PROPERTY ( using the inbetween table PERSONPROPERTY ) I'd rather use;

SELECT a.name

FROM    person a,

           personproperty b,

          ...

Hi,

Just wondered what causes the lock ( that i'm interested in !!)

Wrong insert / update statement?

Howmany rows are involved?

How is your page handling ( pageiolatch )?

System - database specs?

etc...