Programming SQL

how to solve deadlock issue
Hi, In our application we are getting a deadlock error ?transaction (process id) was deadlocked on (lock) resources with another process and has been chosen as the deadlock victim? When we traced the queries in sql profiler we were able to find out two queries trying to access the same table. ... 23 Dec 2005 09:47

SET XACT_ABORT: what the f***k
I got this error, for the first time today: System.Data.SqlClient.SqlException: Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF. [OLE/DB provider returned message: Cannot start more transactions on this sessio... 22 Dec 2005 18:17

Procedure or function has too many arguments specified.
I've seen others have had trouble with this. Using vs2005 connecting to sql2000, procedure works from command object with parameters but doesn't from a datasource defined on the page. I've tried any number of variations to get it to work, uses a session parameter and three control parameters from a bound gridview. ... 22 Dec 2005 12:02

XP_smtp_sendmail
We have SQL2000 and Exchange server 2003 I have been trying to send out an email from the SQL server using the XP_smtp_sendmail stored procedure. If i address it to an email address within the company ie me @mycompany.co.uk it works fine, however if i try to send it outside of the comapnt ie myfriend(a)any... 21 Dec 2005 10:27

OpenQuery using parameters
I need a little help with using parameter values in the where clause with the OpenQuery statement. What would the syntax for the following be if 10 was a variable? And does the syntax change depending on the datasource? In my case I am querying an Oracle database. But I can't get it work on an Oracle or Access... 15 Dec 2005 23:08

Deploying a managed code trigger
I am working on a managed code trigger using visual studio 2005 and SQL 2005. When I try to deploy it I get the following error: Incorrect syntax near 'EXTERNAL'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_... 16 Dec 2005 12:06

LDAP query
I'm attempting to query an LDAP datasource via ADSI. I created a linked server and can run the following query successfully: SELECT * FROM OPENROWSET('ADSDSOObject','adsdatasource',' SELECT ADsPath FROM ''LDAP://ldap_server/ou=profiles,ou=CCN,o=cisco.com'' ') next, i add additional fields to the query: ... 13 Dec 2005 17:03

Operand type clash: datetime is incompatible with text
I am getting this error on my insert statement, do I need to do something for my datetime fields? Here is the statement INSERT INTO tblCalendar ( adjName, DispDueDate, ClaimNumber, Juris, HearingDate, HearingType, ClaimantName, Location, HearingTime, HearingPart, WCB#, Counsel, DateRecd) VALUES ( @... 13 Dec 2005 12:14

Dynamic Criteria for a Stored Procedure
Our database utilizes some custom functions and .dll's to perform IRR calcuations. The IRR calculation takes two steps. 1. The first step is to create a view which preps the cash flows and pulls out what you want to analyze. ("Ad Hoc Query") 2. The second step is to create a stored procedure that references the ... 11 Dec 2005 05:32

SQL Bug??
select 717306 * 3000 Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. What's the story with this? ... 10 Dec 2005 07:11