Viewing 15 posts - 1,291 through 1,305 (of 7,636 total)
Jeff Moden (12/4/2009)
...Nicely done, Barry. I hope people take the time to read these the right way.
Thanks, Jeff, much appreciated.
[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]
December 4, 2009 at 11:42 am
Julien.Chappel (12/3/2009)
...I would not trust the SQL Server Compact addition to be administered...
And frankly, this makes no sense at all, who said any thing about Compact Edition and what relevance...
[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]
December 4, 2009 at 12:00 am
Um, nothing in the title or the article implies that it takes 60-Seconds to become a DBA, and the the content of the article obviously argues the opposite. 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]
December 3, 2009 at 11:56 pm
JC-3113 (12/3/2009)
sorry to bug you again, but i came across another issue when running this on another server
seems there's a 256 limit somewhere
Msg 106, Level 15, State 1,...
[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]
December 3, 2009 at 11:39 pm
Can you supply us with a script or the data the can duplicate the problem? Just attach it to your reply as a TXT or ZIP file if it...
[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]
December 3, 2009 at 1:45 pm
Unquoted names (i.e., no "[..]") cannot have certain characters in them like spaces or "-". So I just added the brackets around the database names ("%D%" --> "[%D%]").
Thing is,...
[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]
December 3, 2009 at 1:42 pm
MTY-1082557 (12/3/2009)
<xml> <version alias="m4l_HSI_006$1" versionidentity="" packid="" versionid="" rowid="1"> <attribute key="t_weight" keyDesc="Weight" value="0" valDesc="" /><attribute key="t_rid" keyDesc=""...
[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]
December 3, 2009 at 1:34 pm
mschi6317 (12/3/2009)
As far as I know I am using dbmail or that's what I configured inside of the management studio. Can you give me a little more detail?
Show us...
[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]
December 3, 2009 at 1:32 pm
Hmmm, weird. It's obvious what's wrong, but I though that I had fixed it long ago. Well, this should fix it anyway:
ALTER Proc spLogin_OwnedObjects ( @login as SYSNAME...
[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]
December 3, 2009 at 1:29 pm
Why don't you just write this all the time?
if (@flag = 1) begin
raiserror('hello', 16, 1)
return
end
[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]
December 3, 2009 at 1:16 pm
MTY-1082557 (12/3/2009)
no one ??
Give us some sample data that demonstrates the problem.
[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]
December 3, 2009 at 1:11 pm
If you use DBMail instead of SQLMail, then sending mail from a trigger should not be an issue as DBMail is built on Service Broker and is therefor asynchronous.
Scanninng tables...
[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]
December 3, 2009 at 1:06 pm
Faye Fouladi (12/3/2009)
the secret was to use the Group By All clause, then one would see the zeros for the Count if there are no records that...
[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]
December 3, 2009 at 1:02 pm
roundel1900 (12/3/2009)
I do not see the database user that I created under the Security | Logins directory. I just see 'sa' and my AD account.
Database users aren't under Server Logins,...
[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]
December 3, 2009 at 12:55 pm
What does "but still remains active to the column i was trying to edit." mean?
Also, could you edit your post and use the [ code ] tags please? thnx
[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]
December 3, 2009 at 12:17 pm
Viewing 15 posts - 1,291 through 1,305 (of 7,636 total)