Default Encoding when saving a file in SSMS

Hi All

Is there a way (e.g. via Registry) to change the default encoding settings from UNICODE to a different encoding?

Thanks

Martin

Just want to know why you want it in registry hack way: http://blogs.msdn.com/sqlprogrammability/archive/2006/07/07/659375.aspx fyi.|||

Hi

Thanks for the reply. I understand what this blog is saying and most databases could switch to UNICODE and the errors in losing character information would have been resolved.

We are using software working with the ANSI standard. If I extract a stored procedure with the SSMS, fix or extend it, save it and distribute the stored procedure file with that tool to other databases, the tool fails unless I store it as an ANSI file not an UTF-16 (SSMS standard) file.

Therefore it would be very helpful for me if I could choose the default file format when saving files within the SSMS.

So I'm not exactly talking about the character standard of the database. I'm just having an issue with the default character format with the SSMS when saving a file.

Any idea how to resolve this?

Thanks

Martin

|||

I'm afraid there isn't a way to specify a different default encoding.

Please file your suggestion at http://connect.microsoft.com/sqlserver. When the development team is considering what features to implement, one of the criteria is whether a customer has actually requested it.

Thanks,

Steve

Default Encoding when saving a file in SSMS

Hi All

Is there a way (e.g. via Registry) to change the default encoding settings from UNICODE to a different encoding?

Thanks

Martin

Just want to know why you want it in registry hack way: http://blogs.msdn.com/sqlprogrammability/archive/2006/07/07/659375.aspx fyi.|||

Hi

Thanks for the reply. I understand what this blog is saying and most databases could switch to UNICODE and the errors in losing character information would have been resolved.

We are using software working with the ANSI standard. If I extract a stored procedure with the SSMS, fix or extend it, save it and distribute the stored procedure file with that tool to other databases, the tool fails unless I store it as an ANSI file not an UTF-16 (SSMS standard) file.

Therefore it would be very helpful for me if I could choose the default file format when saving files within the SSMS.

So I'm not exactly talking about the character standard of the database. I'm just having an issue with the default character format with the SSMS when saving a file.

Any idea how to resolve this?

Thanks

Martin

|||

I'm afraid there isn't a way to specify a different default encoding.

Please file your suggestion at http://connect.microsoft.com/sqlserver. When the development team is considering what features to implement, one of the criteria is whether a customer has actually requested it.

Thanks,

Steve

default database for scripts in SSMS

When I write a script in SSMS (I'm using SQL Server 2005), generally the
database that pops up in the pulldown window on the menu, and which the
script runs against (unless/until I change the pulldown selection), is the
master database. I'm working with only one database I've created, and I
rarely run scripts against the master database, so is there an option to have
SSMS default to my database instead of the master database?
Ed
Change the user default database. Go to Security, Logins, right-clik your
login and select default database.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Ed White" wrote:

> When I write a script in SSMS (I'm using SQL Server 2005), generally the
> database that pops up in the pulldown window on the menu, and which the
> script runs against (unless/until I change the pulldown selection), is the
> master database. I'm working with only one database I've created, and I
> rarely run scripts against the master database, so is there an option to have
> SSMS default to my database instead of the master database?
> --
> Ed

Default cube view in SSMS?

Hi,

When browsing a cube in management studio, is there a way set up default value in PivotTable?

Let’s say the cube has 20 dimensions and 10 measures, but user see 2 dimensions and one measure more often; when open a cube, can SSMS just show the default view (2 dimensions and one measure

Thanks in advance.
You can create a perspective with just the 2 dimensions and the measure more used. However, SSMS nor Excel will use one as the default (I think). Of course, if you a Pivot Table for the new perspective is just a question of refreshing that PT.|||
Thank you very much Tiago, your information is very helpful.
I really appropriated.

|||

SSMS is not a tool for end user.

If you, as administrator, want to see some predefined MDX queries you constuct it once then intercept the MDX with profiler and save the MDX in file. Then you can call those MDX queries in SSMS every time you want.