Weird Messages In Error Log

Mar 28, 2008

Hi,
I am getting these messages in error log. What do I needd to do?

2008-03-27 09:34:54.76 spid74 Using 'dbghelp.dll' version '4.0.5'
2008-03-27 09:34:54.76 spid74 ***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0014.txt
2008-03-27 09:34:54.76 spid74 SqlDumpExceptionHandler: Process 74 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2008-03-27 09:34:54.76 spid74 * *******************************************************************************
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 * BEGIN STACK DUMP:
2008-03-27 09:34:54.76 spid74 * 03/27/08 09:34:54 spid 74
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 * Exception Address = 7C80EEF0 Module(ntdll+0000EEF0)
2008-03-27 09:34:54.76 spid74 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2008-03-27 09:34:54.76 spid74 * Access Violation occurred reading address 00000001
2008-03-27 09:34:54.76 spid74 * Input Buffer 87 bytes -
2008-03-27 09:34:54.76 spid74 * C a m s _ V a l 15 00 43 00 61 00 6d 00 73 00 5f 00 56 00 61 00 6c 00
2008-03-27 09:34:54.76 spid74 * i d a t e P a s s 69 00 64 00 61 00 74 00 65 00 50 00 61 00 73 00 73 00
2008-03-27 09:34:54.76 spid74 * w o r d § 77 00 6f 00 72 00 64 00 00 00 00 00 a7 0f 00 09 04 00
2008-03-27 09:34:54.76 spid74 * 2 JFINCH § 01 32 06 00 4a 46 49 4e 43 48 00 00 a7 20 00 09 04 00
2008-03-27 09:34:54.76 spid74 * 2 JFINCH & 01 32 06 00 4a 46 49 4e 43 48 00 01 26 04 00
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 * MODULE BASE END SIZE
2008-03-27 09:34:54.76 spid74 * sqlservr 01000000 02C09FFF 01c0a000
2008-03-27 09:34:54.76 spid74 * ntdll 7C800000 7C8BFFFF 000c0000
2008-03-27 09:34:54.76 spid74 * kernel32 77E40000 77F41FFF 00102000
2008-03-27 09:34:54.76 spid74 * MSVCR80 78130000 781CAFFF 0009b000
2008-03-27 09:34:54.76 spid74 * msvcrt 77BA0000 77BF9FFF 0005a000
2008-03-27 09:34:54.76 spid74 * MSVCP80 7C420000 7C4A6FFF 00087000
2008-03-27 09:34:54.76 spid74 * ADVAPI32 77F50000 77FEAFFF 0009b000
2008-03-27 09:34:54.76 spid74 * RPCRT4 77C50000 77CEEFFF 0009f000
2008-03-27 09:34:54.76 spid74 * Secur32 76F50000 76F62FFF 00013000
2008-03-27 09:34:54.76 spid74 * USER32 77380000 77410FFF 00091000
2008-03-27 09:34:54.76 spid74 * GDI32 77C00000 77C47FFF 00048000
2008-03-27 09:34:54.76 spid74 * CRYPT32 761B0000 76242FFF 00093000
2008-03-27 09:34:54.76 spid74 * MSASN1 76190000 761A1FFF 00012000
2008-03-27 09:34:54.76 spid74 * MSWSOCK 71B20000 71B60FFF 00041000
2008-03-27 09:34:54.76 spid74 * WS2_32 71C00000 71C16FFF 00017000
2008-03-27 09:34:54.76 spid74 * WS2HELP 71BF0000 71BF7FFF 00008000
2008-03-27 09:34:54.76 spid74 * USERENV 76920000 769E1FFF 000c2000
2008-03-27 09:34:54.76 spid74 * opends60 333E0000 333E6FFF 00007000
2008-03-27 09:34:54.76 spid74 * NETAPI32 71C40000 71C96FFF 00057000
2008-03-27 09:34:54.76 spid74 * SHELL32 7C8D0000 7D0CEFFF 007ff000
2008-03-27 09:34:54.76 spid74 * SHLWAPI 77DA0000 77DF1FFF 00052000
2008-03-27 09:34:54.76 spid74 * comctl32 77420000 77522FFF 00103000
2008-03-27 09:34:54.76 spid74 * psapi 76B70000 76B7AFFF 0000b000
2008-03-27 09:34:54.76 spid74 * instapi 48060000 48069FFF 0000a000
2008-03-27 09:34:54.76 spid74 * sqlevn70 4F610000 4F7B8FFF 001a9000
2008-03-27 09:34:54.76 spid74 * SQLOS 344D0000 344D4FFF 00005000
2008-03-27 09:34:54.76 spid74 * rsaenh 68000000 68034FFF 00035000
2008-03-27 09:34:54.76 spid74 * AUTHZ 76C40000 76C53FFF 00014000
2008-03-27 09:34:54.76 spid74 * MSCOREE 79000000 79045FFF 00046000
2008-03-27 09:34:54.76 spid74 * ole32 77670000 777A8FFF 00139000
2008-03-27 09:34:54.76 spid74 * msv1_0 76C90000 76CB6FFF 00027000
2008-03-27 09:34:54.76 spid74 * iphlpapi 76CF0000 76D09FFF 0001a000
2008-03-27 09:34:54.76 spid74 * kerberos 629A0000 629F7FFF 00058000
2008-03-27 09:34:54.76 spid74 * cryptdll 766E0000 766EBFFF 0000c000
2008-03-27 09:34:54.76 spid74 * schannel 76750000 76776FFF 00027000
2008-03-27 09:34:54.76 spid74 * COMRES 77010000 770D5FFF 000c6000
2008-03-27 09:34:54.76 spid74 * XOLEHLP 62A60000 62A65FFF 00006000
2008-03-27 09:34:54.76 spid74 * MSDTCPRX 62A70000 62AE8FFF 00079000
2008-03-27 09:34:54.76 spid74 * OLEAUT32 77D00000 77D8AFFF 0008b000
2008-03-27 09:34:54.76 spid74 * msvcp60 62AF0000 62B54FFF 00065000
2008-03-27 09:34:54.76 spid74 * MTXCLU 62B60000 62B78FFF 00019000
2008-03-27 09:34:54.76 spid74 * VERSION 77B90000 77B97FFF 00008000
2008-03-27 09:34:54.76 spid74 * WSOCK32 71BB0000 71BB8FFF 00009000
2008-03-27 09:34:54.76 spid74 * CLUSAPI 62B80000 62B91FFF 00012000
2008-03-27 09:34:54.76 spid74 * RESUTILS 62BA0000 62BB2FFF 00013000
2008-03-27 09:34:54.76 spid74 * DNSAPI 76ED0000 76EF9FFF 0002a000
2008-03-27 09:34:54.76 spid74 * winrnr 76F70000 76F76FFF 00007000
2008-03-27 09:34:54.76 spid74 * WLDAP32 76F10000 76F3DFFF 0002e000
2008-03-27 09:34:54.76 spid74 * rasadhlp 76F80000 76F84FFF 00005000
2008-03-27 09:34:54.76 spid74 * security 62FF0000 62FF3FFF 00004000
2008-03-27 09:34:54.76 spid74 * msfte 637D0000 63A28FFF 00259000
2008-03-27 09:34:54.76 spid74 * dbghelp 63A40000 63B54FFF 00115000
2008-03-27 09:34:54.76 spid74 * WINTRUST 76BB0000 76BDAFFF 0002b000
2008-03-27 09:34:54.76 spid74 * imagehlp 76C10000 76C37FFF 00028000
2008-03-27 09:34:54.76 spid74 * dssenh 68100000 68126FFF 00027000
2008-03-27 09:34:54.76 spid74 * hnetcfg 63DA0000 63DF9FFF 0005a000
2008-03-27 09:34:54.76 spid74 * wshtcpip 71AE0000 71AE7FFF 00008000
2008-03-27 09:34:54.76 spid74 * NTMARTA 77E00000 77E20FFF 00021000
2008-03-27 09:34:54.76 spid74 * SAMLIB 7E020000 7E02EFFF 0000f000
2008-03-27 09:34:54.76 spid74 * ntdsapi 766F0000 76703FFF 00014000
2008-03-27 09:34:54.76 spid74 * xpsp2res 63F40000 64204FFF 002c5000
2008-03-27 09:34:54.76 spid74 * CLBCatQ 777B0000 77832FFF 00083000
2008-03-27 09:34:54.76 spid74 * sqlncli 64210000 64433FFF 00224000
2008-03-27 09:34:54.76 spid74 * COMCTL32 77530000 775C6FFF 00097000
2008-03-27 09:34:54.76 spid74 * comdlg32 762B0000 762F8FFF 00049000
2008-03-27 09:34:54.76 spid74 * SQLNCLIR 007C0000 007F2FFF 00033000
2008-03-27 09:34:54.76 spid74 * msftepxy 64670000 64684FFF 00015000
2008-03-27 09:34:54.76 spid74 * xp_ctnhashproc 62910000 6292EFFF 0001f000
2008-03-27 09:34:54.76 spid74 * xplog70 63360000 6336BFFF 0000c000
2008-03-27 09:34:54.76 spid74 * xplog70 63380000 63382FFF 00003000
2008-03-27 09:34:54.76 spid74 * sqlvdi 645D0000 645F1FFF 00022000
2008-03-27 09:34:54.76 spid74 * xpstar90 630B0000 630F8FFF 00049000
2008-03-27 09:34:54.76 spid74 * SQLSCM90 633C0000 633C8FFF 00009000
2008-03-27 09:34:54.76 spid74 * ODBC32 64450000 6448CFFF 0003d000
2008-03-27 09:34:54.76 spid74 * BatchParser90 64490000 644AEFFF 0001f000
2008-03-27 09:34:54.76 spid74 * ATL80 7C630000 7C64AFFF 0001b000
2008-03-27 09:34:54.76 spid74 * odbcint 64DC0000 64DD6FFF 00017000
2008-03-27 09:34:54.76 spid74 * xpstar90 65330000 65355FFF 00026000
2008-03-27 09:34:54.76 spid74 * xpsqlbot 64DE0000 64DE5FFF 00006000
2008-03-27 09:34:54.76 spid74 * msxmlsql 78800000 788D4FFF 000d5000
2008-03-27 09:34:54.76 spid74 * msxml2 66030000 660DEFFF 000af000
2008-03-27 09:34:54.76 spid74 * msxml3 67040000 67156FFF 00117000
2008-03-27 09:34:54.76 spid74 * dbghelp 68930000 68A44FFF 00115000
2008-03-27 09:34:54.76 spid74 *
2008-03-27 09:34:54.76 spid74 * Edi: 62930000: 000000C8 00000187 EEFFEEFF 00001002 00000000 0000FE00
2008-03-27 09:34:54.76 spid74 * Esi: 1C3C2EE8: 010A50E8 00000001 1C3C2490 0000D333 1C3C2F10 1C3C2F08
2008-03-27 09:34:54.76 spid74 * Eax: 010A50E8: 010B7A71 01659AC6 01659ACE 018484D0 018484D8 01659ADE
2008-03-27 09:34:54.76 spid74 * Ebx: 00000000:
2008-03-27 09:34:54.76 spid74 * Ecx: 00000001:
2008-03-27 09:34:54.76 spid74 * Edx: 62930608: 00127668 FFFFFFFE 00000001 00000430 00000000 00000FA0
2008-03-27 09:34:54.76 spid74 * Eip: 7C80EEF0: 503B118B 56850F04 3B00031E 4E850FD6 8900031E 04488901
2008-03-27 09:34:54.76 spid74 * Ebp: 656DCD84: 00000020 6291ED76 62930000 00000000 1C3C2F08 3910C3B0
2008-03-27 09:34:54.76 spid74 * SegCs: 0000001B:
2008-03-27 09:34:54.76 spid74 * EFlags: 00010207: 47004900 5F005700 4F004C00 3D004300 3A004300 50005C00
2008-03-27 09:34:54.76 spid74 * Esp: 656DCCB4: 1C3C2F08 1C3C2F08 654E05E0 0100469B 656DCD74 78132C78
2008-03-27 09:34:54.76 spid74 * SegSs: 00000023:
2008-03-27 09:34:54.76 spid74 * *******************************************************************************
2008-03-27 09:34:54.76 spid74 * -------------------------------------------------------------------------------
2008-03-27 09:34:54.76 spid74 * Short Stack Dump
2008-03-27 09:34:54.77 spid74 7C80EEF0 Module(ntdll+0000EEF0)
2008-03-27 09:34:54.77 spid74 6291ED76 Module(xp_ctnhashproc+0000ED76)
2008-03-27 09:34:54.77 spid74 62911184 Module(xp_ctnhashproc+00001184)
2008-03-27 09:34:54.77 spid74 01660FEC Module(sqlservr+00660FEC)
2008-03-27 09:34:54.77 spid74 01662FCD Module(sqlservr+00662FCD)
2008-03-27 09:34:54.77 spid74 01662984 Module(sqlservr+00662984)
2008-03-27 09:34:54.77 spid74 01661920 Module(sqlservr+00661920)
2008-03-27 09:34:54.77 spid74 01661E2E Module(sqlservr+00661E2E)
2008-03-27 09:34:54.77 spid74 01C1BF0C Module(sqlservr+00C1BF0C)
2008-03-27 09:34:54.77 spid74 014B3FE1 Module(sqlservr+004B3FE1)
2008-03-27 09:34:54.77 spid74 012389B6 Module(sqlservr+002389B6)
2008-03-27 09:34:54.77 spid74 0123882D Module(sqlservr+0023882D)
2008-03-27 09:34:54.77 spid74 012386C2 Module(sqlservr+002386C2)
2008-03-27 09:34:54.77 spid74 010227F3 Module(sqlservr+000227F3)
2008-03-27 09:34:54.77 spid74 010293B5 Module(sqlservr+000293B5)
2008-03-27 09:34:54.77 spid74 010286DC Module(sqlservr+000286DC)
2008-03-27 09:34:54.77 spid74 01032A36 Module(sqlservr+00032A36)
2008-03-27 09:34:54.77 spid74 0102F1F4 Module(sqlservr+0002F1F4)
2008-03-27 09:34:54.77 spid74 010077A6 Module(sqlservr+000077A6)
2008-03-27 09:34:54.77 spid74 010078CC Module(sqlservr+000078CC)
2008-03-27 09:34:54.77 spid74 010075DC Module(sqlservr+000075DC)
2008-03-27 09:34:54.77 spid74 010B94A5 Module(sqlservr+000B94A5)
2008-03-27 09:34:54.77 spid74 010B939C Module(sqlservr+000B939C)
2008-03-27 09:34:54.77 spid74 010B9064 Module(sqlservr+000B9064)
2008-03-27 09:34:54.79 spid74 010B9201 Module(sqlservr+000B9201)
2008-03-27 09:34:54.79 spid74 781329BB Module(MSVCR80+000029BB)
2008-03-27 09:34:54.79 spid74 78132A47 Module(MSVCR80+00002A47)
2008-03-27 09:34:54.79 spid74 Stack Signature for the dump is 0xD5652648
2008-03-27 09:34:56.31 spid74 External dump process return code 0x20002001.
The error information has been submitted to Watson error reporting.

2008-03-27 09:34:56.31 spid74 Error: 18002, Severity: 20, State: 1.
2008-03-27 09:34:56.31 spid74 Exception happened when running extended stored procedure 'xp_ctnhash' in the library 'xp_ctnhashproc.dll'. SQL Server is terminating process 74. Exception type: Win32 exception; Exception code: 0xc0000005.

View 5 Replies


ADVERTISEMENT

Merge Replication Throwing Very Weird Error Messages

Mar 2, 2007

I've been setting up subscriptions to a merge publication for the past 3 days. All of a sudden, I'm getting a pile of very strange errors. Replication is configured. I have 16 subscribers to an existing publication configured and synchronizing changes without any issues. The script that I'm using to create all of the subscriptions is as follows:

use [PIC]

exec sp_addmergesubscription @publication = N'PIC', @subscriber = N'machinenameSQLEXPRESS',

@subscriber_db = N'MyDatabase', @subscription_type = N'Push', @sync_type = N'Automatic',

@subscriber_type = N'Global', @subscription_priority = 75, @description = N'', @use_interactive_resolver = N'False'

exec sp_addmergepushsubscription_agent @publication = N'PIC', @subscriber = N'machinenameSQLEXPRESS',

@subscriber_db = N'MyDatabase', @job_login = null, @job_password = null, @subscriber_security_mode = 1,

