Viewing 15 posts - 1 through 15 (of 71 total)
Same problem.
When I kill the ssms process via the task manager. The Solution1 folder has been created but is empty :angry:
Alexander
September 23, 2013 at 8:13 am
Eugene Elutin (2/29/2012)
Does your job have a step to recreate a table or make any DDL change?
The job does not execute any ddls at all.
Can you confirm that after...
February 29, 2012 at 6:03 am
Eugene Elutin (2/28/2012)
Do you see the difference in returned resultset in SQLServer MS or in a client/server application?
I query both table and view from SSMS.
Your application may cach the query...
February 29, 2012 at 2:18 am
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...
February 28, 2012 at 7:50 am
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...
February 28, 2012 at 7:32 am
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
February 28, 2012 at 3:23 am
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...
February 28, 2012 at 12:39 am
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...
February 27, 2012 at 8:50 am
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...
February 27, 2012 at 7:32 am
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...
May 19, 2011 at 2:33 am
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.
May 18, 2011 at 5:21 am
Hi the host has 32 GB RAM.
March 22, 2011 at 1:51 am
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...
March 14, 2011 at 9:26 am
Sankar Reddy (3/13/2011)
Can you share some information if the box is stand alone or a VM?
The box is a VM (2 Servers running on the same physical box).
SELECT @@VERSION...
March 14, 2011 at 2:49 am
Viewing 15 posts - 1 through 15 (of 71 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy