I put these queries together some time ago. Feel free to use them as you wish.

-- SQL Server 2000 only.

--

-- Author: Damon T. Wilson

-- Creation Date: 13-DEC-2006

--

-- Usage:

--...

Andy,

It has been a while since I looked into using MS Access as a front end. You might consider building a Form in Access, that is based on your...

SQL Server 2000 Operations Guide: Monitoring and Control

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops5.mspx

SQLDiag.exe

To get a good idea of the current state of your SQL Server, including current user information, DLL versions, configuration information,...

mtassin,

One thing that *may* help shed some light as to SQL Server's state if the freeze happens again is to generate a "mini dump" (I know, I know, I didn't...

SSH,

Congratulations on passing!

The 70-443 exam has a different format, which is the 6 "testlets", consisting of between 7 and 13 questions per testlet, with a separate timer for...

Perhaps we can change the thread title to:

Dungeons Howl and Dragons Cry!

For those who may not be aware, Mr. Gygax is immortalized in Futurama Episode 220 (Action Rangers), as one...

rbateman,

Glad to hear that my notes are a benefit to someone else.

For use in an SSIS package, you will need to configure your SQL Server with the Linked Server as...

SSH,

Best of luck on the exam! Remember to pace yourself. I raced through the 70-444 and ended up with a non-passing score. I took it about a...

Lookup_BI,

That is a "it depends" kinda answer. Depending on the company you are either working for or are looking to join may or may not have distinct roles within...

Lookup_BI,

The 70-431 exam covers a TON of content. It is not an easy exam by any means. Keep on studying! (The 70-431 exam is the beginning of the...

I can't count the hours I spent "off the streets" playing Pen and Paper as well as computer based Role Playing Games. I began playing with the Dungeons and...

Lookup_BI,

The "correct answer and explanation" for the exam topics is ultimately referenced in the BOL. I *believe* this topic may have your answer:

SQL Server 2005 Books Online (September 2007)

Database...

Review this link for connectivity:

How to connect to an instance of SQL Server Desktop Edition or of SQL Server 2005 Express Edition

http://support.microsoft.com/kb/319930

Also, you may need to review the...

I agree with Matt. A Domain Account that executes (and owns) the Job, is configured to use the Linked Server and has access to the MDB file as well...

Paul,

I did a little digging and found this reference ...

http://www.sqlservercentral.com/Forums/Topic131319-5-1.aspx#bm132085

which refers to a KB article:

Backup program is unsuccessful when you back up a large system volume

http://support.microsoft.com/default.aspx?scid=kb;en-us;304101

......