I don't think partitioning requires much other than thinking about how you're partition later (dates, numbers, etc).

Replication is more granular and you have to be sure to replicate every table...

Every user that connects can execute the applicaiton role. As AJ mentioned, the password is the only thing you need. Users aren't added to this role.

Use a subselect

select distinct (location)

from (select a, b, c from table) a

Also you shouldn't grant permissions to users. You should make roles, even if it's 20 roles, and add the users to the role. Then grant permissions to the roles.

Haven't tried it, but it should work.

You should run all queries that you expect to see if they work correctly. Execute all stored procedures, and grab queries or a load from Profiler on the existing server...

I bet it's the driver. This is through a linked server, correct? There are restrictions and I've seen issues with the drivers to DB2. You might try rebooting. We used...

I've seen queries similar, and people would write them. The fact that it compiles is a bad thing in my mind.

Someone submitted this and I think it's a good tickler...

Nothing.

It was a design that Brian Knight came up with, we liked it, and it's still here.

Great thoughts and information. Any of you want to write some articles with examples of what's worked or hasn't?

I was presenting a puzzle/conundrum/whatever here. It's a problem I've seen since my use of PGP in the early 90's and one problem that so many people have faced. I...

Good luck getting picked as well from this side of the water.

We've tried to budget for 200 people, though we've usually run in the 160-180 range the last couple years....

http://www.sqlservercentral.com/articles/DTS/datamigrationquicklyinsertingnewdata/1419/

Instead of inserts, use sqlcmd with a string to change the passwords. Keep all the server names in a single column.

The DBCC above should correct this and you should be sure that you run a DBCC CHECKDB after it to be sure there are no other issues.

Don't cross post.

Answer here: http://www.sqlservercentral.com/Forums/Topic499299-148-1.aspx