Personally this is an ongoing problem, I have it in the 2K EM in SOME cases.

Probably MS trying to save some overhead, but I would think if I click REFRESH...

I'll follow mccork, our developer dbas always start with unicode, until I push back.

Of course they also love Varchar(1) !!!!

Worse they start at NVarChar(1).

KlK, MCSE

Allen, well I was in some classes so I didn't have time to check the MDAC level, both are 2.70.7713.4

Brian, I just meant that I don't give security to Master,...

Sorry Allen, I can use Query analyzer to select from either DB, and the ODBC connection will allow access to the 'default' DB. As far as MDACs, I don't...

Should responded, actually it appears that SQL 7 cannot be installed via Remote Desktop. I had to shake the cobwebs off, but suddenly it hit me that maybe 7...

The collation error is occuring on a

WHERE t1.text <> t2.text Collation ....

It says it can't resolve it.

KlK, MCSE

I did one earlier got the hat.

This time I did 2, sent one here to work, one to home.

I love freebies.

KlK, MCSE

Allen I don't really understand your response.

When the tables are created they are assigned to a file group, so the restore would have to follow that.

After the restore, create a...

Search the registry for "master.mdf".

or HKLM\Software\Microsoft\Microsoft SQL Server\SQL2K\Parameters

SQL2k is the instance name.

This is actually a trick I found to move Master. Restore the correct master to ???.

STOP SSQL,...

I don't know if it's too late in your setup but at a conference a while back someone provided a neat solution.

Instance1 Start at 1000, Increment 2

Instance2 Start at 1001,...

Thanks Greg, a slight variation of what you provided, solved it perfectly.

KlK, MCSE

Unfortunately what I am trying to EXEC is basically a CREATE .... or Alter ...

I thought I had seen this somewhere ??

KlK, MCSE

For most of our DB servers that are on SANs I request multiple LUNs. I think there is a lot of benefits separating things. I try and put Data,...

No idea how to do specifically what you want, but I know there are issue's. Whay not just consider adding a LUN, and have two drives.

KlK, MCSE

Thanks Greg, Make me feel old :-}

I've been in this Biz an real long time. I just stay with current technologies. My current job has very little MainFrame...