Viewing 15 posts - 1,621 through 1,635 (of 1,654 total)
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.
[font="Verdana"]Markus Bohse[/font]
May 14, 2003 at 7:43 am
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...
[font="Verdana"]Markus Bohse[/font]
May 14, 2003 at 6:18 am
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...
[font="Verdana"]Markus Bohse[/font]
May 14, 2003 at 1:23 am
Try: http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp
M
[font="Verdana"]Markus Bohse[/font]
May 13, 2003 at 8:07 am
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...
[font="Verdana"]Markus Bohse[/font]
May 13, 2003 at 7:58 am
http://www.microsoft.com/technet
[font="Verdana"]Markus Bohse[/font]
May 13, 2003 at 5:08 am
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
[font="Verdana"]Markus Bohse[/font]
May 13, 2003 at 2:39 am
Does your SQLServerAgent account have access on the remote server? You might wanna checkout this Technet article Q321822.
[font="Verdana"]Markus Bohse[/font]
May 13, 2003 at 1:17 am
It's the MSSQL Server if you look in services.
[font="Verdana"]Markus Bohse[/font]
May 13, 2003 at 1:11 am
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...
[font="Verdana"]Markus Bohse[/font]
May 13, 2003 at 1:01 am
Yes it is. All database have SQL_Latin_CP850_CI_AS, except for the test database I created.
[font="Verdana"]Markus Bohse[/font]
May 12, 2003 at 9:12 am
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...
[font="Verdana"]Markus Bohse[/font]
May 12, 2003 at 8:38 am
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...
[font="Verdana"]Markus Bohse[/font]
May 12, 2003 at 7:51 am
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...
[font="Verdana"]Markus Bohse[/font]
May 12, 2003 at 7:14 am
You changed the service account of the SQL Agent to a domain account but not the MSSQLService account. While notifications for operators are handled by SQL Agent Mail, xp_startmail, xp_sendmail...
[font="Verdana"]Markus Bohse[/font]
May 12, 2003 at 3:56 am
Viewing 15 posts - 1,621 through 1,635 (of 1,654 total)