Viewing 15 posts - 1,996 through 2,010 (of 3,221 total)
Having been a VB6 programmer for lol too many years, let me tell you ..
take GSquared's offer.
April 5, 2010 at 3:16 pm
This is not a complete answer but it may get you started, it is the minimum to assist you, but it will list all FK and related tables. (This...
April 5, 2010 at 8:06 am
Tom.Thomson
But what's the point of gaming the system
Seems to me the ones who game the system are the ones that know the least ... and those who whine and...
April 4, 2010 at 5:25 pm
Paul White NZ
Your first QOD going up on Wednesday (7th April).
Hope Jeff reads it ...
April 4, 2010 at 5:17 pm
GarethPhilpott
So the crux of my post:
What SQL should I be running to make it spit out the procs?
Try this ... tested using SSMS -- with query output as text in...
April 4, 2010 at 8:20 am
Paul White NZ (4/2/2010)
Trey Staker (4/2/2010)
Answering the question a day late with the answer published in the news letter?Is it? Oh, well that might explain it too, then!
Thought the...
April 3, 2010 at 11:02 am
Paul White NZ
Yes I am well aware of what sp_foreach uses .... however I am also aware of a remark by Brian Knight on 2001/05/22 at:
http://www.sqlservercentral.com/articles/Advanced+Querying/sp_msforeachtable/181/
Hidden in the depths...
April 3, 2010 at 7:42 am
Another item you should research ... search here on SSC for
sp_foreachdb and sp_foreachtable -- understand them and you can eliminate your use of cursors.
April 2, 2010 at 2:14 pm
Just an example"
SELECT db_name() as ''Database Name'', CAST(@dbsize AS VARCHAR(50)) + '' MB'' AS ''Database Size'', CAST(@logsize AS VARCHAR(50)) + '' MB'' AS ''Log File Size''
'
If some one was to...
April 2, 2010 at 1:24 pm
Joseph D. Marsh
The question was a good one. I learned about a feature that I didn't know existed. But the question was poorly worded. Period
The question:
When I hold my mouse...
April 1, 2010 at 10:54 am
george sibbald
No apologies necessary ... no offense taken .... you ARE correct my posted code would NOT work in SQL 2005.
Thanks for pointing out that fact. ...
March 30, 2010 at 8:50 am
jim.taylor Posted Today @ 9:59 AM
Your key sequence interestingly enough takes you to:
http://www.microsoft.com/sqlserver/2008/en/us/
Thanks for the additional tip .. will prove to be useful.
March 30, 2010 at 8:20 am
Peter Trast
I have tested and retested my question and the results have been identical .... utilized Developer Editions of SQL 2005 and SQL 2008 as installed .... no modifications to...
March 29, 2010 at 1:52 pm
Post removed as it did not apply to SQL 2005
March 29, 2010 at 1:00 pm
Posted as an attachment is a modified view of a section of the web page, including WayneS first recommendation.
CirquedeSQLeil
I think one good way to circumvent that is to paste an...
March 22, 2010 at 1:50 pm
Viewing 15 posts - 1,996 through 2,010 (of 3,221 total)