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
John
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
|||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
>
>

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
>
>

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). A
n
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 locat
e 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 locat
e 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 loc
ate 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 followin
g
> 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 thou
gh
> 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
>
>sql

Error deleting a folder

When we try to delete a folder in de report manager we get an internal error
from the Report server .
In the log we find:
w3wp!library!8!04/25/2007-12:46:33:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., un-named assertion fired for component library;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
w3wp!library!11!04/25/2007-12:46:45:: i INFO: Call to GetSystemPermissions
w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetSystemPermissions
w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to CreateFolder( 'New
Folder', '/')
w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetPermissions:/
w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetSystemPermissions
w3wp!library!8!04/25/2007-12:47:04:: i INFO: Exception dumped to: C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!8!04/25/2007-12:47:09:: i INFO: Call to RenderFirst(
'/Boordtabel/dummy' )
w3wp!webserver!8!04/25/2007-12:47:10:: i INFO: Processed report.
Report='/Boordtabel/dummy', Stream=''
w3wp!library!1!04/25/2007-12:47:12:: i INFO: Call to GetPermissions:/
w3wp!library!11!04/25/2007-12:47:12:: i INFO: Call to GetSystemPermissions
w3wp!library!1!04/25/2007-12:47:12:: i INFO: Call to DeleteItem( '/New
Folder' )
w3wp!library!1!04/25/2007-12:47:12:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.Library.RSService._DeleteItem(String item)
Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId)
Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch()
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[]
arguments, SignatureStruct& sig, MethodAttributes methodAttributes,
RuntimeTypeHandle typeOwner)
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[]
arguments, Signature sig, MethodAttributes methodAttributes,
RuntimeTypeHandle typeOwner)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean
skipVisibilityChecks)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target,
Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!1!04/25/2007-12:47:12:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., un-named assertion fired for component library;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
Any ideas?On Apr 25, 6:06 am, Antoon <Ant...@.discussions.microsoft.com> wrote:
> When we try to delete a folder in de report manager we get an internal error
> from the Report server .
> In the log we find:
> w3wp!library!8!04/25/2007-12:46:33:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details., un-named assertion fired for component library;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details.
> w3wp!library!11!04/25/2007-12:46:45:: i INFO: Call to GetSystemPermissions
> w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetSystemPermissions
> w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to CreateFolder( 'New
> Folder', '/')
> w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetPermissions:/
> w3wp!library!11!04/25/2007-12:46:48:: i INFO: Call to GetSystemPermissions
> w3wp!library!8!04/25/2007-12:47:04:: i INFO: Exception dumped to: C:\Program
> Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags=> ReferencedMemory, AllThreads, SendToWatson
> w3wp!library!8!04/25/2007-12:47:09:: i INFO: Call to RenderFirst(
> '/Boordtabel/dummy' )
> w3wp!webserver!8!04/25/2007-12:47:10:: i INFO: Processed report.
> Report='/Boordtabel/dummy', Stream=''
> w3wp!library!1!04/25/2007-12:47:12:: i INFO: Call to GetPermissions:/
> w3wp!library!11!04/25/2007-12:47:12:: i INFO: Call to GetSystemPermissions
> w3wp!library!1!04/25/2007-12:47:12:: i INFO: Call to DeleteItem( '/New
> Folder' )
> w3wp!library!1!04/25/2007-12:47:12:: a ASSERT: Assertion failed! Call stack:
> Microsoft.ReportingServices.Library.RSService._DeleteItem(String item)
> Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId)
> Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch()
> System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[]
> arguments, SignatureStruct& sig, MethodAttributes methodAttributes,
> RuntimeTypeHandle typeOwner)
> System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[]
> arguments, Signature sig, MethodAttributes methodAttributes,
> RuntimeTypeHandle typeOwner)
> System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
> invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean
> skipVisibilityChecks)
> System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
> invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
> System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target,
> Object[] values)
> System.Web.Services.Protocols.WebServiceHandler.Invoke()
> System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
> System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> w3wp!library!1!04/25/2007-12:47:12:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details., un-named assertion fired for component library;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for more
> details.
> Any ideas?
This posting might be of assistance.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/ebfe917dd50ecb0c/b6c5fe0bc216e8c7?lnk=st&q=Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException%3A+&rnum=5#b6c5fe0bc216e8c7
Regards,
Enrique Martinez
Sr. Software Consultant

