One last question, should i perform the following steps before migration or after migration?

-- upgrade creates a schema for all users and sets this as default, use following to create...

Thanks a lot guys.

Thanks guys.

Would it be a problem if I move the database to SQL 2005 server using switch Lun method?

Awesome!

Thanks a lot, I got what I exactly wanted..

I've the following events and no filters

SQL:BatchStarting

SQL:BatchCompleted

Audit Schema Object Access Event

Existing Connection

RPC completed

Audit Login

Audit Logout

Oops! I missed that...Thanks Lowell for pointing that out.

But this trace stops in exactly one sec. Am I missing something here?

As far as I know, we aren't going to add any indexes.

Is my math correct?

Thanks Bru.

I found a way of doing it but not sure if it's correct:

Using Idera diagnostic manager tool, I found out that the table with textdata has 158 transactions and...

What I'd like to do is delete rows older than 7/1/2011. If an error occurs, I'd like to roll back.

Sorry..Let me rephrase my question...

There are 370 tables in the database. I'd like to check how many tables have XML in them.

After I get the list of tables, I'll run...

Thanks Gila.

Do I've to run DBCC Shrinkdatabase command to claim the space after dropping the tables?

It is a shared server. Would it have an effect on the server or just the database?

I was also thinking that this might help DBCC SHRINKFILE ('file a', EMPTY FILE ).

But if I add 2 new files(file b,c) and then use this DBCC command, how...

Sean,

When DTS compared to SSIS, which tool is the best with respect to performance? I was told that DTS performs much better if you are just moving data from source...

Using import export for multiple tables, I saved the package.

But I want to know if it would really hamper the performance since the tables that I'm going to export are...