Has anyone found a solution to this? I am running into exactly the same thing.

One Christmas wish was granted - My boss bought 7 new SQL 2005 books for the Developers to use instead of mine.

My wish is to have SQL 2005 training setup...

Nevermind, I figured out what was happening. I needed to add a carrage return because otherwise it was putting two words together.

Thanks for your help.:)

Here is the query that I am trying to use with your suggestion.

--exec up_dynamic_sql_test '2004'

alter procedure up_dynamic_sql_test @year char(4) AS

SET NOCOUNT ON

DECLARE @SQL1 varchar(8000)

DECLARE @SQL2 varchar(8000)

DECLARE @SQL3 varchar(8000)

SET @SQL1 =...

I work for a Large Financial and Banking company and I am struggling with the same thing. End users have read access to views and some tables in specific...

Always a Dt. Mountain Dew.  I always have one at my desk.

Then something with chocolate and peanuts or peanut butter.  Reeses Peanut...

To err is human, it takes a computer to really screw things up!

Aparently you are a Bob and Tom fan.

I have to also put in my two cents worth on LogPI.  I also found that it was not intuitive in the installation.  Also there is a lack of...

David,

I totally agree with you about Sybase being primeval ooze.  With the  upgrade to Sybase 12.5.1 they just added scheduling services for jobs.  Something that SQL Server has had for...