@publisher_security_mode = 1, @frequency_type = 64, @frequency_interval = 0, @frequency_relative_interval = 0,

@frequency_recurrence_factor = 0, @frequency_subday = 0, @frequency_subday_interval = 0, @active_start_time_of_day = 0,

@active_end_time_of_day = 235959, @active_start_date = 0, @active_end_date = 0

GO

The last one that I added #17, gives the following errors after successfully creating the subscription.

Command attempted:


{call sys.sp_MSmergesubscribedb ('true', 0) }

Error messages:


The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011)
Get help: http://help/MSSQL_REPL-2147201011

RegCreateKeyEx() returned error 5, 'Access is denied.' (Source: MSSQLServer, Error number: 22002)
Get help: http://help/22002

Could not add article resolver 'Microsoft SQL Server Additive Conflict Resolver' information to the registry (Source: MSSQLServer, Error number: 21713)
Get help: http://help/21713

Could not register article resolver: 'Microsoft SQL Server Additive Conflict Resolver'. (Source: MSSQLServer, Error number: 21715)
Get help: http://help/21715

The system tables for merge replication could not be created successfully. (Source: MSSQLServer, Error number: 20008)
Get help: http://help/20008

I've tried to manually create it using the GUI and get an even stranger error message as follows:

TITLE: New Subscription Wizard
------------------------------

Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Replication components are not installed on this server. Run SQL Server Setup again and select the option to install replication. (Microsoft SQL Server, Error: 21028)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=21028&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


