Searching in SQL management Studio 1

[Cpreston]

Hi

This may not be the right place to ask but does anyone know how to search for a View

I have a view called SELECT * from "vwOrderVolumeByDate"
If I run the Select statement I get rows back. I cannot locate it anywhere under the Views object explorer. I have even looked under stored procedures but cannot locate it.

Any ideas how I can find it as I need to look into its design

Thanks

 

[SaltyTheFrog]

This will find it and is a great all round search tool. The best part is it is free....

http://www.red-gate.com/products/sql-development/sql-search/

 

[Cpreston]

Hi

I cannot load this on the server unfortunately.

Thanks

 

[Cpreston]

Hi

I loaded it locally and logged into the server via my local installation. brilliant tool thanks for the tip

 

[SQLBill]

You could also run this in each database to find out which one has the view.

SELECT *
FROM sys.objects
WHERE type = 'v'

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875