Viewing 15 posts - 7,966 through 7,980 (of 49,571 total)
Anyone feel up to some trigger fun?
http://www.sqlservercentral.com/Forums/Topic1609279-1292-1.aspx
September 1, 2014 at 7:35 am
crazy_new (9/1/2014)
The way it determines which one to remove is by the @RoleID on the @NameID. @NameID is the client and @RoleID is the Role.
But you're not using the inserted...
September 1, 2014 at 7:34 am
There's a lot wrong with that trigger. To start, the fact that it does not reference the inserted table, hence isn't working with the rows just inserted. Also looks like...
September 1, 2014 at 3:43 am
The EmptyFile option of shrinkfile is only relevant to data files. Specifying the option when shrinking log files has no effect whatsoever. You cannot move the active portion of the...
September 1, 2014 at 3:22 am
crazy_new (9/1/2014)
Hey guys, is it possible to delete from a table,then insert into that same table, and then delete from a second table, all in one INSERT trigger?
Yup. If it's...
September 1, 2014 at 2:59 am
Gary Varga (9/1/2014)
September 1, 2014 at 2:34 am
Vimal Lohani (9/1/2014)
But what if you have only backup file. even you can't read it on lower version through labels or headeronly.
Download SQL Evaluation edition of the version of the...
September 1, 2014 at 2:28 am
rot-717018 (8/29/2014)
I added manually a record to the table but it did not fire the trigger either ?!?
A manual insert (INSERT INTO) absolutely will fire triggers, no way that a...
August 29, 2014 at 6:33 am
Yeah, that's what I thought. It's a bulk load (high-speed inserts). The bulk loads (bcp in, BULK INSERT and that Insert bulk) don't fire triggers unless the application running it...
August 29, 2014 at 6:32 am
rot-717018 (8/29/2014)
@venonym: I'll try to check whether triggering is enabled for the database/table ...
There's no table or database setting which disables triggers, don't waste time looking for one.
@GilaMonster: the rows...
August 29, 2014 at 6:00 am
How are the rows added to CounterData?
August 29, 2014 at 4:31 am
It's updated as part of the transaction which modified the base tables.
You'll have 1.5 million if you query one microsecond after the commit for the insert into the base table.
August 28, 2014 at 11:42 am
jcb (8/28/2014)
Anyway can you explain how the insert can work and the update fail?
Maybe, if you explain what exactly you mean by 'fail'?
August 28, 2014 at 6:57 am
xsevensinzx (8/28/2014)
I am studying for my Microsoft SQL 2008 R2 Database Development certification though.
Don't. If you want to study now, get the 2012 ones. The 2008 exams are likely going...
August 28, 2014 at 6:28 am
Replication if you need real-time. Log shipping the DB will be be behind prod. The less often the log backups are restored, the more behind it can get. The more...
August 28, 2014 at 6:26 am
Viewing 15 posts - 7,966 through 7,980 (of 49,571 total)