The removal is tough, especially when there might be valid reasons to have some data about you. Allowing someone to remove any data is not something I'm sure I'd like....

There are a number of scripts on this site to help with that. Here's one

http://www.sqlservercentral.com/scripts/Log+Shipping/67173/

If you're giving away beers.....we could use a few here at the ranch. 😛

And hope you don't lose that data. Maybe that's an idea...

You probably don't want tables in master, and note in the example above, NULL does not need quotes. It's a reserved word.

You could build an SSIS package to suck out a few rows of data from each table, but as (the other) Steve mentioned, this doesn't mean you have consistent data....

It wasn't me, Howard, but glad it helped.

If you go to that article and click the "discuss" link, you can ask the author a question and I'm sure he will...

I think Roger has put things well. I'm not saying you don't have a PK. I'm saying identities work well in that role.

Does this help?

http://www.sqlservercentral.com/articles/PBM/68602/

It's not a question of the origin of the number, but the fact that it's arbitrary-generated, and as such isn't necessarily a PK. In the paper world, when someone generates...

Les Cardwell (3/1/2010)

---

Steve,

I'm shocked! :w00t: The only purist rationalization for a surrogate PK is when no 'natural key' exists. Otherwise, it's just a throwback to mainframe days when files...

There are a few places that do a Code Camp/.NET event with a SQL Saturday. No reason not to do them together if you can find the space.

Space is certainly...

In the environment where I had separate accounts, it was mainly for security from viruses. We didn't want some trojan or virus to have elevated rights, so the idea was...

I was listening, but had to stop when it went to overtime to replace a faucet. I was watching the tweets to keep up with what was happening. It was...

Good point....