Error creating new push subscription after deleting the existing o

I created a transactional replication publication and pushed a subscriber,
and that works fine. I deleted existing push subscription in the publisher
with enterprise manager, and also deleted automatically generated replication
jobs related to that push subscription. I noticed that the push subscription
was not automatically deleted in the subscriber as it should. Moreover, when
I created a new push subscription with the same article, I encountered an
error. The error message is as following.
Subscriptions were created successfully at the following subscribers.
…
SQL Server Enterprise manager could not start the snapshot agent.
Error 14262:the specified @.job_id … does not exist.
Please help.
The error indicates that a replication agent job was deleted accidentally.
When this issue occurs, the most efficient way would be rebuilding the
replication from scratch.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.

Error Capture in Procedure?

Is there anyway to capture and manage errors in a procedure so it can
proceed?
(The server keeps deleting my posts; I hope this one gets through)
TIA!
--
Greg CHi Greg.
There are error handling mechanisms in SQL Server, but they do not allow you
to catch or handle or errors.
Ultimately, you cannot handle all t-sql errors in stored procedures.
There is a good article on the topic here:
http://www.sommarskog.se/
HTH
Regards,
Greg Linwood
SQL Server MVP
"Greg C" <gregc@.austinps.com> wrote in message
news:fT%Mb.16281$RV5.7088@.fe2.texas.rr.com...
> Is there anyway to capture and manage errors in a procedure so it can
> proceed?
> (The server keeps deleting my posts; I hope this one gets through)
> TIA!
> --
> Greg C
>|||Thanks Greg.
--
Greg C
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:#BR3XZk2DHA.2888@.tk2msftngp13.phx.gbl...
> Hi Greg.
> There are error handling mechanisms in SQL Server, but they do not allow
you
> to catch or handle or errors.
> Ultimately, you cannot handle all t-sql errors in stored procedures.
> There is a good article on the topic here:
> http://www.sommarskog.se/
> HTH
> Regards,
> Greg Linwood
> SQL Server MVP
> "Greg C" <gregc@.austinps.com> wrote in message
> news:fT%Mb.16281$RV5.7088@.fe2.texas.rr.com...
> >
> > Is there anyway to capture and manage errors in a procedure so it can
> > proceed?
> >
> > (The server keeps deleting my posts; I hope this one gets through)
> >
> > TIA!
> >
> > --
> >
> > Greg C
> >
> >
>

Error Capture in Procedure?

Is there anyway to capture and manage errors in a procedure so it can
proceed?
(The server keeps deleting my posts; I hope this one gets through)
TIA!
Greg CHi Greg.
There are error handling mechanisms in SQL Server, but they do not allow you
to catch or handle or errors.
Ultimately, you cannot handle all t-sql errors in stored procedures.
There is a good article on the topic here:
http://www.sommarskog.se/
HTH
Regards,
Greg Linwood
SQL Server MVP
"Greg C" <gregc@.austinps.com> wrote in message
news:fT%Mb.16281$RV5.7088@.fe2.texas.rr.com...

quote:

---

> Is there anyway to capture and manage errors in a procedure so it can
> proceed?
> (The server keeps deleting my posts; I hope this one gets through)
> TIA!
> --
> Greg C
>

---

|||Thanks Greg.
Greg C
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:#BR3XZk2DHA.2888@.tk2msftngp13.phx.gbl...

quote:

---

> Hi Greg.
> There are error handling mechanisms in SQL Server, but they do not allow

---

you

quote:

---

> to catch or handle or errors.
> Ultimately, you cannot handle all t-sql errors in stored procedures.
> There is a good article on the topic here:
> http://www.sommarskog.se/
> HTH
> Regards,
> Greg Linwood
> SQL Server MVP
> "Greg C" <gregc@.austinps.com> wrote in message
> news:fT%Mb.16281$RV5.7088@.fe2.texas.rr.com...
>

---