- So let's guess you are using repeatable read (lock as long as possible so you can redo everiting like from the beginning)

-...

- So let's guess you are using repeatable read (lock as long as possible so you can redo everiting like from the beginning)

- with sql2000 I do this by defining an alert that is coupled to a job and have the user just perform the raiserror

- PROCEDURE sp_start_job

  @job_name    sysname          = NULL,

 ...

to view binary content you must use another application to read the LOB and to transfert to a component that can handle it.

this binary column can be up to 2Gb...

this may be an OLEDB error :

did you check http://discuss.develop.com/archives/wa.exe?A2=ind0012&L=oledb_dev&T=0&P=165

1) oracle uses versioning, whilst sqlserver uses locking.

    Only when updated/deleted, a lock will be placed in Oracle.

2) what kind of isolation level are you using. In many cases read...

check out http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

check out http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

this may solve your problem.

http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

select datediff(dd,'2006-01-01', getdate()) gives you the number of days.

If you want weekdays(mo-fr) you would have to make your own function like this one :

CREATE FUNCTION dbo.udf_convert_date2WeekRange (@RefDate datetime, @FirstLast char(1)...

- was the database detached in a propre way ? (detatchdb ...)

- you may be better off with backup/restore

add startup parameters -T1204 and T3605 to your sqlserver's parameters.

or execute dbcc traceon(1204, 3605, -1)

This way you get deadlockinfo in your sql server logs.

If you fetch/arrange me a ticket too, I'll even wear that tricky colored T-shirt from last year at Dallas

Can you pass me some...

maybe you could try to start sqlserver with minimal configuration using startup parameters from the commandline.

sqlservr.exe -f

check out "sqlservr Application" in books online.

is it running behind a firrewall or in another domain than the client ?