I believe that once you have done the Full restore using the WITH MOVE option you do not need to use WITH MOVE for Differential and log restores.

Just to note in SQL Server 2005 and later you get better information by querying sys.traces instead of fn_tracegetinfo and is actually the recommended method.

I'd read the file name into a variable and use the variable in a precedent constraint to send it to one of 2 data flow tasks, 1 that handles the...

I don't recall the error message I was getting, but I had a problem where McAfee was blocking SMTP from SSIS as potentially spam.

SCOPE_IDENTITY should work, but Grant is right in suggesting the output clause. I wonder why you are setting @customerid and then setting @NEWID to @customerid instead of just using...

Also the default trace is used as the source for many of the reports available in SSMS. So if you disable it you will lose those reports as well.

There...

This has always been one of my pet peeves especially when it comes to government and grant funded agencies. Then the last month of the fiscal year they all...

ALZDBA (11/25/2008)

---

rbarryyoung (11/24/2008)

---

Jonathan Kehayias (11/24/2008)

---

Hmmmm, how...

Yeah it seems you are on the right track. You should definitely remove permissions to your user objects from the public role.

I always hated those. The hard part in my opinion is the measurable. I mean is it lines of code written, sp's created?

If you are starting...

Jonathan Kehayias (11/24/2008)

---

Oracle is not the dark side. I will be sitting for my OCA in January. We all do the same...

rbarryyoung (11/24/2008)

---

Jack Corbett (11/24/2008)

---

Lynn Pettis (11/24/2008)

---

Jack Corbett (11/24/2008)

---

rbarryyoung (11/24/2008)

---

And for the record, I like to sit up front because at my age, I cannot see the code slides well enough...

Using views or stored procedures to control access to a data is certainly a valid, and I would argue a necessary step for security.

The Explicit Deny is probably overkill because,...

Lynn Pettis (11/24/2008)

---

Jack Corbett (11/24/2008)

---

I...

I would have thought that...