Sorry, but why do you think that your db isn't normalized right now or would be 'more' normalized when split into 20 different dbs?

Have you read this http://www.sqlservercentral.com/columnists/bkelley/normalization.asp ?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

I totally agree. It's good to remember and even better to learn what RELATIONAL means.

Just a while ago we had some interesting discussions on pros and cons of XML.

I'm not...

I subscribed when I realized that I could benefit more from a magazin about SQL Server than from one about VBA programming.

But after one year of subscription...

Once you have identified your dups with some script you can write a batch to update these duplicates.

Something like this will show only duplicate entries and take no further...

That is also the way I use here.

The return from LOGON_USER I use to query my db and depending on the results I display several slightly different intranet homepages.

I...

Actually you don't see the column in the table, because there is not such a column. Look at the view definition and you'll see that it is a bitwise excerpt...

All in all it is not very smart to require an entry code that is published once a month on the by-pack paper ?!?. IMHO.

Maybe I would use their site...

Well, first I would search this site for a script to remove duplicates and then add the index.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Hm..just my $0.02 cents on directly updating system tables.

BOL states that you shouldn't do this, because on yre not supported.

Personally I think this technique is an easy, fast and reliable...

Hey, I guess SQL Server Mag support is also following this forum.

Suddenly I got a response.

Case closed.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

That is a rather philosophical question that doesn't have an ultimate answer. I'm inclined to say go with NULL, although NULL require some extra bytes of storage which SQL Server...

This might also be of interest to you

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

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Yes, that's right, but it is no explanation why subscription is working, not working, working....

Somethings rotten in the state of Denmark!

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Uff, when I first read use varbinary I was insecure as to what should be used.

Anyway, this is a link I post frequently

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

I'm doing this again now, because I...

IIRC, EM uses DBCC showfilestats to show db statistics on size.

Can you post this results?

I guess there is nothing to worry about.

Frank

http://www.insidesql.de

http://www.familienzirkus.de