Same problem.

When I kill the ssms process via the task manager. The Solution1 folder has been created but is empty :angry:

Alexander

The job does not execute any ddls at all.

Can you confirm that after...

I query both table and view from SSMS.

Your application may cach the query...

I'm a firm believer in the old aphorism, "Give a man a fish and you feed him for a day. Teach a man to fish and you feed him...

Thank you for your ideas. But none of your problems is the case:

As I have describe I query the table and the view not only in one connection but in...

Simple as can be:

USE [ZDA_005000_AU_TEMP]

GO

/****** Object: View [stage].[RATING] Script Date: 02/28/2012 11:22:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [stage].[RATING] AS SELECT * FROM [ZDA_005000_AU_STAGE].[dbo].[RATING]

GO

Sorry, I had a typo in my first posting: I am aware that schema changes of the underlying table are not being propagated to the view. What drives me crazy...

Hoping to be more helpful and less snotty than others:

WITH x AS

(

SELECT 'Bo' AS SYMBOL,1 AS BBit,10 AS Bval,'LastPrice1' AS BKey

UNION ALL SELECT 'Bob' AS SYMBOL,1 AS BBit,69 AS...

That makes the results identical (as obviously dropping and re-creating the view does).

But I'd be happy if the view was correct without explicitly forcing it to be...

OK, now at least I found that the sql server native client is capable to notice when a password is expired and shows a dialog box where the user can...

No, there is no IIS involved at all. I am talking about a direct (OLE DB or ODBC) database connection from a client to a server.

No ideas on this topic?

Hi the host has 32 GB RAM.

I think we have identified the problem. SQL Server is memory hungry beast and doesn't play nice when you have 2 instances competing for memory if you don't set the...

The box is a VM (2 Servers running on the same physical box).

SELECT @@VERSION...