By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 2,417 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

db mail questtion: How can I clean up the format

P: 71
Hi all,

I have a proc that runs once per minute that monitors the health a function of an application. When the check fails, I throw four queries at the application database to report on what the application was doing when it failed.

The problem is that the tables have very long field lengths for the columns and it makes the output unreadable.

I am a programmer and not a DBA, so I have no access outside of 'read only' to the tables themselves.

does anyone have advice on what would be a good method of trimming the length of the columns for the output? I.E. Is there a way to bring it into a temporary table and then change the length of that table? Perhaps a way of bringing it into a multidimentional array?

I'm stuck on this one. SQL Server is not my primary function, I am usually a Visual Basic coder.
Mar 21 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.