Recent content by dbtech

Is the SQL Mail started? you can check this under support services when u expand the server list using MMC. To send emails with SQL Server check the links below. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q263556 http://www.mssqlserver.com/articles/sqlmail_p1.asp Nice...

Try this --Declare @Start and @end select @start=start,@end=end from month did this work? dbtech

I'm not clear abt your question! do u want to populate a table with all the months starting from 1 to 12? if so this is one way to do it. Create Table #TEMP (month1 tinyint) Declare @i int set nocount on SET @i=1 while @i<=12 begin insert into #temp (month1) values(@i) set @i=@i+1 end set...

Can you post the code? do you still want to insert values into the fields, knowing that the value inserted exceeds the field length? if you are using VB, then it has be set at the Connection level example cn.excute(&quot;SET ANSI_WARNINGS OFF&quot;) Example create table #temp(Yourname...

Check BOL for @@ROWCOUNT The changes you need to make wil be IF @@ROWCOUNT=0 BEGIN If (left(@dateTo,11) = left(@currentDate,11)) /* If2: dateTo is the currentDate */ BEGIN Insert into #myTempTable SELECT statment from linked server database END END @@ROWCOUNT Returns the number of rows...

U can make use of CASE Statements. Please post your full query. Anway this is how its done SELECT Amount FROM tablename WHERE Amount=(CASE WHEN Amount ='' THEN 0 END) dbtech

U can use CHECK constraints in SQL Server to limit the values entered into a column, note that when the violation of constraint occurs SQL Server will issue a warning message The message will not be in user-friendly format, Which u will need to trap in your access front end and display a proper...

Are you calling the SP from Visual Basic code? if yes then you can try to set the CommandTimeout property of connection/command object to 0, CommandTimeout=0 if you are running from Query Analyser Go to Query Analyzer-> Menu Tools-> Options, Tab &quot;Connections&quot;-->specify timeout value...

'remote conn timeout': Will not kill inactive process. Use SQL Profile to monitor the open/close connections. check this link, U need to register to access the script...

Try this SET NOCOUNT ON, Put this line before you process the sql statement. Ex SET NOCOUNTON SELECT * FROM tablename dbtech

Try this http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20460 scroll down below and you can download the code for the article above. Issues related to crystal reports for displaying iamges from database http://support.crystaldecisions.com/library/kbase/articles/c2007340.asp Did this work...

you are right. thanks for correcting my post. dbtech

do you mean Duplicate rows in a Table?

To change the lock you need to use locking hints, search BOL for locking hints and SET TRANSACTION ISOLATION LEVEL Example to force No locks while reading data from authors table in Pubs database SELECT au_lname FROM authors WITH (NOLOCK) dbtech

This should help http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274463