Viewing 15 posts - 6,856 through 6,870 (of 9,643 total)
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.
November 25, 2008 at 7:22 am
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.
November 25, 2008 at 7:21 am
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...
November 25, 2008 at 7:03 am
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.
November 25, 2008 at 6:45 am
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...
November 25, 2008 at 6:42 am
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...
November 25, 2008 at 6:39 am
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...
November 25, 2008 at 6:27 am
ALZDBA (11/25/2008)
rbarryyoung (11/24/2008)
Jonathan Kehayias (11/24/2008)
SQLBatman is a hero, I am just Jonathan Kehayias. I should really come up with a witty screenname or something for my online presence.
Hmmmm, how...
November 25, 2008 at 4:59 am
Yeah it seems you are on the right track. You should definitely remove permissions to your user objects from the public role.
November 25, 2008 at 4:56 am
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...
November 24, 2008 at 2:19 pm
Jonathan Kehayias (11/24/2008)
rbarryyoung (11/24/2008)
You mean Oracle, right? 😀
Oracle is not the dark side. I will be sitting for my OCA in January. We all do the same...
November 24, 2008 at 2:13 pm
rbarryyoung (11/24/2008)
Jack Corbett (11/24/2008)
Lynn Pettis (11/24/2008)
Jack Corbett (11/24/2008)
rbarryyoung (11/24/2008)
November 24, 2008 at 2:06 pm
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,...
November 24, 2008 at 2:02 pm
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 otherwise... :smooooth:
I...
November 24, 2008 at 12:44 pm
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 otherwise... :smooooth:
I would have thought that...
November 24, 2008 at 12:10 pm
Viewing 15 posts - 6,856 through 6,870 (of 9,643 total)