just being advocate of the devil :sick:

Pull all your wanted tables to a .net dataset and just export it into an xml file.

Piece of cake.

The big question remains: Why do...

if it was a full database backup, it holds the data from your mdf, ndf and ldf files.

Still that isn't a guarantee your restore will be ok.

After the restore operation,...

I haven't got experience with that tool.

The posted script would have generated a sqlscript for you, including the encrypted passwords and sids.

That would have made your job a piece...

You can always modify the script to only script out those sqlusers that are authorized for the database you want to port.

shifty1981 (1/19/2011)

---

...

I have been told that rebuilding our indexes typically takes about 2 hours and that it puts a pretty heft load on the server. However I hoping to find...

Marios Philippopoulos (1/19/2011)

---

Is there a DMV query I can run to get at the data stored in tempdb tables at the present time?

Or if not the data, some metadata information,...

My 2ct...

I think you will need to pay attention regarding your load in the off line timeframe.

Make sure your log file(s) is big enough and your server has enough place...

tt-615680 (1/18/2011)

---

Thank you for your reply. Basically, I wanted to find a way of getting my queries to run faster and I read on one forum that changing the "Max...

Nope, but zzthangs vor ze hind 😉

btw I ended that day with a good game...

I payed attention the plain water (no bubbles ) was at room temperature. ( and it wasn't freezing in the room 😉 ).

I'll try out the warm tea the next...

setting it to 1 will prevent query parallelism for your instance.

If that is your goal, that's the way to do it.

Is that your goal ?

On most of our oltp databases...

Did you have a look at select is_member( 'yourdbgroup' ) ?

Thank you all !

Todays session went fine.

Still having a good voice after 4h+.

I banned coffee and consumed 1,5L water, nicely planned 10min break every 75 minutes. The speaking speed...

What's your MSDTC security configuration.

I think you db2 as400 uses xa transactions.

Did you enable XA transactions with MSDTC ?

Have a look at "Choosing an Authentication Mode" http://msdn.microsoft.com/en-us/library/ms144284.aspx