IMHO the output to a file is very weak in sql 2000. There is no ability to do alot of things natively, but the task can be completed by using...

You have to create a new unique file each time, then use activex script to append new file to old file.

If you transfer data using sql server DTS, then there is a batch size option, not sure of any other way.

Depends on what your doing.

if you move the publisher to a different server, then all your subscribers will be messed up. Not sure how to change publisher at subscriber.

So are you saying, if you supply a value for @Bol and no value for @Dest_bol, then you want 2BT & 1BT.

But if you supply a '' for @bol, and...

What are you using to do bulk insert?

what is the error message?

Please post any code or messages that you think may help

Sorry, you need a return statement after the commit.

BEGIN TRAN

UPDATE JOBS_Openings

SET [ID] = SUBSTRING(AARCount, CHARINDEX('(', AARCount) + 1, (CHARINDEX(')', AARCount) - CHARINDEX('(', AARCount)) - 10)

IF @@ERROR <> 0

 ...

its possible the transaction is open from your testing. on that connection. save the query close the connection and start a new one.

or

just execute rollback tran until it comes back...

I suspect its the first query in the union

SELECT *

FROM BL_TRUCK_BOL_DEST 

WHERE bol_no = ''

I thought you wanted

SELECT *

FROM BL_TRUCK_BOL_DEST 

WHERE bol_no = @bol_no

I usually have Enterprise manager generate a sql script.

Right click on job all tasks Generate sql script.

Use that script on new server, also serves as a backup in case...

any way you try to write this query it will cause ugly table scans on your query plan

try this instead

SELECT *

FROM BL_TRUCK_BOL_DEST 

WHERE bol_no = @bol_no

union

SELECT *

FROM BL_TRUCK_BOL_DEST 

WHERE...

Something like this.

Whether its the best way or not is up to debate

create table TBL_A(OrderID int, ExamID int)

insert into TBL_A(OrderID, ExamID)

Select 1,       234085

union

Select...

its per user, When you create a user without specifiying it gives it master

sp_addlogin [ @loginame = ] 'login'

    [ , [ @passwd = ] 'password' ]

    [ , [...

Have you tried?

select dbo.RAN_Posting_Duration(id_number, '01 aug 2005' '31 aug 2005') + dbo.CourseAttendance_duration(id_number, '01 aug 2005' '31 aug 2005')

or

declare @RetValue int

select @RetValue = (dbo.RAN_Posting_Duration(id_number, '01 aug 2005' '31 aug 2005')...

hmm, if there is no primary key  on table then how did that work?

If you continue to run that query over and over it will eventually update all rows.

if you...