could you post your query and results ? Also, add the following just above your query:

select db_name()

go

Here's a start:

BOL - Index Tab - Estimating table size and allocating pages

Some of the actual page structure stuff I have to dig for. If I remember it was in...

Where the column is in the table creation DDL are located visually really does not matter. The columns for the actual row itself are stored in the following (very over-simplified format):

• page...

I manage 22+ servers ... I scan the errorlogs every 30 minutes for activity and email it to myself. I've found it useful to 'filter out' certain things like:

    '%Database...

SET WAY_BACK_MACHINE ON

Time for ISO-9000, ISO-9001 audits.

SET WAY_BACK_MACHINE OFF

The command is actually:

    sp_configure 'allow updates',1 --> allow catalog updates

    sp_configure 'allow updates',0 --> dis-allow catalog updates

There is also another 'nasty' side affect of this ... any stored procedure...

Just a silly question ... are you now going to start practicing the 'religious rites' of 'backup' ?

has anyone noticed the 'dip' in the world SQL Server knowledge base (since this thread started) ...

Glad to be able to help. Have a great day !

Here's a handy reference: http://www.connectionstrings.com

DBCC SHRINKFILE can be executed even while a database is in 'full recovery' mode. The command will only 'shrink' the inactive portion of the log file. However it might not...

Just a quick thought on 'encryption' ... there are lot's of 'freebies' on the web for 'decryption' and a few 'pay for' packages as well. In SQL 2000 encryption is...

What account(s) are running the SQL Server Service and the SQL Agent Service ? Are they LocalSystem ? Local COMputer accounts ? Domain User Accounts ?

Where is you backup target ?...

I think a quick read of a section of BOL (Books Online) may be in order here.

    Contents tab

    Administering SQL Server

    Backing Up and Restoring Databases

If your site uses SMS then almost everything you need is present 'out of the box' from a windows perspective on both the client and server side if the admins...