Thursday, March 22, 2012

Error deleting database

Hi,
We currently have Great Plains 7.5 linked to our SQL 2000 server. I'm now
having a problem removing a database that was added (via Gt.Plains first). An
error message telling me that SQL failed to install the database correctly
appeared, but whenever I try to remove it from Great Plains I get an error,
even though I'm logged into GP and SQL with full admin rights:
From Great Plains I get:
"[Microsoft][ODBC SQL Server Driver][SQL Server] Could not locate entry in
sysdatabases for database 'TEST'. No entry found with that name. Make sure
that the name is entered correctly."
When clicking OK, the following appears
"The stored procedure smCreateCompanyDeleteButtonCHG returned the following
results: DBMS: 911, Great Plains: 0."
If you click MORE, you get:
"Please consult the alert message documentation provided by your DBMS."
So, I can't remove the TEST database. Now, I'm relatively new to SQL 2000,
so I've been finding snippets of info on the web, and so far I have tried a
few things including running the following from Query analyzer:
SELECT CATALOG_NAME from INFORMATION_SCHEMA.SCHEMA
But, that has not shown the rogue database name. But, when you are in
Gt.Plains the TEST database is listed in the 'logon to' options, even though
it's not listed anywhere in SQL.
So, how do I remove all traces of a database (as full systems admin) in
Gt.PLains and SQL since it failed?
Many thanks
JohnI think you have to post this in the GP group or contact GP support. It
looks like the database is not there in SQL Server, but somehow GP is
thinking the db is there.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"John" <John@.discussions.microsoft.com> wrote in message
news:808D30A3-4F06-4567-89B0-6087D5245AAC@.microsoft.com...
Hi,
We currently have Great Plains 7.5 linked to our SQL 2000 server. I'm now
having a problem removing a database that was added (via Gt.Plains first).
An
error message telling me that SQL failed to install the database correctly
appeared, but whenever I try to remove it from Great Plains I get an error,
even though I'm logged into GP and SQL with full admin rights:
From Great Plains I get:
"[Microsoft][ODBC SQL Server Driver][SQL Server] Could not locate entry in
sysdatabases for database 'TEST'. No entry found with that name. Make sure
that the name is entered correctly."
When clicking OK, the following appears
"The stored procedure smCreateCompanyDeleteButtonCHG returned the following
results: DBMS: 911, Great Plains: 0."
If you click MORE, you get:
"Please consult the alert message documentation provided by your DBMS."
So, I can't remove the TEST database. Now, I'm relatively new to SQL 2000,
so I've been finding snippets of info on the web, and so far I have tried a
few things including running the following from Query analyzer:
SELECT CATALOG_NAME from INFORMATION_SCHEMA.SCHEMA
But, that has not shown the rogue database name. But, when you are in
Gt.Plains the TEST database is listed in the 'logon to' options, even though
it's not listed anywhere in SQL.
So, how do I remove all traces of a database (as full systems admin) in
Gt.PLains and SQL since it failed?
Many thanks
John|||Thanks, I'll try there first.
John
"Narayana Vyas Kondreddi" wrote:
> I think you have to post this in the GP group or contact GP support. It
> looks like the database is not there in SQL Server, but somehow GP is
> thinking the db is there.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:808D30A3-4F06-4567-89B0-6087D5245AAC@.microsoft.com...
> Hi,
> We currently have Great Plains 7.5 linked to our SQL 2000 server. I'm now
> having a problem removing a database that was added (via Gt.Plains first).
> An
> error message telling me that SQL failed to install the database correctly
> appeared, but whenever I try to remove it from Great Plains I get an error,
> even though I'm logged into GP and SQL with full admin rights:
> From Great Plains I get:
> "[Microsoft][ODBC SQL Server Driver][SQL Server] Could not locate entry in
> sysdatabases for database 'TEST'. No entry found with that name. Make sure
> that the name is entered correctly."
> When clicking OK, the following appears
> "The stored procedure smCreateCompanyDeleteButtonCHG returned the following
> results: DBMS: 911, Great Plains: 0."
> If you click MORE, you get:
> "Please consult the alert message documentation provided by your DBMS."
> So, I can't remove the TEST database. Now, I'm relatively new to SQL 2000,
> so I've been finding snippets of info on the web, and so far I have tried a
> few things including running the following from Query analyzer:
> SELECT CATALOG_NAME from INFORMATION_SCHEMA.SCHEMA
> But, that has not shown the rogue database name. But, when you are in
> Gt.Plains the TEST database is listed in the 'logon to' options, even though
> it's not listed anywhere in SQL.
> So, how do I remove all traces of a database (as full systems admin) in
> Gt.PLains and SQL since it failed?
> Many thanks
> John
>
>

No comments:

Post a Comment