I don't understand what you mean by you "can go back in time in the log, but not back enough".

Did you do a FULL backup before the DELETE happened? Did...

Have you tested your SELECT to make sure it is returning what you want it to return?

In other words, in Query Analyzer, run JUST the SELECT (not the INSERT part)....

You can do as Jima suggests or just detach the database, move the .ldf to where you want it to be and then when you attach the database just tell...

Antares has a good point. Thanks for pointing that out.

-SQLBill

Or simpler yet...

Open Enterprise Manager, expand the Microsoft SQL Servers, expand SQL Server Group. Anything under there is an instance.

The default instance will be servername

additional instances will be servername\instance_name

-SQLBill

Disclaimer: I don't use Access. I don't work with Linked Servers.

First thing I would check is the datatypes. Make sure they are compatible, i.e. Pat Name should be NVARCHAR in...

Cool. Very nice. (What's your question?)

-SQLBill

To properly backup the .mdf and .ldf files they must be in a detached state. This can be done by stopping all the services or detaching the database(s). If the...

You need to determine what you need based on what it's used for. We can tell you what each of us uses but that won't really help you as we...

Is your function doing any conversion of data to DATETIME?

-SQLBill

SMK,

Quote:

I don't know why my where statement turned blue but I can't get it to stop!!

UnQuote.

Put a space before and after the equal sign. Since there isn't a space...

The stored procedure sp_spaceused is probably what you want.

Refer to the BOL for more information on how it's used and what the results are.

-SQLBill

BOL = Books OnLine = Microsoft SQL...

Neddy,

You state:

Another table is inserting into the table with Status_Date bya trigger

Check out the trigger, it might be the cause of your problem.

-SQLBill

Here's where you can find more information on doing the backup and restore.

In the BOL, use the Index tab and enter BACKUP DATABASE (look for the entry for Transact SQL)....

Jonathan,

Thanks for pointing out the error of my ways. I went back and relooked at the BOL, and the paragraph on ALTER COLUMN even states "the given column" and...