And the test shouldn't be changed to make the UDP more obvious. Good Security is never obvious or easy...it takes work and paying attention to detail, which is what I...

Transaction log backups can only be restored to the FULL BACKUP they belong to. So, if you've never done a full backup the transaction logs can't be restored. The procedure...

A share ($) is NOT an administrative share. You just have to be given permission to it. I access several shares on servers that I do not have administrative privileges...

I enjoyed the test...showed me a lot I didn't know. And a couple I didn't read closely enough (missed the UDP and 'assumed' it was TCP).

Thanks for taking the time...

A small initial and growth size can cause the problems you are seeing. If TEMPDB can't grow fast enough you'll see those errors. For example, start with 100 MB size...

Check out the stored procedure sp_attach_single_file_db in the Books OnLine. I believe that command is what you need. This command will cause a new log to be created.

-SQLBill

To PING:

Open up a command tool. Start > Run type cmd and enter.

At the prompt, type PING ipaddress

Replace ipaddress with the address of the SQL Server.

-SQLBill

The registration properties it's talking about isn't Registering Enterprise Manager. When you open EM the first time, there aren't any servers listed. You must right-click on the group and Register...

Some format jobs give you the option of Quick Format or Long Format. If you haven't tried it, Quick format takes a very short time, Long format can take a...

It's my understanding that Standard CANNOT be clustered. It doesn't 'understand' clustering.

-SQLBill

Remember, in the datetime data type, dates and times are stored as eight bytes of information. The first four bytes are the number of days before or since January 1,...

The _pk is what is known as a "naming convention". It identifies that name as a primary key. Other conventions are udf_functionname. udf is short for user defined function. sp...

I definitely would notify MS and supply them as much information on this as possible. The very first paragraph on timestamp data type (BOL, Index tab, timestamp data type, then...

Why is an extra LUN a problem? We have two LUNs for SQL Server and both have around 160 GB of database on them. I manage both without any problems.

-SQLBill

...

SQL Server Agent controls your jobs and maintenance. To start it do one of these:

Go to Admin Tools > Services and find the MSSQLSERVERAGENT service and start it.

In Enterprise Manager,...