are you running in mixed / nt / sql security mode ? (check in Enterprise manager / server / properties / security) If nt-security is enabled or mixed-mode , you...

dbo = dust between objects 😉

It is annoying that members of the db_owner group don't create dbo-objects by default. They are not adapted to always mention the object-schema, but if...

I guess problems with schema started when ms introduced a "everyone" schema : DBO.

Making a "transparant" option is a terrific way to mistify objects.

Backside of this implementation is (of course)...

my first impression :

"SELECT @sSQL = 'EXEC ' + @srvName + '.master.dbo.DatabaseSummaryInfo'" would mean you have defined all @srvName-servers as linked server on the server where you run the script.

I...

Use clustering indexes so a dbcc dbreindex also affects your datapages. check your fillfactor settings. run sp_statistics and updateusage to get correct numbers. check BOL.

nulls are indexed. create a unique index on a nullable column and then try to insert 2 rows with null for that column. In that case null = null.

I...

check Denormalisation on the web. There a whole set of info needed to take that decision

create a parameter-table with a column "lastkeyvalue". Read that value for update and than its all up to you. Others cannot reach it until you release it.

That is if you...

This is how I resync users.

-- login sync

-- print db_name()

use userdb -- User-db

go

print 'print @@servername + '' / '' + db_name()'

print 'go'

go

declare @username varchar(128)

declare @Musername varchar(128)

declare @IsNtName bit

declare @sql_stmt...

erata : "decoment" should be "document"

/ "relaton" should be "relation" 😉

assuming a unit has only one "parent"-unit, you could have an entity "company" an other entity "Units" with a relation to "company" and a third entity "UnitRelations" where you decoment...

In QueryAnalyzer you could you "show execution plan" or "display estimated execution plan".

SQL2000 ? Make the user DDL-admin in stead of DB_owner. Look at BOL.

Thanks to implicit conversions. Rule 4 never thrust a default-behaviour. And it strikes when you don't expect it.

try it with substring(text,1,case when len(text) > your_max_length then your_max_length else len(text) end.