quote:

---

If microsoft wants to make things a bit easier by giving away some of their questions, and others volunteer info on the...

Thanks. I was thinking about using OSQL and sp_password. But now I'm considering creating a form in MS Access.

-SQLBill

SQL 2000 replaces SQL 7.0.

Hidden in the SQL Server 2000 copyright is the version # 8.00.00 etc.....

So...SQL Server 2000 is really SQL Server 8.0

-SQLBill

Actually, BOL does explain it. Just not very well.

The hyphen '-' between two characters MEANS between.

In the BOL, use Index tab, go to LIKE. There is a table with descriptions....

Mark,

Use DECIMAL. But you need to figure out two things.

1. Precision = how many digits (left and right of the decimal point) will you have total?

2. Scale = how many...

Nope.

WITH RECOVERY is the default. Once the database is 'recovered' (WITH RECOVERY) no additional backups can be restored.

You would have to start over again.

-SQLBill

Mine also says:

Version: 8.00.002

And I have SP3 for BOL loaded. The title bar says SQL Server Books Online (Updated - SP3).

-SQLBill

Mark,

You're right.

I was SAD that day.

(Sleeping At Desk)

-SQLBill

By the way, have you restored your lost data?

If not:

Do you have a full backup? Have you been backing up the logs?

You can do a 'point-in-time' restore if you have...

Do you need to restore the full backup in any way?

YES. You need to include the command

WITH NORECOVERY

in the FULL RESTORE and the command

WITH RECOVERY

in the DIFFERENTIAL RESTORE.

See the...

Antares,

I think you just won for having the longest post! [big smile]

-SQLBill

Have the client go to the ODBC set up (usually in CONTROL PANEL, but might have to go to Administrative Tools to find it). It's sometimes listed as Data Sources...

How about the SQL Server command CONVERT:

SELECT CONVERT(VARCHAR(23), GETDATE(), 121)

That will return the date and time in the format you want. yyyy-mm-dd hh:mi:ss.mmm

-SQLBill

Here's an example of what WITH TIES does...

DATA;

1

2

2

3

4

SELECT TOP 3

FROM data

ORDER BY numbers ASC

1

2

2

SELECT TOP 3 WITH TIES

FROM data

ORDER BY numbers ASC

1

2

2

3

Also, there isn't a BOTTOM # in SQL Server....

It's probably from when we seceded from England. Changed the way we drive, changed the way we write dates.

-SQLBill