According to BOL, CAST does not accept a STYLE input. Only CONVERT accepts a STYLE input.

-SQLBill

Did you do a backup to the device using SQL Server commands?

Is the device seen by your hardware (computer/server)? Right click on the My Computer icon, select Manage, select Device...

Shrinking a file depends on WHERE the free space is actual located. A log file tends to look like this: (code A = active I = inactive)

A I I A A...

Steve's solution may not actually work...I believe the first bracket has to be after the period.

So:

Select * from dbo[.631586971108797504]

should really be:

Select * from dbo.[631586971108797504]

I know it's just symantics and...

By the way, SET DATEFORMAT does not change the way the date is saved in SQL Server, nor the way it is displayed.

All it does is say: "SQL Server, when...

At the beginning of your script just tell SQL Server how it is to interpret the date data.

How do you do that? Easy. Lets say your format is day, month,...

Ouch! No backup? Really? Too bad. You really need to have a backup to be able to recover.

One other POSSIBLE solution. Lumigent makes a product that can read the transaction...

Look in the Books OnLine for Orphaned Users. I believe the command you want is sp_revokelogin.

-SQLBill

Okay, back to step one....

When you installed MSDE you were required to provide a password for SA. Did you do so? If not then it is blank. SA is the...

Why make so much work? Use the DBCC DBREINDEX command and put it into a job.

See the BOL for more information on DBCC DBREINDEX.

-SQLBill

Why aren't you just doing this:

WHERE DLZ_EMAIL.DATE_DEB <= GETDATE()'

-SQLBill

Yes...according to the BOL you can have a UNIQUE column as long as only one NULL exists.

You can also combine two columns to make one unique constraint.

-SQLBill

I prefer to do them manually. And as I said, there are exceptions - some very experienced DBAs use maintenance plans, some very inexperienced DBAs create their own plans.

I believe...

I have heard (at this site and other tech sites) that the 'new' server has to have the same level of patches as the 'old' server.

So if it's coming from...

WHERE DLZ_EMAIL.DATE_DEB <=' + cast(GETDATE() as varchar)

That is comparing a DATETIME value (date_deb) with a VARCHAR.

Why are you casting GETDATE() to a VARCHAR and then...