does this assume that an insert is taaking a page level (or higher) lock?

'Of course blocking could be reduced if you don't have a clustered index on an IDENTITY column....)'

Why?

for sheer amount and complexity of data it has to be cricket

alter schema transfer table to DBO

fixed it in the end.

Thanks,

'Jules'

Unfortunatly its a windows NT login that has got out of sync and this sp doesnt update them. the code below coems from that SP. Any Ideas?

-- VALIDATE PARAMS -- ...

Yep but cant update sys tables in sql9.

this wopnt work anymore

update

u

set sid = l.sid

from

...

Yep the user name and password are checked in dynamic  T-SQL this is because the DB they are in is passed in as a parameter.

But a structure like

CREATE PROCEDURE search_orders...

'A temp table is a DB object in tempdb, much different than a locally scoped variable'

If enough data goes into a table variable it will create an object in tempdb....

Getting the aggregates into table variables rather than using sub selects will probably improve things but cant see quite how to do it without knowing the format of the sql...

Yep Thanks. of course the hint is in the name 'Tabke VARIABLE'.

WQas reading the thread in responce to  the recent article on temp tables where the general concensus is...

Code below illustrates one other difference between temp tables and table variables. That that dynamic sql can see temp tables created by calling script but cant see table variables. Presumably...

cant delete user in current db as it is referenecd by a schema.

need to delete or change schema first which means i must remove the schema from all db objects....

figured it out anyway.

Well enough to know that its still not air tight. You create a project and then have to script all your objects out into seperate files...

Access the report server via the web and click on the report builder tab

the url should be somethign like //localhost/reportserver/

This is an odd behaviour but i think your problem is the ANSI_NULLS and ANSI_WARNINGS setting under which the trigger was created and not the setting as set within the...