473,473 Members | 1,548 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Visual studio 2005 corrupt MS SQL 2000 stored procedures

When our developers access a MS SQL 2000 stored procedure using Visual
Studio 2005, it seems to save the stored procs in a format that causes
problems w/ MS SQL 2000. When I view the stored proc w/ a binary
editor, there are all kinds of null characters and hex characters like
"FF FE" , This makes MS SQL 2000 enterprise manager choke & spit out
syntax errors. Has anyone heard of this? If so, any advice will be
much appreciated.

Jun 29 '07 #1
2 1324
vs2005 will save the proc files as unicode. whatever you use to load
them into sql2000 probably does not handle unicode. in vs you can still
save as text (its an option, but must be done on each file).

-- bruce (sqlwork.com)

DZ****@Yahoo.com wrote:
When our developers access a MS SQL 2000 stored procedure using Visual
Studio 2005, it seems to save the stored procs in a format that causes
problems w/ MS SQL 2000. When I view the stored proc w/ a binary
editor, there are all kinds of null characters and hex characters like
"FF FE" , This makes MS SQL 2000 enterprise manager choke & spit out
syntax errors. Has anyone heard of this? If so, any advice will be
much appreciated.
Jun 29 '07 #2
This turned out to have nothing to do w/ MSSQL 2000 enterprise
manager, but the PC that is running Enterprise Manager. On 2 PCs
running the same version of Enterprise Manager, the same stored proc
source code will appear correctly and generate the stored proc
correctly on one, but not the other. This must have to do w/ a setting
in the registry that deals w/ unicode characters, but I have no idea
what it is.

Jul 2 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: gilles27 | last post by:
I've ready many of the posts on this and other newsgroups in which people describe working practices for source control of database scripts. We are looking to implement something similar in my...
0
by: Ryan | last post by:
I have been developing an ASP.NET application using Visual Studio 2003 and MSDE. While developing the application, I can easily add or delete database tables, stored procedures, etc. Recently, I...
0
by: athos | last post by:
Previously, we could use Visual Studio .Net 2002 combined with Visual SourceSafe 6.0 to maintain version control for Stored Procedures. (refer to "How to add SQL Server 2000 Stored Procedures to...
10
by: Dick | last post by:
Using Visual Studio 2003 you were able to manage SQL stored procedures with Visual Source Safe. So long as Visual Studio was used as the editor, it was imposible to make a change to a stored...
0
by: Gloria | last post by:
Hi all, I created a DTS package in SQL Server 2000 that creates several stored procedures. I need to run this package as part of an installation program for an application that uses the stored...
4
by: Jeff Kish | last post by:
Hi. I am under the understanding that having the sql server 2005 db is not enough (like 2000 was) to debug stored procedures.. that I need to purchase (costly) visual studio 2005. Can someone...
5
by: dougdoc | last post by:
We are exploring doing some development with MS Visual Studio 2005 to access our DB2 UDB for Windows databases. Are there any other options to accessing DB2 with Visual Studio that may be more...
1
by: bharathreddy | last post by:
This Article gives an introduction to VSTS Team Foundation & fundamental difference between Visual Source Safe (VSS) and VSTS Team Foundation. Team Foundation is a set of tools and technologies...
5
by: Claudio M. E. Bastos Iorio | last post by:
Hi, anyone using VS2008 (final) on windows Vista? I have a problem. The ASP.NET web site administration tool on any site created by VS2008, running on Vista, is not working as it should. I can...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.