Thanks for the information but I don't think my company is going to pay for me to go out of the South right now. I was really looking to...

Here is a start.

You might also just open up BIDS and check the help in it. Once you create a SSIS package it is very familar in most parts...

It is not auditing from MS necessarily. The industry you are in may require 3rd party auditing (example for HIPPA or PCI/credit card) and part of that auditing or...

I would contact the company you are working with for the application and...

Well according to QA on Window Server 2008, now this is with R2...

Every user or device that accesses or uses the Windows Server 2008 or Windows Server 2008 R2 server...

njdouglas (2/3/2010)

Sorry maybe I wasn't clear. I understand that SQL Express does not need CAL's and that it has limitations. The copnay who make the database application state...

You could script each database to a file (http://msdn.microsoft.com/en-us/library/ms178078.aspx) and then use file compare in DOS prompt to look at the differences.

This would work if you don't care about the...

FYI: that role will allow them to do more than just read the logs.

As Ray stated it comes with SQL Server as an optional install when you install the Desktop...

a plug for a book that I have not read yet but will be: http://dbasurvivor.com/%5B/url%5D. it looks like it will be a good read. it is a book by the...

Well best I can tell that information is not available from a query. Since it created as a SSIS package the contents of that package are in the MSDB...

Yes...I did bring up the wrong instance to test on...at least now you know how to do it on SQL Server 2000 🙂

Hold on let me find it on a...

It would depend on how your backup jobs are created. If they were wizard created as a maintenance plan the value is not in a column by itself. ...

2010-01-20 08:22:01.43 spid7s Failed to check for new installation or a renamed server at startup. The logic for this check...

I take it you restored to another server? Are the drive letters available the same on the restored server as what was on the original?