Lock Report Header

I know this question was asked back in 2004 and haven't seen any updates on
it...
Is it possible to lock the report column headers - as in Excel - so as you
scroll, you'll always see the column title/header?
Thanks!!I believe you are looking for either "repeat header on each page" or "header
should remain visible when scrolling" on the table properties.
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:FF3F5EA6-3322-4F32-BCD5-1F35FD562FFD@.microsoft.com...
>I know this question was asked back in 2004 and haven't seen any updates on
> it...
> Is it possible to lock the report column headers - as in Excel - so as you
> scroll, you'll always see the column title/header?
> Thanks!!|||A thousand thank you's , Jason...!!
Don't know how I didn't see that earlier...
"jason" wrote:
> I believe you are looking for either "repeat header on each page" or "header
> should remain visible when scrolling" on the table properties.
>
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
>
> "A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
> news:FF3F5EA6-3322-4F32-BCD5-1F35FD562FFD@.microsoft.com...
> >I know this question was asked back in 2004 and haven't seen any updates on
> > it...
> >
> > Is it possible to lock the report column headers - as in Excel - so as you
> > scroll, you'll always see the column title/header?
> >
> > Thanks!!
>

Locating strange updates

Is there any simple way in EM to put an audit on a field to see when
and what is updating it ?
Thanks"Nucleo" <nucleo@.gmail.com> wrote in message
news:1135001926.638640.188450@.g49g2000cwa.googlegroups.com...
> Is there any simple way in EM to put an audit on a field to see when
> and what is updating it ?
> Thanks
>
Not in EM, but you can do it in SQL Profiler. Of course the profiler will
need to be constantly running to perform this action.
The only other way is to create an UPDATE trigger on the table and have it
spit out the data somewhere. You can gather information from the System
functions like SUSER_SNAME and so forth in the trigger.
Rick Sawtell
MCT, MCSD, MCDBA|||There is no simple Enterprise Manager feature that can give you desired
results within a few minutes.
This article descibes how to implement data auditing using triggers:
http://msdn.microsoft.com/msdnmag/i.../04/DataPoints/
The following describes how to use SQL Profiler auditing events.
http://msdn.microsoft.com/library/d...>
erf_86ib.asp
http://msdn.microsoft.com/library/d...>
erf_6koi.asp
http://msdn.microsoft.com/library/d...>
erf_6zg3.asp
"Nucleo" <nucleo@.gmail.com> wrote in message
news:1135001926.638640.188450@.g49g2000cwa.googlegroups.com...
> Is there any simple way in EM to put an audit on a field to see when
> and what is updating it ?
> Thanks
>

Local database and updates

I'm reviewing an application that uses a local database for a .NET
application. In adding logic to automatically update components of the
application (content files, assemblies updates, and data updates) I found
that the original design locks the database while the app is running. This
means that the updater code needs to detect a runnning instance of the .NET
app and signal it to close down before it can apply database updates. This
makes it impossible to apply updates automatically.
It seems to me that tightly linking the database to the .NET app is
unnecessary. I see no reason why the database cannot be updated while the
application is running. The updater itself could lock portions of the
database during updating to prevent corruption and then signal the
application to refresh its in-memory data once the updates have been
committed.
I'd appreciate any feedback from others about this issue as I want to be
sure that I've thought through all the possibilities.
TIA.
Peter Bernhardt
SharpSense Software LLC
peter@.SharpBASSense.netURA
Peter Bernhardt wrote:
> I'm reviewing an application that uses a local database for a .NET
> application. In adding logic to automatically update components of the
> application (content files, assemblies updates, and data updates) I
> found that the original design locks the database while the app is
> running. This means that the updater code needs to detect a runnning
> instance of the .NET app and signal it to close down before it can
> apply database updates. This makes it impossible to apply updates
> automatically.
> It seems to me that tightly linking the database to the .NET app is
> unnecessary. I see no reason why the database cannot be updated while
> the application is running. The updater itself could lock portions of
> the database during updating to prevent corruption and then signal the
> application to refresh its in-memory data once the updates have been
> committed.
I obviously do not know the application and the archithecture behind it, but
your words seems to indicate a need for single access to the data...
I will not enter a discussion about the requirements theme selves as, again,
I'm completely ignorant about theme, and I think you have to deal with the
producer(s) for more details...
you say
>... then signal the
> application to refresh its in-memory data once the updates have been
> committed.
the application must support a way to be notified of such an underlying
manipulation of data to allow that, an this could imply an architectural
modification... and this could be a potential big deal, depending on the
original design..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply