YSLGuru (12/22/2009)

---

Jeffrey Williams-493691 (12/21/2009)

---

First, I don't believe SQL Server actually stores login attempts. You can find that information in the event log and/or SQL Server log.

Second, the only way...

I think you are out of luck. Anything we can provide you in the qay of guidance will help you going forward, but what has happened in the past...

No problem. The more you learn, the more effective you can be in solving your opportunities (other peoples problems).

Slight mod to the code for testing:

--create download code table

create table #DownloadCode

(

dlc uniqueidentifier not null,

dlcmembernumber numeric(13,0),

dlcdatereceived datetime, ...

Here is the original SQL Server 2005/2008 code I had envisioned earlier in the post:

--create download code table

create table #DownloadCode

(

dlc varchar(14) not...

Greg Snidow (12/22/2009)

---

Greg Snidow (12/22/2009)

---

Lynn, that's a neat little trick I...

Here is my SQL Server 2005/2008 code for the same problem:

--create download code table

create table #DownloadCode

(

dlc varchar(14) not null,

dlcmembernumber numeric(13,0),...

Greg Snidow (12/22/2009)

---

Lynn, that's a neat little trick I never thought...

Fridayish -- my apologies, but this is a Friday on a Tuesday today.

Since triggers are synchronous, not going to happen. Well, not true, what you may need to look at is using Service Broker to handle those functions that you need...

I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing that trend?

(Okay, two posts don't...

I used the row counts to limit the number of downloadcodes loaded to the temp file. Operating in a partial vacuum (more downloadocdes than members but no real numbers)...

Take it easy on the roads. I've heard that a storm is...

Yes. First, if you shrink it, it will just have to grow again. You should size your database (mdf file) such that it has sufficient space for 3...

Chris Morris-439714 (12/22/2009)

---

Lynn Pettis (12/22/2009)

---

Let's take another step back. Help us help you, read the first the article I have referenced below in my signature block. Follow the...