Did you install Integration Services? Do you have SP2 for SQL Server 2005 installed?

Yelena

The idea is nice and it runs in SQL Server nice. But the web developers code their pages differently and appending this to different asp and aspx pages going towards...

Sure! A lot. In VB or other front end in relation to Recordset or Dataset references or controls like GRID control.

How it relates to SQL? We can use this code...

This is in regards to the previous post:

Why we can select count from other positions?

SELECT COUNT (25) FROM #TEST

We can not order by 25:

SELECT * FROM #TEST ORDER BY 25...

I did not miss the last ALL in UNION, I guessed it was a trick

What a good question!

Either Microsoft Programmers or Defaults.

In the CAST and CONVERT (TSQL) BOL article there is a table with formats. My date is returned as the following if Management Studio query window...

What is interesting, that if you don't convert to the character string, the format is different:

set language us_english

set dateformat dmy

go

declare @date datetime

set @date = '11 apr 2008 17:10'

select left(@date,1)

select @date,...

Sue,

I think your issue is not in the stored procedure plan being cached.

You say when the application runs you are getting the old results. Please test the stored procedure itself...

Good thought!

That is exactly why I was interested if recompilation helps - if you explicitly recompile and it does not help, then it is a wrong server or a wrong...

sp_recompile is good!

I suggested DBCC FREEPROCCACHE because I guessed that with the application update they may have many altered procedures and statements

You may also want to try

DBCC FREEPROCCACHE

to make SQL Server recompile everything

Do you have WITH RECOMPILE line in ALTER PROCEDURE statements?

Try it, if it works then this is a compilation issue. Do not use this statement permanently because the procedure will...

Hello,

Since you say "On My PC" I assume that Visual Studio and SQL Server are on the same computer.

In the Configuration Manager for Named Instance under Network Configuration make sure...

The difference between INSERT and the function is when you insert and the data get truncated, this leads to stored data corruption. If you use a function, the stored data...

You have to add the linked server login by mapping the local login to the remote login.

http://msdn.microsoft.com/en-us/library/ms189811.aspx

sp_addlinkedsrvlogin (Transact-SQL)