Showing posts with label automatically. Show all posts
Showing posts with label automatically. Show all posts

Thursday, March 8, 2012

Change the size of drop down parameter box

Im trying to make it so my drop down box on the parameter for my report
automatically fits or at least I can specify the size. Im using ssrs 2005
and there is a sroll bar on on both sides. I would like to increase the size
so I dont have these but dont know how to. PLEASE HELP!!!!On Jun 28, 12:04 pm, OWeston <OWes...@.discussions.microsoft.com>
wrote:
> Im trying to make it so my drop down box on the parameter for my report
> automatically fits or at least I can specify the size. Im using ssrs 2005
> and there is a sroll bar on on both sides. I would like to increase the size
> so I dont have these but dont know how to. PLEASE HELP!!!!
This is a pretty regular request on this news group. Currently, this
type of property cannot be controlled; but, hopefully it will be
available in the near future (perhaps w/SSRS 2008). Sorry that I could
not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Is there a fix/update for this yet?
"EMartinez" wrote:
> On Jun 28, 12:04 pm, OWeston <OWes...@.discussions.microsoft.com>
> wrote:
> > Im trying to make it so my drop down box on the parameter for my report
> > automatically fits or at least I can specify the size. Im using ssrs 2005
> > and there is a sroll bar on on both sides. I would like to increase the size
> > so I dont have these but dont know how to. PLEASE HELP!!!!
>
> This is a pretty regular request on this news group. Currently, this
> type of property cannot be controlled; but, hopefully it will be
> available in the near future (perhaps w/SSRS 2008). Sorry that I could
> not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jul 10, 1:14 pm, JMD <J...@.discussions.microsoft.com> wrote:
> Is there a fix/update for this yet?
> "EMartinez" wrote:
> > On Jun 28, 12:04 pm, OWeston <OWes...@.discussions.microsoft.com>
> > wrote:
> > > Im trying to make it so my drop down box on the parameter for my report
> > > automatically fits or at least I can specify the size. Im using ssrs 2005
> > > and there is a sroll bar on on both sides. I would like to increase the size
> > > so I dont have these but dont know how to. PLEASE HELP!!!!
> > This is a pretty regular request on this news group. Currently, this
> > type of property cannot be controlled; but, hopefully it will be
> > available in the near future (perhaps w/SSRS 2008). Sorry that I could
> > not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
I've checked Microsoft.com and haven't found anything available yet.
Regards,
Enrique Martinez
Sr. Software Consultant

Saturday, February 25, 2012

change standard security password of sa

Dear All,
I failed to change the standard security password of sa
which is generated automatically. Whatever I changed it by
the function sp_password and it alerted successful. The
password of sa is still the same as before. How to change
the password of sa ......../.According to Books Online:
sp_password [ [ @.old =3D ] 'old_password' , ] { [ @.new =3D] 'new_password' } [ , [ @.loginame =3D ] 'login' ]
So, you would use something like this:
sp_password 'thecurrentpassword', 'thenewpassword', 'sa'
-- Keith
"ken" <anonymous@.discussions.microsoft.com> wrote in message =news:09c701c3c626$86cca000$a301280a@.phx.gbl...
> Dear All,
> I failed to change the standard security password of sa
> which is generated automatically. Whatever I changed it by
> the function sp_password and it alerted successful. The
> password of sa is still the same as before. How to change
> the password of sa ......../.|||When SQL Server is isntalled the sa password in NULL. There is not
automatically generated password. So if after installation the password for
sa in not NULL then someone is changing it after the installation.
Rand
This posting is provided "as is" with no warranties and confers no rights.

change standard security password of sa

Dear All,
I failed to change the standard security password of sa
which is generated automatically. Whatever I changed it by
the function sp_password and it alerted successful. The
password of sa is still the same as before. How to change
the password of sa ......../.Try logging into SQL Server using Windows Authentication as an
administrator on the machine. Then use Enterprise Manager, right click on
the sa account and change the password.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Sunday, February 19, 2012

change save settings directory on SSMS 2005

when i exit sql server management studio i get the following error:

The automatically saved settings file '\\SERVER\DATA\Sql Server Management Studio\Settings\CurrentSettings-2006-09-21.vssettings' is not available for write. You can change this file on the 'Import and Export Settings' Tools Options page.

i'm guessing this might be because of the corporate policy of pointing everyone's "My Documents" at a read-only folder.

i'd like to follow the advice on the dialog but unfortunately my Tools, Options dialog does not have an 'Import and Export Settings' page.

any ideas?

This problem relates to SSMS being an offshoot of the Visual Studio Shell. I would raise a bug in Connect http://connect.microsoft.com/sqlserver|||

You could try changing the registry I found this key that might be worth looking at

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell

|||

Probably the folder in which the vssettings file is present is a read-only location and that's why it's not allowing you to over-write it.

But you can very well re-direct your My Documents folder to any location(for which you have write access) and save the settings file will be saved when you close the SSMS.

For redirecting the My Documents folder, right click on it and select Properties and specify the new path in the Target folder location.

Hope that Helps.

Regards,

Rajesh

|||bug raised as https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=208955

Thursday, February 16, 2012

Change Primary Key Values

Hello,
Is there a way in SQL Server 2000 to reassign primary key
values automatically?
For example, I have a table that has a "Person ID" field
as its primary key that was started with an identity seed
of "98753162". The identity increment is "1".
Now, there are hundreds of records in this table. I want
to reassign these PK values with much shorter numbers,
i.e. subtract "98753160" from all existing values. In
addition, I would need all corresponding foreign key
values in other tables to be updated automatically with
the new values.
Thanks,
Mike1)Distable the foreign key constraint with ALTER TABLE command.
look for alter table command in BOL "alter table... nocheck ..." (look for
nocheck clause) which will stop validation of future inserts or updates to
the column.
2) add a column to primary key table and populate the values of PK to this
column with the statement as
update <table> set new_col=PK_col
3)you can update the existing primary key values with the statement such as
update table set PK_col= pk_col - 98753160 --required subtraction.(make sure
primary key constraint is not violated)
4) once this is done you will have to fire an update statement on the FK
tables to update the new FK values replacing the old one.
--
-Vishal
"Mike Rogan" <mrogan@.carolinawebdev.com> wrote in message
news:038e01c3555a$95864c50$a601280a@.phx.gbl...
> Hello,
> Is there a way in SQL Server 2000 to reassign primary key
> values automatically?
> For example, I have a table that has a "Person ID" field
> as its primary key that was started with an identity seed
> of "98753162". The identity increment is "1".
> Now, there are hundreds of records in this table. I want
> to reassign these PK values with much shorter numbers,
> i.e. subtract "98753160" from all existing values. In
> addition, I would need all corresponding foreign key
> values in other tables to be updated automatically with
> the new values.
> Thanks,
> Mike