Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
create procedure sp_getviewmetadata @db_name varchar(20), @view_name varchar(20), @owner varchar(20) as declare @text varchar(1024) declare @text_line varchar(1024) declare @lines_count int declare @i int select @text = "", @i = 1 select @lines_count = count(c.text) from syscomments c, sysobjects o, sysusers u where o.id = c.id and o.uid = u.uid and o.name = @view_name and u.name = @owner create table #viewquery ( sqlquery text ) while (@i <= @lines_count) begin select @text_line = c.text from syscomments c, sysobjects o, sysusers u where o.id = c.id and o.uid = u.uid and o.name = @view_name and u.name = @owner and colid = @i if @i = 1 insert into #viewquery select @text_line else update #viewquery set sqlquery = sqlquery + convert(text, @text_line) select @i = @i + 1 end select #viewquery.sqlquery from #viewquery
|Looking for Sybase 12.5.4 EBF ESD#9.1 or 10 patch||5||794|
|Sybase - CronJob schedule||2||604|
|SQL, Updating Statistics take too long for 60GB database||5||166|
|SyBase Query Syntax Date Time conversion||4||40|