Viewing 15 posts - 6,571 through 6,585 (of 7,419 total)
I support the idea of using CONTEXT_INFO for this.
But I'd suggest limiting the use of it to a single, predefined byte location. And also not destroying any unused in...
February 19, 2013 at 5:59 pm
The "instead of" trigger will fire first.
If the "instead of" trigger does actually insert a row(s), then the "after[for] trigger" will fire.
You may want to use the clearer "AFTER INSERT"...
February 19, 2013 at 5:21 pm
Jeff Moden (2/19/2013)
ScottPletcher (2/18/2013)
Jeff Moden (2/18/2013)
ScottPletcher (2/18/2013)
declare @enddate datetime
set @enddate = getdate()
SELECT STUFF(CONVERT(varchar(10), DATEADD(DAY, -21, @enddate), 1), 3, 4, '')
Except for Sean, we did forget to answer the original question....
February 19, 2013 at 10:16 am
Jason-299789 (2/19/2013)
I would disagree with you on the under no circumstances comment, for a couple of reasons
1) the risk of fragmentation is significant on the clustered index, especially if...
February 19, 2013 at 10:13 am
Bhuvnesh (2/18/2013)
ScottPletcher (2/18/2013)
Cluster the table by the most common WHERE conditions; make the clustered key unique by including the Policy_transactional_ID on...
February 19, 2013 at 10:11 am
David Moutray (2/18/2013)
ScottPletcher (2/18/2013)
In implicit transaction mode,...
February 18, 2013 at 5:24 pm
Ranzz (2/18/2013)
It cant be possible to set unlimited growth.So, that is the reason, I am looking for some thing that will help us.
It is possible in SQL Server.
Maybe...
February 18, 2013 at 4:56 pm
You don't want to issue your own BEGIN TRANSACTION in the trigger, since, as I noted before, you're already in a transaction.
That error message after the ROLLBACK is normal, to...
February 18, 2013 at 4:53 pm
Jeff Moden (2/18/2013)
ScottPletcher (2/18/2013)
declare @enddate datetime
set @enddate = getdate()
SELECT STUFF(CONVERT(varchar(10), DATEADD(DAY, -21, @enddate), 1), 3, 4, '')
Except for Sean, we did forget to answer the original question. :blush: Thanks,...
February 18, 2013 at 4:32 pm
Modest DBA (2/18/2013)
To curb this, i requested a data count, after every table re-load, and the difference between...
February 18, 2013 at 2:43 pm
Under no circumstances should you cluster this table on Policy_transactional_ID.
Cluster the table by the most common WHERE conditions; make the clustered key unique by including the Policy_transactional_ID on the end...
February 18, 2013 at 2:14 pm
declare @enddate datetime
set @enddate = getdate()
SELECT STUFF(CONVERT(varchar(10), DATEADD(DAY, -21, @enddate), 1), 3, 4, '')
February 18, 2013 at 2:07 pm
Instead of constantly trying to adjust the max size, I'd suggest setting the max to "UNLIMITED", then monitoring and alerting for every file growth occurence instead.
February 18, 2013 at 2:02 pm
David Moutray (2/18/2013)
More than anything, I want to understand why this is not working.
All triggers are implicitly part of a transaction, with at least the SQL statement that caused the...
February 18, 2013 at 1:59 pm
I've got scripts that will generate point-in-time recovery scripts. And generate and execute tail log backups.
I suspect you could get a script(s) from the web for that and modify...
February 15, 2013 at 10:11 am
Viewing 15 posts - 6,571 through 6,585 (of 7,419 total)