change timestamp from null to not null

Hi,
I have a table with a timestamp column which allows nulls.
I wanted to
ALTER TABLE [dbo].[MyTbl] ALTER COLUMN [MyClmn] [timestamp]
NOT NULL
but it gives me msg 4927 - Cannot alter column 'MyClmn' to
be data type timestamp.
Is there any elegant/easy way around this?
--
Many thanks,
OskHi,
Would dropping the column and recreating it with the 'not
null' clause be the advisable way to do it?
--
Many thanks,
Osk
>--Original Message--
>Hi,
>I have a table with a timestamp column which allows nulls.
>I wanted to
>ALTER TABLE [dbo].[MyTbl] ALTER COLUMN [MyClmn] [timestamp]
>NOT NULL
>but it gives me msg 4927 - Cannot alter column 'MyClmn' to
>be data type timestamp.
>Is there any elegant/easy way around this?
>--
>Many thanks,
>Osk
>.
>|||Osk wrote:
> Hi,
> Would dropping the column and recreating it with the 'not
> null' clause be the advisable way to do it?
>
>> --Original Message--
>> Hi,
>> I have a table with a timestamp column which allows nulls.
>> I wanted to
>> ALTER TABLE [dbo].[MyTbl] ALTER COLUMN [MyClmn] [timestamp]
>> NOT NULL
>> but it gives me msg 4927 - Cannot alter column 'MyClmn' to
>> be data type timestamp.
>> Is there any elegant/easy way around this?
>> --
>> Many thanks,
>> Osk
>> .
If you need to preserve the data in the table, create a second table,
copy the data, change the first table DDL and then migrate the data
back.
--
David Gugick
Imceda Software
www.imceda.com|||Hi David,
Thanks for your answer. Can you please tell me why would I
lose any data except the old timestamp values (which seems
to be inevitable anyway) by dropping and
redefining/recreating the timestamp column?
--
Many thanks,
Osk
>--Original Message--
>Osk wrote:
>> Hi,
>> Would dropping the column and recreating it with the 'not
>> null' clause be the advisable way to do it?
>>
>> --Original Message--
>> Hi,
>> I have a table with a timestamp column which allows nulls.
>> I wanted to
>> ALTER TABLE [dbo].[MyTbl] ALTER COLUMN [MyClmn] [timestamp]
>> NOT NULL
>> but it gives me msg 4927 - Cannot alter column 'MyClmn' to
>> be data type timestamp.
>> Is there any elegant/easy way around this?
>> --
>> Many thanks,
>> Osk
>> .
>If you need to preserve the data in the table, create a
second table,
>copy the data, change the first table DDL and then migrate
the data
>back.
>--
>David Gugick
>Imceda Software
>www.imceda.com
>.
>|||anonymous@.discussions.microsoft.com wrote:
> Hi David,
> Thanks for your answer. Can you please tell me why would I
> lose any data except the old timestamp values (which seems
> to be inevitable anyway) by dropping and
> redefining/recreating the timestamp column?
>
I guess it really doesn't matter if you lose the data in the column.
--
David Gugick
Imceda Software
www.imceda.com|||Yes, I lose the timestamp data in the column, but the rest
of the table data should be remaining intact. And from this
perspective the result of using either the drop-
redefine/recreate method or the export/import method would
be the same, except that the latter takes more effort to
implement.
--
Thanks,
Osk
>--Original Message--
>anonymous@.discussions.microsoft.com wrote:
>> Hi David,
>> Thanks for your answer. Can you please tell me why would I
>> lose any data except the old timestamp values (which seems
>> to be inevitable anyway) by dropping and
>> redefining/recreating the timestamp column?
>I guess it really doesn't matter if you lose the data in
the column.
>--
>David Gugick
>Imceda Software
>www.imceda.com
>.
>

change the default navigation bar

Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.Sorry for the double posting..... :-(

Change the default navigation bar

Is it possible to change the default navigation bar that appears in
Reporting Services?
The Navigation bar that allows, page movement, viewing size, Export
etc.&rc:Toolbar=false in the url, removes it
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> Is it possible to change the default navigation bar that appears in
> Reporting Services?
> The Navigation bar that allows, page movement, viewing size, Export
> etc.
>|||Thanks for the tip, but I need to create my own now, any ideas?|||I don't think there's a way. There could be a way to change the colors and
fonts, but I don't think you can change the structure.
And it's all messed up for firefox, or netscape. I check the browser before
I call the reports, and turn the toolbar off, if it's not IE.
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1112871211.962325.310910@.l41g2000cwc.googlegroups.com...
> Thanks for the tip, but I need to create my own now, any ideas?
>|||"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
hmm... that doesn't seem to work for me. my url reads:
http://MyServer/Reports/Pages/Report.aspx?ItemPath=%2fMy+Report&rc:Toolbar=False&rc:Parameters=false
but both the toolbar and the parameters pane show up just the same... what
am I doing wrong? also, how can I specify that the toolbar not be displayed
after the user presses the "View Report" button (since I obviously don't have
control over the URL at that point)?|||but I just want to remove the navigation bar, and keep the parameters bar ...
the URL:
..?&rc:toolbar=false&rc:parameters=true
doesnt work ...
How do it ?...
"Cindy Lee" wrote:
> &rc:Toolbar=false in the url, removes it
> "Bryan Avery" <b_avery@.yahoo.com> wrote in message
> news:1112798064.597189.163980@.z14g2000cwz.googlegroups.com...
> > Is it possible to change the default navigation bar that appears in
> > Reporting Services?
> >
> > The Navigation bar that allows, page movement, viewing size, Export
> > etc.
> >
>
>