It is most likely a hotfix that fixes a particular problem. Some hotfixes are only available via Microsoft's PSS. Here's a link to MDAC hotfixes that are publically available. ...

My company pays for a lot of our training. But we have to prove that the client and/or company will benefit from it. If the client doesn't feel they will...

First, why would you want to do that? In your select, you can get the columns/fields in any order you want.

Second, it's a real hassle to change the order....

Please don't double post. You already have this posted and are receiving responses on the other thread.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=253060#bm253181

-SQLBill

This is why you need to do one of two things with every database, including system databases.

1. set the database to autogrow (I prefer a set size not a percentage).

2....

How about:

WHERE CASE WHEN @BU = '%'

THEN DEPTID LIKE @BU

...

Lonnie,

It almost sounds like you are using the vendor's product to interface and administer the database, is that true? If so, we really aren't going to be able to help...

Is there a reason these databases need to be run on the 'main' database instance?

Options....

1. Install MSDE (free) on each workstation....that is the very basic database version. They could...

C and Francisco,

You both are following up a post that ended in October of 2005.

C,

As for the DUMP command, yes it works in SQL Server 2000, but you...

I'm guessing the problem is that you are converting to VARCHAR and that sorts by dictionary order. It's hard to tell without seeing your results.

Again, without seeing your data, the...

I don't know how you did the restore, but I'm guessing you included the WITH NORECOVERY option or put it in standby. Try this...

RESTORE DATABASE dbname

WITH RECOVERY

-SQLBill

Why are they attaching and detaching the databases?

-SQLBill

I was two years from retiring from the U.S. Air Force and looking for a new career. I attended a job fair and asked each company....if I wanted to...

I like querying for the SERVERPROPERTY.

SELECT ServerProperty('Edition'),

ServerProperty('ProductVersion'),

ServerProperty('ProductLevel')

Refer to the BOL, use the Index tab and enter...

Yes you can attach those files to the new server.

-SQLBill