If you run the optimizations more often the should less load to have to ship across.

This should log all activity while profiler is running. Make sure you are starting the profiler trace and then running the actions in your application.

On the sql server in program files > sql server there is a program called profiler. This will show all incoming commands.

select @sql='''SELECT * FROM M_Driemnd('+convert(varchar(255),@p_number)+')'''

Does your backup window start at 9pm by any chance?

Are you using native SQL backups or a third party tool like litespeed?

Create a DTS package which just transfers the data directly from table to table.

I would say put a trigger on the table to check if there are any appointments within 15 mins of the proposed new appointment.

Could you explain a bit more about the data. Ie what data is available and what result you want?

try putting you query into a sql nvarchar variable and using exec sp_executesql @cmd

Sorry missed the last couple of posts.

Try this

DECLARE @CMD NVARCHAR(500)

DECLARE STREXEC CURSOR FOR

select

'alter database [' + sd.name + '] modify file (name=N''' + sm.name+''', filegrowth = 100MB)'

from sys.master_files sm

join sys.databases sd on sd.database_id=sm.database_id

where is_percent_growth=1...

How about a backup then restore?

Arun,

Has this helped?

The syntax for sp_add_job has a parameter called @delete_level. If you use this you can set the job to delete itself on completion (wether it is successful or not).

You will...

Drop the ID field and create it again.