DOCUMENTATION!!! I dealt with a vendor who told us they could provide what we wanted. But then they kept saying...oh we are working on that...we'll let you try it as...

quote:

---

I'm sure some would like my attitude to change.

--Jonathan

---

I'm not...

I got an email on this. It's a brand new magazine. Since it's just starting up they probably don't have the finances, etc. set up to do non-U.S. mailings at...

In Enterprise Manager, right click on the Server, select properties and that should tell you what type of authentication is being used.

-SQLBill

VERY basic description:

'Normal database' - used frequently. All types of transactions are done on it. Usually one database for each specific function/application (HR, Security, Sales, etc...).

Datawarehouse - used infrequently. Normally...

You can use CONVERT.

WHERE CONVERT(VARCHAR(10),sampledate,121) BETWEEN CONVERT(VARCHAR(10),userdate1,121) AND CONVERT(VARCHAR(10),userdate2,121)

Basically this converts the date and time to the format (121) of yyyy-mm-dd.

Refer to the Books OnLine for CONVERT and CAST.

-SQLBill

I might have this wrong, but didn't the latest update (SP3) to SQL Server 2000 require you to enter the SA password?

-SQLBill

Yes. The database files themselves are .mdf and .ldf files. Any backups will have different extensions since they aren't 'database files' they are backups of the database files. The RESTORE...

Our firewalls aren't THAT picky. I don't have any problem with the links.

-SQLBill

You should be able to just use the BACKUP DATABASE and BACKUP LOG commands. Use the to disk option and tell it where you want to save the files to....

stubob,

Go to BOL, use Index tab, enter SP_TRACE_CREATE. One of the options for that procedure is TRACE_PRODUCE_BLACKBOX.

-SQLBill

Frank (and others who may care),

Here's the difference between TOP N and TOP N WITH TIES

Data:

1

2

2

3

4

5

6

SELECT TOP 3 Data

FROM mytable

ORDER BY Data ASC

Results:

1

2

2

SELECT TOP 3 WITH TIES Data

FROM mytable

ORDER BY...

Frank's being funny! But he is correct.

SELECT TOP 40 column1, column2.....

or even

SELECT TOP 40 WITH TIES column1, column2

-SQLBill

Jonathan,

Thanks for the information and 'break-down' of my post and where I went wrong.

-SQLBill

Have you gotten your network/computer SECURITY personnel involved????

If not, you should have done this already and need to do so now!!

Reasons: 1. The network has a hacker trying to get...