But the separate luns would need to pull from different disk pools(or dedicated storage) to gain the benefit, correct? I'm at a new job and they share everything. The storage...

Oooh, SAN, the mythical black box of wonder...

No, It will not make a difference. SAN guys/gals separate the disks into different disk groups or Aggregates(depending on the san vendor). ...

thanks for the reply lowell & adam, just remembered sys.dm_os_schedulers too. oops.:-D

OK, if you want the entire transaction to rollback, take a look at this. Make sure the MSDTC is running. Hope this helps.

Thanks

Chris

We have some ETL jobs that feed our data warehouses. If you try to insert a duplicate primary key, the primary key constraint should cause the update to fail. Do...

I should probably read a little more carefully.

here's a link for SQL 2008 R2 on setting up a mirrored cluster.

It says the connections can drop if the cluster fails over...

you have a lot of options for HA.

2 hours of downtime isn't to bad, but 0 data loss can be expensive.

-The price is dependent on your environment and...

ok, here's some that I use. They give a lot of insight into what's going on in sql server. I got this from jimmy may's blog on microsoft. they rock.

looking...

found this on one of microsoft's blog sites

Under the Setup folder of SQL Server 2008 installation files, there is a exe file named vsshell.

--try running it, and rerunning sp2. Do...

Did you upgrade the DTS package to SQL 2008 or are you trying to edit a SQL 2000 DTS package? Also, when you appllied SP2, did you apply SP2 to...

This is from ms

http://msdn.microsoft.com/en-us/library/dd897474(BTS.10).aspx

the top part explains setting up an app with a disk and ip using windows 2008. You should be able to right click and add...

Did you add the disk as a resource first?

Cool, glad you figured it out, and thanks for letting us know what the problem ended up being. I link servers all the time, so I am bound to run...

Thanks, I don't know why I didn't even consider SSIS. I'm in the middle of a dts/ssis upgrade now....

ooooh, I'm thinking local security policy then. local admin gets everything including sa in sql.

There is might be a local security right that you need to grant to the users...