I very obviously have replication installed by virtue of the fact that I have a publication and 16 subscriptions that are currently synchronizing. Any ideas?

View 3 Replies View Related

A Weird Error !

Jul 25, 2006

I was developing a data-driven website but I got this error
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 
(I have Sql server 2005 also downloaded before)
Please help me cause any website that has data can not be executed even the quick start tutorial that ships with the ASP.NET 2.0
What should I do?

View 1 Replies View Related

Weird Ado.net 2.0 Error

Nov 19, 2006

Why does ado.net produce this error when I kow for a fact that there are no connections to any sql server 2005 database involved - this could and probbaly has had people off looking at the wrong connection strings in their web.configs.
Note:- The connection string we have is to a sql 200 db I just wanted to make that clear.
CheersGegor
Error Message:An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)Stack Trace:   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)   at System.Data.SqlClient.SqlConnection.Open()   at System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo)

View 8 Replies View Related

Weird Error

Mar 18, 2004

i have a form which takes in a lot of input...one of them is a date field..am passing all the values to the stored proc and inserting into a table from there...pretty simple...however when the user does not enter any value in the field...its errors out as...

String was not recognized as a valid DateTime.

heres the code in asp.net

myCommand.Parameters.Add(New SqlParameter("@cusbday",SqlDbType.datetime))
myCommand.Parameters("@cusbday").Value = trim(bday.text)


the field is optional....in my stored proc i am setting a default value too

....@cusbday Datetime =NULL,...

i also xplicitly set it to null through code
if @cusbday is null set @cusbday=null


how else do i resolve this...

thanks

View 13 Replies View Related

WEIRD ERROR

Feb 20, 2001

I was running a DTS package which transfer a complete database, about 2.3GB in size, to another database on the same server. It was necessary for environment change from dev to QA. I baby sat the package till it was rebuilding indexes (90%) complete. This morning I have the following error message on my screen,

[Microsoft][ODBC SQL Server Driver][SQL Server]
[Microsoft][ODBC SQL Server Driver][SQL Server]Location: r:SPHINXNTDBMSqueryqeexecqsxchng.inl:749
Expression: (m_cbPageMac + ulPxvarSize) <=m_pxpktdesc->m_cbPageMax
SPID: 40
ProcessID: 347

I have no idea at this time what caused it. And as far as I can tell there in r drive mapped wither on the serve or my computer ( I was running the DTS package from my machine).Any help is appreciated

View 1 Replies View Related

Weird Error

Dec 30, 2003

Heres some SQL I am trying to execute:

INSERT INTO Contact_Info (First,Last,Age) VALUES ('Alex','Strait',19)

Now it seems basic, but there in one more field that you're not supposed to specifiy a value in the SQL, its an int IDENTITY datatype field called num_id. Now this SQL works if it doesnt have the num_id field. But heres the error is gives me, I have never seen it before

Microsoft OLE DB Provider for ODBC Drivers error '80040e57'

