Viewing 15 posts - 886 through 900 (of 7,631 total)
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 3:57 pm
CirquedeSQLeil (2/21/2010)
Yes - oft suggested. Difficult to implement. Not everybody would go looking for the "New Members" section.
True, but many would, especially if it were put at the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 3:53 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 3:48 pm
Roust_m (2/21/2010)
Where did you find the description for the EventData() function?
I didn't, I just opened the XML up and looked at it. Here is an example for CREATE INDEX:
<EVENT_INSTANCE>
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 3:44 pm
Agreed. Oft-suggested ...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 3:41 pm
joepacelli (2/21/2010)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 3:36 pm
dibenduc 96312 (2/21/2010)
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 3:25 pm
handkot (2/21/2010)
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 3:20 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 2:50 pm
I haven't checked it out specifically, but I believe that you would want a DDL trigger for CreateIndex in your database.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 2:08 pm
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).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 2:01 pm
GilaMonster (2/21/2010)
CirquedeSQLeil (2/21/2010)
Enjoy your break.No break (except from the forums). On-site with client this week.
Heh, in that case: "Enjoy your revenue!" 😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 1:57 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 1:52 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 1:50 pm
Yes, I am just waiting for confirmation.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2010 at 12:56 pm
Viewing 15 posts - 886 through 900 (of 7,631 total)