Search results for query: *

getting the following error now 12:10:28.586 [Microsoft][ODBC SQL Server Driver][SQL Server]An explicit value for the identity column in table 'ITRRComments' can only be specified when a column list is used and IDENTITY_INSERT is ON.(23000,8101) Procedure(InsITRRComments)

This error now, what have i missed [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@CommentId'.(42000,137) Procedure(InsITRRComments) CREATE PROCEDURE dbo.InsITRRComments /** @CommentId int IDENTITY,**/ @DacType varchar(25), @DacTypeId...

This is my stored procedure and it gives the following error, I'm new to sql server stored procs so I'm sure its some basic error... Incorrect syntax near the keyword 'IDENTITY'.Procedure(InsITRRComments) CREATE PROCEDURE dbo.InsITRRComments @CommentId int IDENTITY, @DacType...

I have an application that reads data from a database, wraps the data in html table tags and then sent as an email to myself. My problem is as follows. I have set the email format to be html so when I open the email I should see the data in a nice table format. That does not happen however. The...

do i need to set up an smtp server on iis to send the emails, do u know how to do this

This is my email code, how do i adjust to html format MailMessage mail = new MailMessage(); mail.To = "xxxxxx";//txtTo.Text; mail.From = "xxxxxxx";//txtFrom.Text; mail.Subject = "test"; //txtSubject.Text; //mail.BodyFormat. //Set the BodyFormat =...

using System.Web.Mail; is at the top but i need to be able to find the dll to add it to the project,, can u elaborate on what u mean cheers

cheers, i found some code that uses the name space using System.Web.Mail; where can i find this dll if its not on my pc

1. I'm querying a database that brings back rows of data 2. I wrap the data in html so it has a table structure Q. What I want to do is send the table in the body of an email .... I'm gona google it but any suggestions before that would be great

The following query wont work because GO needs to be on a separate line, is there a way I can force a new line in there. I can use a stored proc because I am joining a few tables together.... I want to force sql server to treat SET ANSI_NULLS OFF GO SELECT.... on separate lines SET ANSI_NULLS...

i figured out the problem, i was testing the sql code using db artisan but the server was a sql server so the following was needed in front of the query SET ANSI_NULLS OFF GO http://www.awprofessional.com/articles/article.asp?p=25288&seqNum=8&rl=1

I have the following problem. I am trying to execute a rather complex sql statement. The first sql statement below returns the desired rows, the second one wont return anything. Both sql statements work perfectly when run from the database. I dont understand why the second sql says that nothing...

Try to run it again and its taking ages, now i'm really confused, its been hanging for about 15 minutes

this is so weird, after about 10-12 minutes the application has given back the result I wanted I think, surely it should be faster !!!

using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using Derivatives.ops.lib; using...

I am calling a method inside a for loop and the problem is that the method calls another method. There is nothing wrong with the method if its called as a one off, it works fine but inside the loop the page just hangs. The loop is going to iterate about 1300 times and the method called calls...

ignore that last point, i cant connect both ways but i cant login either way even though i can query the database through the sql server query analyser can anyone help.... have went through the steps above and been looking on google for the last day ....

Another thing to add, I can connect to the database by doing it visually through using the server explorer. If I do it that way how do I bring back data and add it to a database. Its strange that i can connect to the server this way but not any other.

I wonder is it related to the settings on my computer, I'm using Microsoft Development Environment 2003 Version 7.1.3088 and Microsft SQL Server Version 8.00.194

ya but i have tried all of this already.... thanks for your help anyway, i'm just going to go home and look at it with a fresh head in the morning