You can use a delete trigger, output the deleted into a table. Easy to use any of the security functions (CURRENT_USER, ORIGINAL_LOGIN(), SESSION_USER, USER, USER_NAME(), SYSTEM_USER) as a column default...

You are missing the increment of the counter, the code never hits it, improved code below

😎

--Set Variables for randomizing Information, et al

DECLARE @localChestTier int, @ItemLimit int, @counter int,@ItemCounter int

SET @counter...

SSIS + Script Task

or

Load to a table (SSIS/bcp/openrowset) and. search in SQL

or

Powershell...

or

External application

or

batch file + sqlcmd

or

....

😎

Quick question, is the recovery model the same and is there any difference in the connections, ie. isolation?

😎

This is a modification to Chris's code, just set the values for start id and record number and off it...

Start by checking out this article Context Is Everything - Check Your Settings[/url]

😎

Would it be an option to use raw files[/url] for the lookup?

😎

Sorry for that, will be back with you in a short while.

😎

Jeff Moden (5/6/2014)

---

rhythmk (5/6/2014)

---

Jeff Moden (5/5/2014)

---

Even though I strongly [font="Arial Black"]disagree [/font]that BIT is an integer datatype simply because it can't be used in certain bits of math, such as...

How about select top(x) from y where z > v order by z?

😛

bedmett 9 (5/6/2014)

---

I'm sure Andy misapplied the triangle analogy.

The triangle analogy could have been applied to how long it took to get to 2014 and the kind of computers available...

Be careful here, all dynamic sql strings must be defined as N' string ', if missing the "N" in front, it will cause an implicit cast from (v)char to n(v)char,...

sbaer (5/6/2014)

---

If possible, establish a single data collection point. From there it is easy to distribute the client's data to the appropriate destinations. In the central repository, maintain all the...

sbaer (5/6/2014)

---

I am fairly new to database design and haven't been able to find a lot on this question.

I work for a marketing and advertising firm. We don't have...

In this case I would consider using a temporary table

😎