I coded a few triggers. Here's my 2 bits. In the trigger you have access to the "inserted" and "deleted" tables. They will let you do set based queries using all the inserted, updated, or deleted records. For update triggers, having a key that is not updated (or an identity field that's not updated) will […]
2003-07-25
Like this: insert #t exec('dbcc inputbuffer(' + '@who_spid' + ')') ?
2003-07-24
1 reads
Hi Khalid, You can do the following to turn single user mode on/off USE master EXEC sp_dboption 'yourdb', 'single user', 'TRUE/FALSE' To why this is automatically happening I'm not sure, maybe you could post some of the log details. Laters *I didn't do anything it just got complicated*
2003-07-24
1 reads
quote: The point I'm trying to make is that QOD could become quite a useful method of seeing whether you are up to speed with your peers. If you have a score of 50% is that good or bad - you don't know so you compare it against your peers. If the peer results are […]
2003-07-24
anam: good catch. don't know why I didn't notice that. You may want to contribute this little headache to the FAQ...just a suggestion. It may keep someone else from the same mistake!
2003-07-24
1 reads
hi, the SQL 7.0 SP4 version is 7.00.1094 for MS03-031 Paul
2003-07-24
Using Access you could build a small app with unbound forms. Create an insert, update and delete procedure in SQL Server. SAMS Microsoft Access Developer's Guide to SQL Server has examples of how to do this. If it was just a question of updating a table with known data, the simplest way would be to […]
2003-07-24
In the trigger, pull out the Primary Key value from the trigger's 'Inserted' table. select (PrimaryKey field) from Inserted Or use the same statement to pull out the value of the column you are interested in. Note, if your table is likely to be updated in batches, there will be more than one row in […]
2003-07-24
2 reads
The SQL 2000 patch changes the version number to 8.00.818 Has anyone installed the SQL7 SP4 patch yet? If so can you let me know what the new version number for that is thanks
2003-07-24
At least this install is an automated package like the re-release on ms02-061. No more manually coping files.
2003-07-24
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers