See, if this provides additional help:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

What, there are other PK's possible which have not defined the IDENTITY property on it???

Amazing!

Correction to myself:

Scott, you already did mention that FOREIGN KEY thingy

A truncate command is not logged, so it is very fast. But it deletes the entire table

Slightly incorrect.

TRUNCATE TABLE does not remove...

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;180500

Hm, why not make it a little bit more generic and use something like

CREATE PROCEDURE sp_StoreCt

@CurFYPeriod DateTime

AS

...

That way you can avoid to have a stored procedure for...

I must confess, that I have my problem with the language. If I hadn't had the German synchronisation in the back, I would have been lost at times. I guess...

BOL is SQL Server's very good online help. You should find it in your Microsoft SQL Server program group. Otherwise you can download it for free from the MS website....

OKay, in that scenario where a clustered PK is already present, you might want to have a look at CREATE INDEX in BOL. SQL Server allows to have more than...

Glad to hear that. I guess next step will be to analyze what happen exactly and make sure it will not happen again.

Glad I could help. And best of all is, that you should be able to find good algorithms for free on the web

Let me guess, your developers were also first-time VB programmers with a mainframe background?

Ever thought of encrypting that sensitive data? That won't stop someone with sa privileges from watching the data, but he will not understand what he sees.

To receive a good answer, you should provide more information about what you actually do, how you do it and why you are worried about what you do. At least...

Dang, while being in Portugal I was able to watch "The life of Brian" in english. I watched it 4x during that weekend. I love it, though I must admit...