On Wed, Apr 21, 2010 at 3:29 PM, Rafael Copquin <[email protected]> wrote: ----------------------
Would you consider a SQL Server that has a table for this need. Only one column, the key you need. Below is code to create a table a SP to populate it and it will return the KEY # back to you. CREATE TABLE MyTable ( MyPK int NOT NULL IDENTITY(1,1) CONSTRAINT PK_MyTable PRIMARY KEY, MyData int NOT NULL ) GO CREATE PROC MyProc @MyData int AS SET NOCOUNT ON INSERT INTO MyTable (MyData) VALUES(1) SELECT SCOPE_IDENTITY() GO EXEC MyProc @MyData = 1 GO I don't think that you could grow the 4 gig FREE version in a year with transaction rates in the thousand per hour. You will have to truncate the log file but that is a maintenance process that is easy to implement. Just tossing out an idea for you. If your transaction rate if 10,000 per hour or more you will need to delete some of this data in your maintenance plan and that is real simple as well. Select top 5 * into #t1 from MyData order by MyPk desc. Declare @min int set @min = (select min(MyPk) from #t1) Delete from myData where myPk <= @min -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
