I have the exact same issue today. I need to change the collation setting on approx 500 columns and was looking for a way to do this quickly. I found...

I get this error sometimes. It seems to happen when the owner of a Database does not exist as a login on the SQL Server.

For example, I transferred a Database to...

I found the solution for this in another post

It is caused by stale cache data and is fixed by a firmware update.

It is specific to a certain type of disk...

Strangely enough we have some SQL Servers listening on port 1434 for TCP/IP.

I still can't explain this, but using the actual port number in our cliconfg alias seems to work. If you...

Thanks to both of you for your advice.

Somehow I have managed now to shrink the file. I tried using the shrink database through enterprise manager and it actually increased the...

Thanks

Yes I tried already. Whatever I do, I cannot remove the 26mb used. I can expand the device further, and when I shrink it again, it will not reduce below...

Yelena you were right..

If I specifically use the port number that the SQL Server instance is listening on, then I can get a connection throught TCP/IP.

This simply means, having a...

Hi

They are named instances, on clustered servers. In a cluster, when you perform the second installation of SQL Server 2000, you are forced to use an instance name. When the named...

I'm sure you will have solved this by now Bill, or upgraded to SQL2000, but I thought it would be useful to reply to your question in case somebody else...