[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

/neosql.asp, line 847

Does anyone know what is wrong?

View 6 Replies View Related

Weird SQL Auth Error

Jun 20, 2006

hey all, i have a weird authentication error.i have two servers, both running sql server 2005. one is on my workstation the other is on my dev server. i backed up my workstation database and restored it on the dev server. my workstation is xp and my server win2k3. i'm developing an asp.net 2.0 app that talks to my sql server using windows auth. on my workstation my website runs under the ASPNET account, IUSER_COMPUTERNAME and i had that account setup in sql on my workstation in the main security folder, then again in the db security folder the name of it was [ASPNET LOGIN]. each sproc had EXEC permission for [ASPNET LOGIN].when i restored it over to my win2k3 box i deleted that login from the database and revoked it on all the sprocs. i then setup another account for the application and set my website to use that account. i couldn't use the original account because of the group it was in, blah blah blah, not important.  the thing is, i got rid of all instances of that ASPNET LOGIN account and i'm running the website under a new account, and some of the stored procedures work, but some of them i get the error "Cannot find the user 'ASPNET LOGIN', because it does not exist or you do not have permission." which is crazy, because i've gotten rid of all references to that. it's not anywhere i see in the database, not in either security/users folder, it's not on any of the stored procedures. and it's NOWHERE in the website. not in IIS or code. furthermore some of the stored procedures work. as far as i can tell, the ones that are not called from my custom MemberShipProvider are working. so i went back to my database on my workstation, revoked exec permission on the sprocs, deleted the login from the db and then from the sql server instance, backed it up again, restored on my server and i'm still getting this issue.where can that ASPNET LOGIN be hiding? i restarted too thinking maybe it was cached somewhere. this is my connection string that the entire app uses: "Server=[serverName]; Database=[dbName]; Trusted_Connection=true;"my web.config is using <identity impersonate="true"/> and my website is running under the account i created.any ideas? i've been battling this for half a day.and why would it only happen with the membership provider? it's using the same connection string the rest of the app is.

View 3 Replies View Related

Weird Error DBSTATUS_UNAVAILABLE

Jan 16, 2007

Hello I have an issue with a data flow task that is reporting DBSTATUS_UNAVAILABLE. The data flow task consists of a Data Reader source which splits the rows off into 1 of 3 categories; update, insert, delete. Each destination is an OLEDB Command which respectively performs the needed operation.

The insert works fine as we just ran it yesterday and loaded 800,000 records into the table, the update is reporting the error, yet the data types match, both are nvarchar(25).

Does anyone have any idea why this might be occurring? We use this same method for all of our packages and yet this is the only one that seems to have this problem. Any help would be greatly appreciated. Thank you!

View 5 Replies View Related

Urgent : DB-Library Error 10007: General SQL Server Error: Check Messages From The SQL

Jul 20, 2005

DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh

View 1 Replies View Related

Weird Error Message During CLR SQL UDF In VS2005

Mar 8, 2006

I'm trying out the nifty new way of writing SPROCs and UDFs in CLR (C#).  I have a UDF that is a bit too complicated for T-SQL so I wrote it in C# but now I can't deploy it.
I run the build and it compiles fine.  Then I get this error when VS2005 tries to 'deploy':
------ Deploy started: Project: Kingsmere.SQL, Configuration: Debug Any CPU ------
Deploying file: Kingsmere.SQL.dll, Path: C:Documents and SettingsEmmanuelMy DocumentsVisual Studio 2005ProjectsKingsmere.SQLobjDebugKingsmere.SQL.dll ...
Error: Incorrect syntax near '&'.
I don't have a single ampersand character in my UDF's .cs file.  The Test.sql file doesn't have one either.  There is no file, line, column number associated with the error.  If I hit F1, I get help for compile time error CS0266 which is for no implicit cast available (which was the last compile error I got before compiling successfully so I think this is a red herring.  In other words, online help is just displaying the last know error number - nothing to do with the deployment error).
I've noticed that if I change the signature of the function from:
[Microsoft.SqlServer.Server.SqlFunction] public static int ComputeGoalNodeSpread(SqlInt64 Commence, SqlInt64 Finish, SqlByte TreeLevel, out SqlInt64 PreOrder, out SqlInt64 PostOrder)
to: [Microsoft.SqlServer.Server.SqlFunction] public static int ComputeGoalNodeSpread(SqlInt64 Commence, SqlInt64 Finish, SqlByte TreeLevel)
The error goes away.  Seems to be related to those By Reference parameters.
Help! 

View 1 Replies View Related

HELP - Weird Error After Replication Setup

Feb 19, 2004

Hello guys,
Have any ever seen this error before?

Steps I made:
1) Created Publications by script - using Manual Sync. (Transacat Repl)
2) Created Subscriptions by script
3) Started Distribution Agent
THEN THIS ERROR MSG:

Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__24F8BF73'. Cannot insert duplicate key in object '#24049B3A'.
(Source: SYD242 (Data source); Error number: 2627)
---------------------------------------------------------------------------------------------------------------


****Lost, has any got any ideas?

View 2 Replies View Related

Weird Proc Syntax Error

Mar 2, 2004

'Ello there. This proc has been giving me headaches for a week now, hopefully someone here knows whats wrong with it.


CREATE PROC [dbo].[search_querry_results](
@datefrom datetime = NULL,
@datetodatetime = NULL,
@querry_string varchar(60),
@slice int
)
AS

