I won't be near my source code until Monday, but rather than keep you hanging I'll outline what I do.

The @FileSaveDate value ends up containing a date/time string like "200507221016",...

Here's some code from a backup utility I wrote:

DECLARE @FileSaveDate  varchar(16)

<...>

    --  Get and format the date and time to be used in this backup's file...

I do not know how to enable NTFS auditing on a folder--might you have any links to information on this subject? I suspect this won't be the problem, as I'm...

<This is an "aside" post, as it does not directly address the main topic>

Wayne,

I could do that, but then I'd have to deal with formatting issues. These days it's:

 - Enter...

<second attempt: original posting got eaten>

I haven't (yet) had to deal with this issue, but I always figure I'd work things out as follows.

First, always identify the natural primary key....

The BUILTIN\Administrators logins is not required to operate SQL Server. It is the default, but, when securing an installation of SQL Server, it is an "industry best practice" to remove...

A parting thoguht: if the data that could be stored in one row is split into one row in each of four tables, how do you ensure that a "full...

A while back I supported several SQL Server clustered instances, and BUILITIN\Administrators was not present. Unfortunately, I did not build those boxes, so I don't know what the work-around is.

   Philip

This should be as simple as just using the UNC path (and file name) wherever the "conentional" path and file name are used, whether configured in a database maintenance plan,...

Backups are stored locally, on the same physical device as the database files.

The same domain account is used for both SQL Server and SQL Agent. It has local admin rights...

You should have no problems doing this. If you're worried, try to restore it with a testing name (like "MyDb_temp" -- and watch those file names), on a testing server...

Several things from my experiences:

We had a database that measured 100G+, and that grew between 1-3G a week. I eventuall configured it to autogrow 10G at a time, which made...

I don't want to block it, I want to enable it. The current plan is to install SQL Server (Developer Edition) on all the Developer's machines. No way do I...

There's no simple built-in way to do so. The only control over history log size (that I've heard of) is via Enterprise Manager--right clicking on SQL Agent, selecting properties, and...

A bit of dead-end research:

BOL says that sp_detach_db can only be run by SysAdmins. That's usually good enough for me, but every now and then you need to know what's...