Activity overview
Latest activity by petani
Can SQL compare use a specified list of elements
Hi
My situation is that I have to compare specific elements in a database used for a certain area. For instance I want to compare tables and other elements used in connection with say a dimension o...
I have figured out what my problem is.
I am using osql to install the script on another server and osql reads its input file in the OEM cp850 encoding in the settings on that server.
Unfortunate SQL Compare do not have the option to save in OEM cp850 format and as I se the documentation in in Books online for osql there is no way to specify the input files encoding.
In QA can save in OEM cp860 and scripting from Enterprise Manager can also be saved in OEM cp850 encoding.
Are there any plans for adding the option to save in OEM cp850 from SQL compare? / comments
I have figured out what my problem is.
I am using osql to install the script on another server and osql reads its input file in the OEM cp850 encoding in the settings on that server.
Unfortunate SQ...
I have tried Query Analyzer, Notepad and Ultra Edit and they are all showing strange characters instead of the danish ones.
Any idea what can be wrong? / comments
I have tried Query Analyzer, Notepad and Ultra Edit and they are all showing strange characters instead of the danish ones.
Any idea what can be wrong?
National characters in saved script
I sometimes have to write national characters like the three danish letters ø, æ and å. When I try to save the generated script by using the "save script" button the three characters are saved a...
The views is in fact fully-qualified with the name of the database I am trying to synchronize. (I know that its not neassery - it is left over from when the stored procedure was in another database)
I will follow the other thread. Thanks for your quick answer
[/quote] / comments
The views is in fact fully-qualified with the name of the database I am trying to synchronize. (I know that its not neassery - it is left over from when the stored procedure was in another database...
Trying to create stored procedure before view it depend on
Hi
I am trying to synchronize a database on server A with one on server B.
I have a stored procedure that selects something form a view. That view has been modified on server A and therefore needs ...