Viewing 15 posts - 14,026 through 14,040 (of 19,562 total)
I think the results on this should be expected. I think the query was written interestingly enough.
May 13, 2010 at 10:56 pm
Here is another alternative as well.
Select object_name(a2.object_id) as ModuleName,(SELECT definition AS [processing-instruction(definition)]
FROM sys.all_sql_modules a1
Where a1.object_id = a2.object_id
FOR XML PATH(''), TYPE
) as ModuleText
From sys.all_sql_modules a2
Where ObjectProperty(a2.object_id,'IsMsShipped') = 0
Order By ProcName
This will...
May 13, 2010 at 6:43 pm
Before copying it to SSMS, copy it to Notepad++ and look for the hidden characters.
Remove those characters and then copy the query from Notepad++ to SSMS.
May 13, 2010 at 4:09 pm
Trey Staker (5/13/2010)
Curriculum Vitae. -- in what to update if you don't have backups and your database is toast (To all us Americans that is a Resume)
or CV for...
May 13, 2010 at 4:08 pm
Spectator Event (as in Watching your Database become toast)
May 13, 2010 at 3:28 pm
Trey Staker (5/13/2010)
WayneS (5/13/2010)
CirquedeSQLeil (5/13/2010)
Gianluca Sartori (5/13/2010)
I think Celko does nothing to be pleasant, but Peter's reply is terrific.That is not uncommon. He carries his soapbox everywhere he goes.
That...
May 13, 2010 at 1:30 pm
Feeg (5/13/2010)
Try this http://www.sqlservercentral.com/articles/Log+growth/69476/ and let it run every 5 min.
This is what I would recommend. 😉
May 13, 2010 at 1:08 pm
The copy and paste that you used appears to have hidden characters. Try copy and paste to notepad++ or something like that and then paste to mgmt studio.
May 13, 2010 at 1:07 pm
GilaMonster (5/13/2010)
CirquedeSQLeil (5/13/2010)
Of course if you want something closer, Mauritius would be a great place to go!!
Return flights to Mauritius next week: R2000
Return flights to Mauritius last week June/1st week...
May 13, 2010 at 12:43 pm
GabyYYZ (5/13/2010)
GilaMonster (5/13/2010)
GabyYYZ (5/13/2010)
To all South Africans on the forum here, are you guys excited about next month or is everyone holding their breath?
I'm considering finding a hole and pulling...
May 13, 2010 at 12:14 pm
Nice informative article. Thanks for sharing.
May 13, 2010 at 11:57 am
Thanks Grant. This editorial was perfectly timed for me. Having recently encountered several of these where the OP had not tried anything yet because s/he did not understand...
May 13, 2010 at 11:52 am
I'll be there - if for nothing else than to mingle.:-D
May 13, 2010 at 11:45 am
steveb. (5/13/2010)
May 13, 2010 at 11:34 am
Viewing 15 posts - 14,026 through 14,040 (of 19,562 total)