I'm mainly a MS SQL Server guy, but I toyed around a bit with a pretty interesting databse called Caché from Intersystems. Runs on Unix, Linux or Windows, is really...

In EM just delete the registration and make a new server registration, typing the name of the server.

There does QA get's his information from? From the registry.

The reason why you still get this alert is the way SQL Server detects these situations. What the alert is doing is it looks in the sysperfinfo table. If you...

What result do you get when you run DATABASEPROPERTYEX (Collation) ? If it shows the right collation I wouldn't worry too much about it. I've seen more cases there EM...

Try: http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

M

Does the database still exists in the sysdatabases table of the master database ?

If yes you can configure the server to allow direct updates and system tables and when remove...

http://www.microsoft.com/technet

Sorry Frank, but the clue is that we're not looking for the values from master..sysfiles, but the sysfiles table in the current database, whichever that might be.

Markus

Does your SQLServerAgent account have access on the remote server? You might wanna checkout this Technet article Q321822.

It's the MSSQL Server if you look in services.

If you can connect through QA just run Select @@version. In the registry under HKEY LOCAOL MACHINE\SOFTWARE\MICROSOFT you find a key MSDE in case it's the MSDE version. But be...

Yes it is. All database have SQL_Latin_CP850_CI_AS, except for the test database I created.

The problem is the same, no matter if I use EM on the server or any client workstation. SP3 is installed.

I also tried to create a new database using the...

I get the error when trying to grant access to the database for an existing login. But anyhow the error appears imediately after selecting "Add new user", so I don't...

To be honest I don't have the answer, but I ran into the same problem recently and it seems to mee that this problem is specific for queries of the...