January 27, 2010 at 1:00 pm
Hi,
When i run the following query, it display only part of results.
Query
select ‘Use ‘+ name + char(13)+ ‘go’ + char(13)+
'Grant Select on glsetup to a.Solomon.Admin
Grant Select on apdoc to a.Solomon.Admin
Grant Select on apsetup to a.Solomon.Admin
Grant Select on perclosed to a.Solomon.Admin
Grant Select on batch to a.Solomon.Admin
Grant Select on aptran to a.Solomon.Admin
Grant Select on gltran to a.Solomon.Admin
Grant Select on custom2 to a.Solomon.Admin
Grant Select on pstatus to a.Solomon.Admin
Grant Select on apadjust to a.Solomon.Admin
Grant Select on rptcontrol to a.Solomon.Admin
Grant Select on rptruntime to a.Solomon.Admin’
from sysdatabases where dbid =5
order by dbid
Results
Use nsiplrup
go
Grant Select on glsetup to a.Solomon.Admin
Grant Select on apdoc to a.Solomon.Admin
Grant Select on apsetup to a.Solomon.Admin
Grant Select on perclosed to a.Solomon.Admin
Grant Select on batch to a.Solomon.Admin
Grant Select on aptran
(1 row(s) affected)
It will not shown the entire results. How to do that
Regards,
Balavenkatesh
January 27, 2010 at 1:01 pm
In the options, there's a setting for the maximum string length to display. Check that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 27, 2010 at 1:23 pm
Hi Thanks for your info. Now it is working fine.
I changed the Maximim character per column values.
Regars,
S.Balavenkatesh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply