Microsoft SQL Server 2008 (SP2) - 10.0.4266.0 (X64) Nov 5 2010 16:11:39 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1...

Reset counters

DBCC SQLPERF ('sys.dm_os_latch_stats', CLEAR);

GO

Setup monitor to track value ever 10 minutes... And Now off to do some reading. Just the way to start off a holiday weekend.

Unfortunately I am not tracking that data historically, but looking at sys.dm_os_latch_Stats

ACCESS_METHODS_DATASET_PARENT Max of 8331 average of 9

BUFFER Max of 9922 average of 0

All others of note are "Internal...

A good article, that with a thorough proof read would have resulted in a very good article.

11757457 ObjID is actually the ID for the Bibby.Profit_Act table. 1:153:1 is the...

Looks like I had cached credentials to the old machine as the local admin to the machine for an old purpose. oops....

C:\WINDOWS\system32\rundll32.exe keymgr.dll, KRShowKeyMgr

I then removed them and...

Having a similar issue, but unfortunately everything I have read up to this point appears to be for a different problem.

First of all, I was able to access this system...

Obviously, but apparently I am the...

I agree with all points. The developer instance is the way to go. However, the fact that the question was stated as "Creating a clone is not legal"...

Creating a clone is legal, but it is not as "Free" as this question implies.

From MS..http://www.microsoft.com/sql/howtobuy/faq.mspx

For Standard, Workgroup, and Enterprise, if you decide to license on a per...

Create a linked server to the Access file, and you would write to it that way.

See this post for info.

http://www.sqlservercentral.com/Forums/Topic185045-5-1.aspx#bm185324

At this point, I suspect that you have already corrupted your system. Removal of the SP2 was probably not a good idea.

You can download the SS Express...

I like that :hehe:...

Sorry, that's a monitoring issue. MOM is an option here.

Or you could just create a windows task that runs every hour... 🙂

net start "SQL Server (MSSQLSERVER)"

It would fail...

The better approach would be to disable SQL Server accounts and just use windows authentication.

I agree with Jeff here, this is a bad idea. Your asking to...

tjt649 (5/25/2008)

---

Many thanks for your response and two methods of solving the problem.

However I am beaten on both counts.

Firstly, despite several attempts of changing back to the original computer name...