Viewing 15 posts - 7,246 through 7,260 (of 9,643 total)
You need ALTER TRACE permissions at the server level. Just be aware that this IS a SERVER level permission so any user you grant this to can trace ANY...
October 14, 2008 at 2:35 pm
You could possibly use TOP 1 with an order by date desc.
Select Top 1
Column List
From
Table...
October 14, 2008 at 2:26 pm
In the Data Conversion Task go into "Configure Error Output" and set the desired error types to "Redirect Row". Then you will have a RED (failure) arrow in addition...
October 14, 2008 at 2:22 pm
Use the RTRIM function on the FIRSTNAME. LIke this
Select RTRIM(FirstName) + ' ' + LastName
October 14, 2008 at 2:14 pm
Answering your second question first, here are a couple of articles on point in time restores by people I respect:
http://www.sqlservercentral.com/articles/Backup+and+Recovery/restoringtoapointintime/1905/
http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/
Now for the backup scenario you list. I'd add at...
October 14, 2008 at 2:03 pm
I'll start by answering your last question first. You can do it all in one trigger if you want. The second part is a a little more complex...
October 14, 2008 at 1:42 pm
JJ, Timothy, and Barry,
Thanks for the kind words. I just hope the article can be helpful especially to beginners.
October 14, 2008 at 1:04 pm
There are pluses and minuses to both. I usually append to one file. I think it makes restores easier as you just need to change the file number...
October 14, 2008 at 11:10 am
Because you are creating a new file each time you do not need init/noinit. If you wanted to create one log backup file per day you would need somemore...
October 14, 2008 at 10:51 am
Yes.
October 14, 2008 at 10:21 am
Based on how I understand the Linked Server Security section in BOL, you cannot MAP to a different Domain Login. You would need to either grant Domain\Acct_A access to...
October 14, 2008 at 10:20 am
rbarryyoung (10/13/2008)
You're right that SQL Mail (xp_send_mail) is a No-No from a trigger, however Database Mail (db_send_mail) is safe from a trigger because it is built around SQL Service...
October 14, 2008 at 10:11 am
billross (10/14/2008)
Yeah, I am only concerned with a single row at the moment. I suppose I need a where clause.
You may only be concerned with a single row now, but...
October 14, 2008 at 10:05 am
Something like this will work:
[font="Courier New"]DECLARE @datetime VARCHAR(20)
DECLARE @filename VARCHAR(100)
-- get the date in ANSI yyyymmddhhmmss
SET @datetime = REPLACE(CONVERT(VARCHAR(10), GETDATE(), 102), '.', '') +
REPLACE(CONVERT(VARCHAR(10), GETDATE(), 108), ':', '')
SET...
October 14, 2008 at 9:59 am
Just a guess because I am not an Access expert by any means, but I think because you have upsized CurrentDB will no longer work. You will need...
October 14, 2008 at 9:44 am
Viewing 15 posts - 7,246 through 7,260 (of 9,643 total)