Thankyou Greg Larsen for your help.

What about @@rowcount along with the batch size

I am sorry i did answer to a wrong query.

What kind of Problem are you getting when you schedule it as a job??

just try this

Net stop mssqlserver /y

In you batch...

Sorry,Ignore my posting,You can stop the services but cannot start using xp_cmdshell

The second Script is not rounding the value in the variable.

DECLARE @amt money

set @amt = 30088.3200 * 0.0055 / 365 * 31

set @amt = ROUND(@amt, 2)

print cast(@amt as varchar(38))

DECLARE @amt...

You can try using xp_cmdshell.

shendricks,put this into a cursor,if you want to do the bulk insert/update and want to fire the trigger.

I have a suggestion,Create similar kind of tables (intermediate) import the data into these tables,once the import is completed drop the old tables and rename the intermediate tables.

Have you tried using the Batchsize option.I think if you use this option with a specific size(1000) you can findout how many batches are processed and calculate the number of...

Have you checked the execution plan for this query.

I think it will see those records as updates, since the replication triggers fire when the data gets over written from the temp table to the replicated table even though...

Configuring tempdb to sit in RAM was in SQL 6.5 but not in versions after SQL 6.5

I think in SQL 7.0 it is under logins instead of security audit as in SQL 2000

Try running the SQL Profiler and select Security audit,it gives the info. about all the users who are trying to log in.

Using the design veiw of the table in the EM one can insert a column in between two columns by right clicking and selecting Insert column.

I think during this process...