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 multidimentiona l array?
I'm stuck on this one. SQL Server is not my primary function, I am usually a Visual Basic coder.
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 multidimentiona l array?
I'm stuck on this one. SQL Server is not my primary function, I am usually a Visual Basic coder.