| Author |
Topic |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
 Posted - 2003-01-30 : 19:56:33
|
| Hi orlwhen I query syscomments in one database all my tables have "NULL" as their text, while in another database, all my tables correctly have the SQL definition as text, meantime, all my stored procedures in BOTH databases correctly have the text available.Is there something I need to do to make sure the text column is up to date? BOL doesn't seem to mention anything about it...(I created the tables by running a script in QA not in EM.)Any ideas?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-30 : 19:58:06
|
| Are they set to different compatibility levels? Like could one be 6.5 while the other is 7.0, for example? That's the only thing I can think of. |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-01-30 : 20:01:20
|
Thanks rob - but no. They're both SQL Server 2000 - they're actually both on the same server. I thought maybe there's a switch for the DB or something - but I can't find it anywhere in BOL.Oh yeah, and the stored procedures were also created by script in QA and their text shows correctly...confused  --I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 01/30/2003 20:04:20 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-30 : 20:13:41
|
| It almost sounds like they are encrypted except they aren't since you can see them elsewhere. If they were encrypted though, the text column would be NULL. |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-01-30 : 20:14:59
|
| DOH!!!syscomments only contains text for objects other than tables...Sorry I rechecked my "working DB" and it doesn't contain table scripts. I should be able to get INFORMATION_SCHEMA to tell me what I want though.Thanks(Dumb question #321)--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-30 : 20:26:52
|
| Hmmm, I didn't even realize that you were wanting to see text in syscomments for tables, but now that I reread your post, I see that's what you were looking for. Well you answered your own question already... |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2003-01-30 : 20:30:18
|
Wow - just got emails to say that both robvolk and Valter had posted to this, but no new posts...I guess you both deleted the obscenity you were posting my way   --I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-30 : 20:48:03
|
| Are you looking for the column descriptions on a table or the ddl for the table?If it's the first then http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19865Or Use NorthwindGoselect a.[name] as tablename, c.[name] as columnname, b.[value] as Descriptionfrom sysobjects a left join sysproperties b on a.id = b.id inner join syscolumns c on a.id = c.idwhere a.[name] = 'Region' CheersEdited by - ValterBorges on 01/30/2003 21:00:50 |
|
|
|
|
No SQL is bad SQL