Thanks for chiming in Tom. I do not have much clue about Auditing. This could explain the time difference.

You can try to do it and then restart the system. It could wreck everything up but I do not see any other way you can get in unless you...

Go to Services, Click on the SQL Server service, and take properties. You can see if it is running under domain account or local system.

This could be a classic case of parameter sniffing.

Like Grant said at the summit, Parameter sniffing is your best friend, but can cause headaches for you at times. When...

Do you by any chance have any time zone difference? TDE should not have any issues with Auditing. But I have heard that Auditing can have issues with replication.

I am getting the the IPs changed on those servers to the workstation IP range. There it is not blocked... See Ya Net Admins... 😀

Our network admins work in a strange pattern. There are no ways to predict how they act. I am tired of these guys...

On another topic...

How many of you have to fight with the Network admins to get something done? For example, not to block Microsoft sites (Technet, Support) in your test environment....

There is nothing special about setting it up. 2005 to 2008 is something that is done quite regularly. Just make sure that your distributor is SQL 2008 and you set...

In your case, you can write your own restore script based on the log files that are transferred. You automate a transaction log back up to a particular location, use...

Derrick Smith (11/15/2010)

---

Roy Ernest (11/15/2010)

---

One thing you can look at is to see under which account your SQL Service is running. If it is running under a windows account, you...

No it wont. In SQL 2008, Local admin or...

One thing you can look at is to see under which account your SQL Service is running. If it is running under a windows account, you are in luck. You...

I did not understand why you are trying to connect using SA with empty password. Back in the bad old days, everyone left the password of SA account blank. Did...

That does not mean that you have a bottleneck in IO. What it would mean is that it is a very expensive query. You will have to take a look...