Here's a different way to look at that problem... even if no likely use in real world

Build a table with whatever range of numbers you need.

Then

select top (@NbRowsNeeded) *...

Can yo uprovide more details about what you want to do and what you've done so far, maybe It'll jolt my mind into action.

Ray Mond (7/7/2010)

---

If your first STOPAT recovery was used with the STANDBY or NORECOVERY (which doesn't make much sense) options, you can restore subsequent transaction logs. You do need...

vinodvadla (7/7/2010)

---

Its not that way Lutz i am actually very new to SQL coding and i am not able to understand or get how exactly i can write the question...

as far as I know, you need to redo the full sequence with a different stopat parameter.

Unless maybe you need to restore a single [set] of table and not the...

Lowell (7/6/2010)

---

just hazarding a guess here, but could it be your SQL instance is 64 bit and the drivers are only 32 bit?

anthony.ventura (7/6/2010)

---

Hi, new to the forum, and have...

kchant (7/1/2010)

---

You could try running DBCC UPDATEUSAGE first and then using the system views to get an accurate row count, if you're using your original query with the WHERE clause...

UMG Developer (6/30/2010)

---

badatthis: Yes, that issue has been brought up more than once. And I think it goes further than that, even with a PK/clustered index you aren't guaranteed a...

Another simple exemple. I once remoted on a server and ALMOST hit the shutdown button rather than log off.

I caught myself in time but it's been known to happen....

A picture is worth a 1000 words, a screenshot of the page you have along with what you need to do would be usefull in helping you out.

As a "workaround". You can always use row_number() in your queries to get unique values, especially usefull if you need to have the identity reseed for groups

Ok, who here has NOT done that already?

nice one :w00t::-D

Here's another direction. Parsing and counting 9GB of data is always going to be more of an intensive tasks which you'll need to throw hardware at eventually.

But after counting...

Hehe, got me too. Never dreamed that '-' and '+' converts to 0. Tho it makes perfect sens when you think about it!

WayneS (6/28/2010)

---

Duncan Pryde (6/28/2010)

---

Changing the subject somewhat...

Although I knew that you can have negative seeds and increments for the IDENTITY property, I've never actually used them myself.

I'd therefore be interested...