That's not backup but a file copy.

That will only work if your sqlinstance has been shut down before copying the files unless you use special snapshoting software that knows to...

As you notices, a foreign key can only refer to the full primary key.

Can you implement a surrogate key ?

(and create a unique constraint for your current primary key constraint)

Think...

- Books online. and how to get there the easy way .

(highlight your keyword and hit shift+F1)

- point to "when using the query designer, this is how...

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' ) ?