I did some more research on this and I am confident that I am correct. Here is my example.

I am a domain admin at acme.com

I am a domain admin at...

you may be right, but i can share this.

domain 1 - user domain1 is an admin.

domain 2 - user domain1 is just a user.

domain 2 - user domain2 is an...

this is actually a "domain" policy. the users that have SSMS installed on their local PC's should be "not allowed" to control system services.

I am not a AD admin nor...

Don't forget that MSDTC is DNS based. I have found that a quick entry into the host file will fix these cross domain issues pretty quick...

so on your source server,...

JohnnyDBA (10/27/2010)

---

Myself and my colleagues have noticed that performance can be significantly worse when running

rather than running

SELECT TOP 1 * INTO tempTable...

yes, it is.

MsDtsSrvr.exe

YES

But i am in a clustered...

do you maybe have the -g flag set to 5.7 in the startup parameters??

yeah, its the same....

so if you have a Domain Policy that says you change your password every 90 days and it must be 8 characters long and have numbers...

it is based on the local server or domain group policy.

something Microsoft really should address for sql logins imho.....

http://technet.microsoft.com/en-us/library/dd277395.aspx

WayneS, your script makes some assumptions.

you have to have a database called DBA. you have to have a table called Drives inside of DBA....

just try this,

see attachment.

ALZDBA (10/26/2010)

---

Need it to be said that from an OLTP database perspective only R2 doesn't have that much an advantage over the original.

We are skipping the original because of report...

SQL will always behave this way. The better way to see memory usage it to see if it is 'actually' being used. look at the counter "Buffer cache hit ratio"...

Multi-server admin was added in 2008 and is technically NOT a SQL Server feature but an SSMS feature.

you should also add to your ado connection string....

connectionString.NetworkLibrary = "dbmssocn"; connectionString.Pooling = false;