And it shouldn't be hard, just make a new Forum Group called Read Me First, with one forum called New User's FAQ that only moderators can write to. Then...

True, but many would, especially if it were put at the...

FYI: The BOL article for EVENTDATA has an cute little script for logging all DDL events in a database. Because I wanted to capture and store the whole...

I didn't, I just opened the XML up and looked at it. Here is an example for CREATE INDEX:

<EVENT_INSTANCE>

...

Agreed. Oft-suggested ...

joepacelli (2/21/2010)

---

We are migrating data from an Informix database and in it there is RTF text. We are using SSIS to move the data to SQL Server staging database. Then...

dibenduc 96312 (2/21/2010)

---

Hi All,

I have a stored procedure in SQL Server 2000 which is used for sending emails to the user using the system stored procedure (cdo_send_sysmail).The body of the...

handkot (2/21/2010)

---

it's my solution

first step - we try to update record

secod step - if no record have been updated then we insert record

update Table

set field1 = @field

where field2 = @key

if...

OK, now I have checked it out specifically. Here is the example that I came up with:

CREATE TRIGGER CreateIndex_Prevent

ON DATABASE

FOR CREATE_INDEX

AS

-- Get...

I haven't checked it out specifically, but I believe that you would want a DDL trigger for CreateIndex in your database.

Here's a recent blog by Paul Randal which might help you in your situation:http://feedproxy.google.com/~r/PaulSRandal/~3/FAP0XwEkE4Y/post.aspx. (check the next one in that series also).

Heh, in that case: "Enjoy your revenue!" 😀

Note that although the external Activator is only officially released for SQL Server 2008 or later, Microsoft does state (and I can confirm) that it does work for and can...

Yes, I would recommend doing this via SQL Server Service Broker External Activation (see here:http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/36a58004-dbef-46ad-85a2-93563f3f8f0e).

Although it lacks the utility of SQL CLR (it cannot be called from a UDF or...

Yes, I am just waiting for confirmation.