It looks like the view is not schema bound and the underlying table was probably updated after the view was created. When doing that, the view needs refreshed.

Run either...

My 2 cents.

Be very cautious when running profiler on a production server because of the performance impact it can/will have.

The recommended better approach is to run a server side trace.

Like...

That one might be closer to fowl fell.

Good Stuff Wayne

Cool. It should work well for you.

Mensa don't think, Mensa knows.

Gungan

cengland0 (1/19/2012)

---

But it will...

You're welcome

You're welcome.

nawaz1774 (1/19/2012)

---

Oh I am sorry. I just wanted to get view from two differnt experts. I am new to the Forum Culture. Thats the reason I doono That I should...

No.

But in SQL Server 2008 there is the intellisense option that will produce a list of the keywords as you type.

If the size needs to be Varchar(100) then change them to varchar(100). This depends on the max data size between the different sources as well as the business requirements.

This is a cross-post. Same thread, two forums.

Here is the other one.

http://www.sqlservercentral.com/Forums/Topic1238442-8-1.aspx

No diff on SQL version.