I know it might sound tedious, but can you redesign the whole process?

Create a more comlpex stored procedure. It might allow you:

to incorporate temp tables, and

to remove the need for...

Hi Carol,

I wonder if you solved the problem?

I wonder if you save ( i don't have sql 2k around) 2K datafile in EM as 7.0 compatible ( as oppose to 8.0 for SQL 2000) will it work...

Thanks a lot guys,

CREATE TABLE #TEMP

(

 STUDENT   VARCHAR(30) NOT NULL

,CLASS1    CHAR(1) NULL

,CLASS2       CHAR(1) NULL

,CLASS3    CHAR(1) NULL

,CLASS4    CHAR(1) NULL

,CLASS5    CHAR(1) NULL

,CLASS6    CHAR(1) NULL

)

INSERT #TEMP VALUES ('Student1','A',NULL ,NULL ,NULL ,NULL,NULL )

INSERT #TEMP VALUES ('Student1',NULL,'B' ,NULL...

Thanks for reply,

All-includes all Clients and 999 is just another client and should be treated a bit differently LATER.

999 is just a Client Number and it could be thousands of...

may be that can help you:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=103703

Hi Perico,

Thanks!!!!

When I executed your code all together it worked!!!

Can you explain why, because when I was executing that part by part-it didn't.

Hi All,

Thanks for the replies.

Still Tran Log doesn't want to get truncated.

Any other ideas.

Just to get you started:

CREATE PROCEDURE usp_Add_New_Fund

(@Fund_Name varchar (30))

AS

if exists (select Fund_Name  from  Tbl_Fund where  Fund_Name=@Fund_Name)

RETURN 55556

ELSE

INSERT INTO Tbl_Fund

(Fund_Name)

VALUES(@Fund_Name)

RETURN @@ERROR

maybe using output parameters

or define an Error in your stored procedure and than catch that error on the client side.

I am not sure what you mean as training notes, but I took SQL classes few years in NY, at New Horizons (http://www.newhorizons.com). As far as I remember, they offer...

Or would it be possible to add an extra button-"Save as Text" (without printing option) - if remove Print Dialog is not the case here.

Thanks

When click on the print this topic, it opens a new page and a print dialog box shows. Would it be possible to remove the print dialog box and have...

I am using Alerts with Errors 18450, 18452, 18456 on SQL 2K/NT 4.0 Server.

On the same computer I am logging with SQL Authentication using non-existing SQL accounts.

Alerts are NOT fired!!!???

Yes,...