DECLARE @querry nvarchar(2000)
SET @querry = 'SELECT TOP ' + CAST(@slice AS varchar(100)) + ' * FROM FREETEXTTABLE( Exponent, *, ''' + @querry_string + ''' ) as ct JOIN Exponent AS e ON ct.[KEY] = e.[Key] WHERE date > ' + CAST( @datefrom AS varchar(30)) + ' AND date < ' + CAST(@dateto AS varchar(30)) + ' ORDER BY Rank DESC'

BEGIN
IF ( @datefrom IS NOT NULL ) AND ( @dateto IS NOT NULL )
EXEC sp_executesql @querry
END
GO


I am running it from Query Analyzer using the following line

EXEC search_querry_results @datefrom = '01/01/1970' , @dateto = '01/01/1980', @querry_string = 'Student' , @slice = '10'


The error it is giving me is: Line 1: Incorrect syntax near '1'.

Anyone have any ideas what is going wrong?

View 4 Replies View Related

Dbcc SHRINKFILE Gives Me A A Weird Error

Nov 21, 2006

I'm trying to run

dbcc shrinkfile(4)

/*

File ID 4 of database ID 13 cannot be shrunk as it is either being shrunk by another process or is empty.

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

*/



The commented lines is what I get in return. There's nothing being executed on this file. I dropped a few indexes. I need the space back from the file. Backups and everything are run on it normally. Is there something I'm missing or is there something wrong with it? I don't do 'AutoShrink'. Also, the file is not empty. Checkdb is working fine. Dbcc ShrinkDatabase also works fine but doesn't even recognize these files. It doesn't even show this files in the results pane when executing the command. Thank you for your help.

View 21 Replies View Related

Weird BIDS Error Message

Dec 15, 2006

For some unknown reason, I'm suddenly experiencing the following error when I open a package in BIDS:
Error 1 Error loading DimPromotionDemo.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. c:mdwt_projectsaworders_simpleaworders_simpleaworders_simpleDimPromotionDemo.dtsx 1 1

I don't see any error icons anywhere in my package. How do I go about figuring out what's wrong?

View 4 Replies View Related

Weird Error When Precompiling Genwin.mak With Nsqlprep

Jul 20, 2005

I am trying to compile the sample program genwin.sqc, using nsqlprepwhich is used to precompile embedded sql in C. I am getting weirderrors and that is because windows.h is included in the genwin.sqcfile. I am usingSetting the lib and include path:set INCLUDE=C:Program FilesMicrosoft SQLServer80ToolsDevToolsinclude;C:Program FilesMicrosoft SQLServer80ToolsDevToolsSamplesesqlc;%include%set LIB=C:Program FilesMicrosoft SQLServer80ToolsDevToolslib;%lib%Precompiling:nsqlprep genwin /NOACCESSMicrosoft (R) Embedded SQL for C Pre-Compiler. Version 8.00.194.Copyright (c) Microsoft Corp 1993-1998. All rights reserved.Warning: genwin.sqc, line 7978: syntax error.}Warning: genwin.sqc, line 7987: syntax error.}Warning: genwin.sqc, line 71840: syntax error.__declspec void __stdcall DragAcceptFiles(HWND,BOOLWarning: genwin.sqc, line 71842: syntax error.__declspec HINSTANCE __stdcall ShellExecuteA(HWND hwndWarning: genwin.sqc, line 71843: syntax error.__declspec HINSTANCE __stdcall ShellExecuteW(HWND hwndWarning: genwin.sqc, line 71858: syntax error.__declspec INT __stdcall ShellAboutA(HWND hWndWarning: genwin.sqc, line 71859: syntax error.__declspec INT __stdcall ShellAboutW(HWND hWndWarning: genwin.sqc, line 71941: syntax error.HWNDWarning: genwin.sqc, line 71946: syntax error.As soon as i remove windows.h, the errors disappear. It seems nsqlprepdoesnt like windows.h. How do i get over this.Would really appreciate if u can help me out.versions:OS: windows 2000 server service pack 2VC++: version 6.0SQLserver 2000: 8.00.194, RTM, Standard editionThank youAmit

View 1 Replies View Related

Weird Error Msg Running Similar Scripts In Same Package

Mar 22, 2007

Hello,

I have a package that has a FOREACHLOOP container. Inside the container is a SCRIPT task that runs a stored procedure and writes the output of the sp to a file.

That part works fine.

However, if I add a second script task inside the FOREACHLOOP container, I get error messages when running the second script task.

The second script task is identical to the first script task, except for the connection information. That is, it's doing the same thing, but running the sp on another server.

I tried removing the second script task from the FOREACHLOOP container, and putting it in it's own FOREACHLOOP container, but it still gives the same error.

This is the error I'm receiving:

Error 30009: Reference required to assembly 'System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' containing the implemented interface 'System.Xml.Serialization.IXmlSerializable'. Add one to your project.
Line 7 Column 22 through 30

Private objDT As DataTable

View 5 Replies View Related

No Help From The Error Messages

Dec 4, 2007

I am writing a tracking system. There is a table in the Sql Server 2000 database that contains a column for the user's ntid, the page they visited, the date of the last visit, a column each to track hits for the current year and a previous year column (basically for archiveing and reporting purposes), and 12 columns for hits per month (obviously, one per column). To record a hit, my unit determined we would only track one hit per day, so basically, there are 3 possible outcomes I needed to account for :
1) A user had never hit the page before, so I need to record the user's ID, the page they hit for the first time (since it won't exist yet), increment the year counter for that user on that page, and then determine what month column counter should be incremented as well.
2) A user had hit the page before, but not on this same day, so I need to update the row for that user on that page, changing the last visit field to reflect the current date, and icnrementing the appropriate counters.
3) A user had hit the page already on the same day, so basically, nothing should be changed whatsoever. No action should be taken.
I wrote a stored procedure to attempt to accomplish that logic, and though it's probably not very pretty, I was surprised at how few errors I got on my first Syntax check. Here's the stored procedure :
CREATE PROCEDURE sp_hitMe@ntid varchar(10),@page varchar(50),@thisHit datetimeASSET NOCOUNT ON
DECLARE @tempDate datetimeDECLARE @yearCount intDECLARE @monthCount intDECLARE @inMonth varchar(20)DECLARE @monthColumn varchar(10)SET @inMonth = DATENAME(mm, @thisHit)SET @monthColumn =  CASE   WHEN @inMonth = 'January' THEN 'hitsInJan'  WHEN @inMonth = 'February' THEN 'hitsInFeb'  WHEN @inMonth = 'March' THEN 'hitsInMar'  WHEN @inMonth = 'April' THEN 'hitsInApr'  WHEN @inMonth = 'May' THEN 'hitsInMay'  WHEN @inMonth = 'June' THEN 'hitsInJun'  WHEN @inMonth = 'July' THEN 'hitsInJul'  WHEN @inMonth = 'August' THEN 'hitsInAug'  WHEN @inMonth = 'September' THEN 'hitsInSep'  WHEN @inMonth = 'October' THEN 'hitsInOct'  WHEN @inMonth = 'November' THEN 'hitsInNov'  WHEN @inMonth = 'December' THEN 'hitsInDec'  END DECLARE @insString varchar(500)DECLARE @updString varchar(500)SET @insString = 'INSERT INTO tblTracking (ntid, page, lastVisit, hitsThisYear, ' + @monthColumn + ') VALUES (' + @ntid + ', ' + @page + ', ' + @thisHit + ', 1, 1)'
if exists(select * from tblTracking where ntid = @ntid and @page = page) begin  if exists(select * from tblTracking where lastVisit = @thisHit)   begin    -- DO NOTHING!   end  else   begin    DECLARE @theColumn varchar (100)    SET @theColumn = 'SELECT ' + @monthColumn + ' FROM tblTracking WHERE ntid = @ntid AND @page = page'    SET @yearCount = (SELECT hitsThisYear FROM tblTracking WHERE ntid = @ntid AND @page = page) + 1    SET @monthCount = (Exec @theColumn)    SET @monthCount = @monthCount + 1    SET @updString = 'UPDATE tblTracking SET lastVisit = ' + @thisHit + ', hitsThisYear = ' + @yearCount + ', ' + @monthColumn + ' = ' + @monthCount + ' WHERE ntid = @ntid AND @page = page'    Exec @updString   end endelse begin  Exec @insString endGO
And to my surprise, the only 3 errors I got were :
Server: Msg 156, Level 15, State 1, Procedure sp_hitMe, Line 39Incorrect syntax near the keyword 'end'.Server: Msg 156, Level 15, State 1, Procedure sp_hitMe, Line 45Incorrect syntax near the keyword 'Exec'.Server: Msg 156, Level 15, State 1, Procedure sp_hitMe, Line 50Incorrect syntax near the keyword 'end'.
However, these are of course so vague as to be useless to me. What's wrong with the procedure? What have I missed?

View 9 Replies View Related

SQL Error Messages

Mar 9, 1999

Is there a way to return the SQL Native error to a Visual Basic program?

View 3 Replies View Related

Error Messages

Mar 3, 1999

Hey everyone,

Here is what I'm doing:

exec xp_sendmail @recipients = 'ampx@hotmail.com',
@query = 'select * from information where recid <= 10',
@subject = 'Query test',
@message = 'hello',
@attach_results = 'TRUE',
@width = 250

I get this error:

Msg 2812, Level 16, State 4
Stored procedure 'xp_sendmail' not found.

Anyone know why? isn't xp_sendmail a function of SQL?

Thanks

View 1 Replies View Related

*** DTS Error Messages ***

Jul 20, 2005

Hello,I'd like to know if I use DTS. If I use it immediately, I can see the errorin the dialog box, instead, if I use it with scheduling, where Can I checkthe error ?ThanksSaimon(Florence)

View 2 Replies View Related

Looking Up Error Messages

Mar 10, 2008



Greetings
I'm learning SSIS and BIDS. I have extreme difficulty making sense of the error messages that come out.

First of all, what do the numbers mean? Each column, error, etc. is assigned a number that obviously means something yet I cannot relate them to anything. For example: The output column Name (713) on output Test (15) and Component (15) -- My table doesn't have 713 columns in it...

Then there are the error codes that obviously contain something useful. For example:

DTS Error: Microsoft.SqlServer.Dts.Runtime.TaskHost/QueueFuzzyName [33]SIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (46)" failed because error code 0xC020907D occurred, and the error row disposition on "input "OLE DB Destination Input" (46)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.


Where would I look up: DTS_E_INDUCEDTRANSFORMFAILUREONERROR and 0xC020907D? I understand that it tried to convert a value in something numbered 46 (no idea what that is) and the conversion failed. But that's it. How do I transmogrify 46 to something I can look at. I'm a little fuzzy on what a Destination Input is. Isn't an output a destination?

Or this one:

Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors"
Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.

I have absolutely no idea what this means except that many things happened, one of them failed, I have an error of some sort and it's error code is 0x80040E21. It must be important, it's in there twice, but what does it mean?

I'm thinking that in the help somewhere all these error messages are listed and I can look them up, but I can't seem to find it anywhere. Am I supposed to be converting them to decimal first?

Any advice from you experts would be much appreciated.

View 5 Replies View Related

Weird One. An Internal Error Occurred On The Report Server. (System Date?)

Mar 27, 2006

Hi guys,

We've had Reporting Services running in a production environ. for 6 months fine, but from Saturday every report now causes the following error (in both the Report Manager and Soap calls):

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Specified argument was out of the range of valid values. Parameter name: date

Now, before you jump to conclusions - this error is occurring on reports with both parameters and no parameters (ie in reports that have no "date" parameter in the report).

The next bit of info is the weird bit...

It was working on Friday (25/March/2006) - so as a test, i switched the servers clock back to Friday - and BINGO... it worked. Then I changed it to Saturday (26th March) and it doesnt work. In fact for the next 7 days - the service will not work until April 2nd 2006 - (when I changed the systems date to the 2nd it worked again.) Moving forward, it looks like its working fine.

Does anyone have any suggestions? This is in a production environment, so obviously changing the sytsem date as a quick fix workaround wont suffice.

Thanks in advance.

Grey



View 1 Replies View Related

SqlBulkCopy Error Messages

Sep 6, 2006

I'm using SqlBulkCopy.  Does anyone know how I can output what row (its column names) are throwing a duplicate primary key message when I bulkCopy.WriteToServer(datatable1)?Thanks 

View 1 Replies View Related

Dynamic SQL Error Messages!

Mar 3, 2008

Have this dynamic sql statement that I'm working on.  It works fine outside the execute (running the query by iteself) and prints fine but when I execute it, I get errors.  Spacing is good.  Here is the SQL statement.
 set @sql = 'insert into #participantInfo (strfirstname,strlastname,strindividualfk,strusername,dtelastlogin,blninactive,fk_intrightid,imgPhoto, stre_mail,strmiddleinitial,straddress1,straddress2,strcity,fk_intlocationid,strpostalcode,strhomephone,strbusinessphone,strmiscinfo1, strmiscinfo2,strsecretquestion,dteDateOfBirth,intgender,strsecretanswer)  select p.strfirstname,p.strlastname,p.strindividualfk,l.strusername,l.dtelastlogin,p.blninactive,r.fk_intrightid,p.imgPhoto, p.stre_mail,p.strmiddleinitial,p.straddress1,p.straddress2,p.strcity,p.fk_intlocationid,p.strpostalcode,p.strhomephone,p.strbusinessphone, p.strmiscinfo1,p.strmiscinfo2,l.strsecretquestion,p.dteDateOfBirth,p.intgender,l.strsecretanswer  from tblparticipants p inner join  tblparticipantrights r on p.strindividualfk = r.strindividualfk inner join  tblparticipantlogin l on p.strindividualfk = l.strindividualfk  where p.fk_strsubgroupid = ''' +  @strsubgroupid + ''''
exec (@sql)
Error messages are:
Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'tblparticipants'.Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'tblparticipantrights'.Server: Msg 208, Level 16, State 1, Line 1Invalid object name 'tblparticipantlogin'. 
Anyone see what may be the cause?
 thanks ^_^

View 6 Replies View Related

Error Messages To A File?

Aug 23, 2001

How to write the error messages generated in a job to a file?Thanks.

View 1 Replies View Related

How To Get More Info For Error Messages

Jul 10, 2000

So far I have not been able to figure out how to get more info
regarding the sql server errors. For example, I get this error
from sql server query analyzer (this just an example):

-----------
Server: Msg 128, Level 15, State 1, Line 5
The name 'does' is not permitted in this context.
Only constants, expressions, or variables allowed here.
Column names are not permitted.
-----------


Is there a way to find more information regarding this error, or
like Oracle has MeataLink, where you can search, if someone else
already got this error and how it got resolved?

Or how you folks go about resolving errors you get? Is it based
on trail and error, or experience (like already encountered this
type before) etc.?

View 1 Replies View Related

Dbcc Error Messages

Sep 23, 1999

If you find error messages in the dbcc results, how do you find out which table it is according to the ID number 875696?

ie:

Checking 875696
The number of data pages in this table is .....

View 3 Replies View Related

SQL Server Error Messages

Jul 30, 2007

Hi All,

I was wondering if anybody knows where to get a complete list of SQL Server error messages. I am writing a stored procedure that scans SQL Server Logs for errors and if there are errors in the logs, I get paged.

Thanks.

View 2 Replies View Related

Logging Error Messages

May 7, 2002

Hi,

How can I avoid certain messages from SQL Server being recorded into the Event viewer ?
For example, every time I truncate the transaction log with 'Backup log with truncate_only', It is being recorded into the Event viewer as an Error. But, I know that it is not an error.
How can I avoid this ?

Thanks

View 1 Replies View Related

PLEASE HELP!!! Multiple Error Messages

Jan 3, 2008

I have a SS2K5 stored procedure that executes 2 others stored procedures
sp_zero1 and sp_zero2
sp_zero1 and sp_zero2 do the same thing ... raises an Divide by zero error
I need to (print / select into a database) both error messages using just one
try catch block instead of 2 blocks like in the next example:


-- THIS IS THE WORKING CODE THAT I DONT WANT
BEGIN TRY
exec sp_zero1
END TRY
BEGIN CATCH
PRINT ERROR_MESSAGE()
PRINT ERROR_PROCEDURE()
END CATCH
BEGIN TRY
exec sp_zero2
END TRY
BEGIN CATCH
print ERROR_MESSAGE()
print ERROR_PROCEDURE()
END CATCH



if I try the next code

--THIS IS THE NON WORKING CODE
BEGIN TRY
exec sp_zero1
exec sp_zero2
END TRY
BEGIN CATCH
print ERROR_MESSAGE()
print ERROR_PROCEDURE()
END CATCH

only the first error message is printed and the execution is stopped

This is a generic example ... in reality I have a stored procedure that executes tens and hundreds of other stored procedures ... so thats the reason I need just one block of try catch instead of hundreds of blocks

thank you

View 6 Replies View Related

Reading The Error Messages

May 22, 2006

when a statement fails and it tell me for example

Server: Msg 137, Level 15, State 2, Procedure spinsertnew, Line 266
Must declare the variable '@'.

How can I find which line it is using query manager?

View 13 Replies View Related

Custom Error Messages

Jul 20, 2005

My understanding is that in a stored procedure (or any code for thatmatter) if an error occurs you can detect it by checking @@errorvariable and raise your own error with raiserror statement.The problem is that the original error is not suppressed. For exampleI received the following output from a stored procedure from the sameerror:Server: Msg 547, Level 16, State 1, Procedure spUpdateSecurityMaster,Line 49INSERT statement conflicted with COLUMN FOREIGN KEY constraint'FK_SM_mm_Exchange_Exchanges'. The conflict occurred in database'Trading', table 'Exchanges', column 'IsoCode'.Server: Msg 50000, Level 14, State 1, ProcedurespUpdateSecurityMaster, Line 57Unable to insert into "SM_mm_Exchange" tableThe statement has been terminated.So why should we bother to use raiseerror if the orginal error isgoing to be given to the client anyways? The end result is two errormessages.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved