Viewing 15 posts - 1,171 through 1,185 (of 3,221 total)
syscomments is provided for backwards compatibility only.
That is true, but I have run it in SQL 2008 and yes it does work ...
June 15, 2011 at 10:54 am
adonetok (6/15/2011)
Thank you for help. I ran bitbucket-25253's code. It works like magic.
Glad I was able to assist, and I thank you for letting me know.
June 15, 2011 at 9:00 am
Here is a SP that I have utilized, you may want to try it. It searches more than just SPs.
CREATE PROCEDURE [dbo].[UDP_FindWordsInaSP]
@Watchword varchar(50)
AS
SELECT distinct
'type' = case...
June 15, 2011 at 8:13 am
Grant Fritchey (6/15/2011)
That's 10,000 posts, done.Wait, now it's 10,001.
Congratulations
Thanks for helping so many like myself, even though we do not acknowledge it at the time ... again thanks.
June 15, 2011 at 6:03 am
calvo (6/14/2011)
bitbucket-25253 (6/14/2011)
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspxGives 4GB as max database size
Think that's a MS typo? That page references SQL Server 2008 versions and breaks down the free editions into compact and express. Compact...
June 14, 2011 at 12:56 pm
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
Gives 4GB as max database size
June 14, 2011 at 12:18 pm
GSquared (6/14/2011)
But that almost gets me started on MS Word. I HATE the programmers who wrote that piece of junk and all of the ways it thinks it knows what...
June 14, 2011 at 10:02 am
kish1234
I have extracted a portion of your posting and present it below in a readily consumable format. However the table definition and supplied data appears to be...
June 14, 2011 at 9:27 am
I am sure that what you have posted is very clear to yourself. But for those who wish to help you, with a tested solution, please post the table...
June 13, 2011 at 11:01 pm
Many who would attempt to render assistance, most likely would not be familiar with a UB92 form, nor have you given them any idea of where that data for said...
June 13, 2011 at 7:34 am
To receive tested help please post table definition, including indexes, along with sample data and desired results. You can do this simply if you read the article whose link...
June 9, 2011 at 6:29 pm
Might I suggest a little reading to help you find the right path to follow.
http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/
and/or
http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx
Right here on SSC
June 9, 2011 at 4:28 pm
Simply put:
INSERT EXEC Statement cannot be nested
June 9, 2011 at 6:36 am
Viewing 15 posts - 1,171 through 1,185 (of 3,221 total)