Empty space. Lets say I create a file (and it doesn't matter if it is the data or log file)....and I make it 100 MB. Now I fill...

And you can not change master to Full. Believe me on this. It will let you do it, it will appear to be done, but then it will switch...

I would check with the espirit people.

It might be something installed via an application of theirs that you need along with what you are installing now.

-SQLBill

Or:

DECLARE @starttime DATETIME

DECLARE @endtime DATETIME

SET @starttime = GETDATE()

SET @endtime = GETDATE()

SELECT DATEDIFF(SS, @startdate, @enddate)

-SQLBill

You say you are installing the MSDE part, the database is MSDE not Standard or Enterprise edition correct?

How many instances do you have? How did you provide the name of...

I see people keep bringing up the 'the agreement was buy one, get two'. But the final agreement/contract occurs when Amazon shows you the final page with the cost...

Okay, found out that StarBucks made good on the coupons for a while and then stopped them.

-SQLBill

I probably would return the item or pay for it. But I would also probably not use Amazon again.

I don't have the links for the stories, but...

In England, a vacuum...

I've never done this, so....

I'm guessing that the tuf stands for transaction undo file. Once a database is in standby it stays that way until:

1. you restore it with...

I believe all you need to do is:

RESTORE LOG dbname WITH STANDBY = undofilename

from BOL:

STANDBY = undo_file_name

Specifies the undo file name so the recovery effects can be undone. The size...

Since you are looking for 1-up numbers and the numbers have to be unique between two tables and may not be in alternating order, I suggest sticking to a TRIGGER.

You...

How are users connecting to the database now? If it is by Windows Authentication, that might break. Both domains have to be trusting of each other. In other...

GROUP BY Y.IDCode, X.CreatedWhen, X.OrderStatusCode, X.ReasonText, X.Active, Y.BirthDayNum, Y.BirthMonthNum, Y.BirthYearNum, Y.DisplayName, Y.ApplicSource

HAVING COUNT(*) > 1

-SQLBill

We had a cluster until the vendor's upgrade required the cluster to be broken. Our system databases were on the server drives and the user database files were on the...

What permission does the login have?

CREATE DATABASE permission defaults to members of the sysadmin and dbcreator fixed server roles.

-SQLBill