What else is being done on the database? Are you doing daily reindexing? If so, that will cause your tlog to really grow huge (I believe the recommendation is 1.2...

NULL basically means "I don't know what this value is".

Why not set your numeric columns to have 0 (zero) as the default? You could set your date columns to...

You've got to get rid of the BUILTIN\Administrator login to stop admins from logging in. DENYing access to that account is not the same (as I found out -...

Not going to happen. About the only way is to send your hard drives to a place that recovers data from the drives. But that is very expensive and...

In my case, that has happened twice. First time we lost 6 days of data and had to send our backup tape offsite to Veritas for recovery (crash was...

When you get an error that a file is full...that doesn't mean there's not enough room to grow. It means that at THAT MOMENT THE FILE RAN OUT OF SPACE....

Basic and very simple:

SQL Server Windows Authentication works like this....

You are the client and I'm the SQL Server. Karl is a third person that you know and I know. ...

1. I back up my TLOG every four hours (work on government contract). Backing up anything takes up resources. You have to balance backing up with transactions. I back...

JaceK0,

Actually, that is what SET DATEFORMAT is for.....

In your example, you would put

SET DATEFORMAT MDY --if it's Jan 2nd

-SQLBill

Wow, I must of been in dire need of sleep when I answered that.

-SQLBill

Paul,

An INNER JOIN is always left to right. So the opposite of:

FROM TableA INNER JOIN TableB

is:

FROM TableB INNER JOIN TableA.

-SQLBill

Refer to the BOL, go to the Index tab and enter CONVERT. Go to the option for Transact SQL. You will see a chart there for the different formats you...

Why don't you install it? Normally installing anything requires system admin privileges (not SQL Server sysadmin, but sysadmin on the computer).

It would help greatly if you provided the error...

1. you have jobs running - stop SQLServerAgent then try the detach

or

2. you have more than one applicationo open. If you have Enterprise Manager and Query Analyzer open, that's two...

I got away with this one once when a boss kept looking over my shoulder and trying to micromanage me:

Here's JAFO!

(Just Another F...ing Observer).

(From the movie Blue Thunder)

-SQLBill