That CD is the media for the license you got when you purchased your computer. If you still have XP on the computer, then you cannot install it elsewhere. If...

Can you post some code and data to show what you mean?

Steve Jones

steve@dkranch.net

Not sure about this one, but there were lots of changed to OLAP in SQL 2000 and I suspect the DTS task changed. Not sure if you can automate a...

In Oracle there is always a cursor created and referred to for operations. Something I did not know until recently and it seems lots of people coming to SQL Server...

Haven't seen that. I will ahve to test.

Steve Jones

steve@dkranch.net

backup restore or detach/attach are both easy. I'd do the detach/attach if this is a one time thing.

Steve Jones

steve@dkranch.net

I would say that a DBA is responsible for the integrity and performance of the database. Therefore the DBA should do all object and query development OR review all queries...

How are you importing?

Steve Jones

steve@dkranch.net

If you post some DDL, I will make a test table and try it.

Steve Jones

steve@dkranch.net

You can also use differentials to minimize your risk. If you made a 12:30 differentials, then the corrupt 12:25 would not matter. You'd do the 12:00 full, the 12:30 diff,...

You would need to write a script that can move the database defaults for the users. There is not a way for SQL to know this (unless you copy the...

AFAIK, you will need some script to do this. There might be one on this site. In EM you can see the user permissions, but need to check the...

Try a couple things:

Log in as UserX in QA, note the default db. Check EM and the properties for this login and note this.

Restart SQL and repeat.

Now change the default...

Good suggestion. I will add it to the list of things we have for enhancements.

Steve Jones

steve@dkranch.net

you can run in simple more, which will truncate the log and essentially work without one, but some things will still be logged.

Steve Jones

steve@dkranch.net