Never mind  !

I found out that I had to merge the cells over the needed span.

just my 2ct

we always have a clustered index (even if on a identity or current-datetime column if no other suggested by the development team...

If I'm correct ...

if you want to be sure it is being run wit isolation level x, you can set the isolation level (at the beginning) in your sp...

U2U will provide you a good basic knowlage.

One first has to lean to crawl, walk and then start running.

Flexcom-azlan (azlan.be) also does a good job.

Compare prices and jump onto promotions....

also in that case you can use profiler to generate the script so you can capture all sql to a file.

Start profiler, create a trace and then save it as...

duplicate posts ......

Thanks for...

Can you do a repro ?

if yes, use Query Analyser to debug the proc  and set brakepoints to these positions so you can check the content of all varriables and...

just my 2ct :

- having NULLs for replacement - values ?

- or using case-expressions without an ELSE pitfall ?

like andrewkane17 specified, shrinkfile or shrinkdatabase will solve your problem.

You can also perform an alter database set AUTO_SHRINK on, but that is not...

did you also perform sp_updatestats, dbcc updateusage and dbcc freeproccache (so newly generate plans come in).

Maybe it's time to use profiler to capture load and analyze it to check if...

imo the only difference for the "dbo-login" is that (s)he does not have to qualify schema DBO when creating objects. Members of the db-owner db-group always have to specify the...

This is how I'd solve it : (be aware of collation conflicts !)

print 'Fillocations of DB'

print '------------------'

declare @SelStmt as varchar(7000)

declare @DbNaam as varchar(125)

declare...

yep, basic rule No 1 for programming is still : "learn copy/paste"

That should be no problem because the new domain will use the old sid from the users sid-history.

The only "issue" you'll have is...

... parameter-table and proc set to manage sequences ...

This way you could emulate identity

This is just a simple representation :

create table t_mySequenceParameters (

TableName...