September 17, 2009 at 4:57 am
I have a strange problem which I cannot find a solution to, I hope someone here can help.
I use SQL 2000 and I have a problem where the SQL code layout appears to change, most of the time this is not a problem however occasionally it removes a carriage return and that causes the code to fail. This only happens if I open an existing item to edit it.
This has only started since we have made the decision to upgrade to SQL2008 and so I have installed the management tools for SQL2008 on my laptop to allow me to access both systems at the same time. The tools for SQL2000 are also installed and I use the 2K tools to access 2K databases.
My question is, has anyone else experienced this? and if so have you found a resolution?
I have spent quite a long time on google and other forums, but not had much success mainly I suppose because how do you describe this problem in a way a search engine understands!
September 17, 2009 at 6:32 am
The best way to describe it would be to show us. I'm not really sure what your problem is or how it is causing your code to fail.
When your code does fail, what is the full error message as well.
September 17, 2009 at 7:04 am
First let me thank you for taking the time to look at my post.
I realise my description was going to be less than required, probably the reason why I can't find the answer myself.
Anyway here goes. Originally the code, which is basic transact SQL query stuff, was written using SQL2000 query analyser. Since it was originally written I have had to install SQL2008 Management tools on my laptop and now when I open (in SQL2000 query analyser) the old code there are things that are missing example
select
column1
from
mydatabase.dbo.mytable
where
data = whatever
becomes
select
column1from
mydatabase.dbo.mytable
where
data = whatever
And so the code fails to run, which I do realise is a very simple thing to fix, however it is annoying.
Also it is worth mentioning that if I open the same procedure from a machine with only SQL2000 tools installed the code is formatted as it should be. I have opened the same procedure from 2 places at the same time and only the one on my machine is reformatted.
I believe it is something to do with installation of both SQL2000 and SQL2008 tools on the same machine.
I hope that makes more sense.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply