Yes, I know this is how SQL Server Log Shipping works. You set the option when you set up the log shipping using the GUI. However, as I...

The link explaned what it is doing, but not why they decided to stop using the local Windows groups.

We used to use one AD account for all SQL Server services and another for all SQL Agent services. The service login account were changed after the install was complete,...

I cannot set up any accounts in AD, our security team does that. It was also decides to use a distinct user for every server, which is why they...

To decision to use local users was made above my head. Setting the permissions for the service startup account was done by adding the user into the local Windows...

I can add domain groups to the SQL Server instance. I am talking about the Windows groups that were created with SQL2K5 and SQL2K8.

I know that, when you are auditing logins, the messages go to the SQL Error log and the Windows Application log. I have been asked to provide documentation that...

I am aware of both these thing, but this does not answer the question I asked.

Thank you. CREATE USER was what I was forgetting.

The SQL Server login already exists, but I need to grant access to a database from a T-SQL command, rather than use Management Studio.

No, but if this does not work, that and running the queries on Oracle directly are our next step.

Well, those changes did not work, so now we are rolling out a new virtual server. We are going to move the database that contains the queries we are...

My server admin check the two servers and found a couple of differences in the VM and hardware settings. We are making changes and will be trying the queries...

benjamin.reyes (7/30/2012)

---

Same number of files, are they on their own spindles, same type of raid able to handle the same iops. Is you disk alignment the same on all...

benjamin.reyes (7/30/2012)

---

What kind of wait types are you getting on both servers while the query is running?

The only wait I can see in the Activity Monitor is PREEMPTIVE_WAIT_GETDATA.

Are all sql...