According to a developer that worked on my db, there is a view :
xvw_CheckVoucherReport
I cant see it is there any way i can find out it exsist and if so what database on my server it is in?Enterprise Mangler (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_aa_5rg2.asp) would use SQL-DMO (http://msdn.microsoft.com/library/en-us/sqldmo/dmoref_con01_5qup.asp) to show it to you. You could also use SQL Query Analyzer (http://msdn.microsoft.com/library/en-us/qryanlzr/qryanlzr_1zqq.asp) to check the INFORMATION_SCHEMA.VIEWS (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_4pbn.asp) for it.
-PatP|||Select * from Sysobjects should generate all the objects in your database.|||Originally posted by sqlserver2k
Select * from Sysobjects should generate all the objects in your database. Good point, but information_schema views are a lot friendlier and are portable. Why start bad habits (using system tables) when good ones are easier?
-PatP|||I second Pat's proposition ... for not to use SYSTEM TABLES when system supplied SPs and ISVs are provided.
Showing posts with label exsist. Show all posts
Showing posts with label exsist. Show all posts
Subscribe to:
Posts (Atom)