OK here's what I have updated on the server to get my desired results (so far):
1) Changed the NIC in the vSphere Client for the server to be E1000....

Thank you! First test run of the same script with only one vCPU is showing the same results as the older test system (give or take 15 - sec). I'll...

Hello,

Sorry for the delay..
1) the server seems to respond normally to other requests
2) I'm running select * from sys.dm_exec_requests while my slow query is also running....

Sorry I should have included those settings also. Yes the properties of both link servers (current & new ) are the same.
Allow inprocess under Link server providers OraOLEDB.Ocarle is...

Was looking for a template to keep track of internal IP addresses. Server, routers, switches, phones, etc... anything has to be better than the mess I'm left with. I have...

Figured it out!

So as we all know adding a user/group to the Home page will give said user/group access to all reports on the Home page. I created local groups...

Thank you for the info, it helped a lot. We had an audit recently and they didn't like the fact that data was not encrypted regardless of other security measures....

I resolved this by changing the default database to master in 2008. This was not the case for me and my systems in 2005.

OK.. So to satisfy auditors and myself would you have a recommendation for a 3rd party app that I could use to monitor this? I was hoping to find a...

Ok… This is what worked for me.

My first problem was that I was not logging in the same as the users needing to print. I discovered this when the users...

I did check the log's and nothing stuck out as odd. I'll look again at the logs and see if anything stands out and report back. Thanks

So would it be safe to say that each night when this Full Mode database is backed up it's backed up in its entirety including the data in the log...

Greg, Thanks for the reply that confirms what I found when looking at other databases. Here's what I did to correct my problem:

How to alter the owner of a Schema...

I used SQL to create my queries and then copied the code to a new Access query (I'm using the Pass Through option/feature pointing back to the SQL server). The...

A big thanks! to Jack Corbett and Support.sql for your help on this one. Since this new script has been running for a week without fail I thought it...