Adding a "DB Version" Table: Suggestions?

I'm putting a little table in my DB that I'll call zstblVersion.

("..stbl" for System Table, "z" so it sinks to the bottom of the list and
doesn't look like something to do with the app)

The purpose is to let somebody look at the DB and divine which version they're
seeing.

So far, I've got 3 columns:

- VersionID
- VersionDescription (freeform text description of the changes in this version
of the DB)
- AppVersionRequired (numeric field, containing the lowest version of the front
end that will work with this version of the DB)

Opinions? Suggestions?
--
PeteCresswellHi

I have seen several application that use this sort of thing, and they can be
useful for support.

You may want to add entries for the release date, date upgraded/installed,
the username who upgraded, previous version number, OS (at time of
install!), possibly SQL Server versions (at time of install) etc

These could be put in a readonly filegroup, although you would need to do a
little more when doing the upgrades.

John

"(Pete Cresswell)" <x@.y.z> wrote in message
news:hkkeovomiv3jidkll7mda1jrkk4ptuc1p2@.4ax.com...
> I'm putting a little table in my DB that I'll call zstblVersion.
> ("..stbl" for System Table, "z" so it sinks to the bottom of the list and
> doesn't look like something to do with the app)
> The purpose is to let somebody look at the DB and divine which version
they're
> seeing.
> So far, I've got 3 columns:
> - VersionID
> - VersionDescription (freeform text description of the changes in this
version
> of the DB)
> - AppVersionRequired (numeric field, containing the lowest version of the
front
> end that will work with this version of the DB)
> Opinions? Suggestions?
> --
> PeteCresswell

Add new column to a replicated table..

Hi,
I need to add a column to a table that is being replicated.
Can I just do the ALTER TABLE ADD xxxx bit then make a call out to
sp_replAddColumn?
When I do so, the sp fails saying the column exists. The manual says that it
adds the column to the publications, but does not suggest it does the
physical add tot the table..
Thanks in advance,
SPGYou use sp_replAddColumn INSTEAD of using alter table add column... the Sp
adds the column to the table, and fixes replication... since you manually
added the column the sp fails.... drop the column and use the SP only.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"SPG" <steve.nospoo.goodsell@.nopooblueyonder.co.nopoo.uk> wrote in message
news:r9IQd.16027$8B3.14345@.text.news.blueyonder.co.uk...
> Hi,
> I need to add a column to a table that is being replicated.
> Can I just do the ALTER TABLE ADD xxxx bit then make a call out to
> sp_replAddColumn?
> When I do so, the sp fails saying the column exists. The manual says that
> it adds the column to the publications, but does not suggest it does the
> physical add tot the table..
> Thanks in advance,
> SPG
>|||Thanks for that..
I sort of half guessed that when the sp failed, but the docs are not too
clear on this..
Steve
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23oEXG8CFFHA.2568@.TK2MSFTNGP10.phx.gbl...
> You use sp_replAddColumn INSTEAD of using alter table add column... the
> Sp adds the column to the table, and fixes replication... since you
> manually added the column the sp fails.... drop the column and use the SP
> only.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "SPG" <steve.nospoo.goodsell@.nopooblueyonder.co.nopoo.uk> wrote in message
> news:r9IQd.16027$8B3.14345@.text.news.blueyonder.co.uk...
>

Add admin user to reporting services

Hi, we have a webpage which makes a call to the reporting services
function GetSystemPermissions via C# to get permissions for our
intranet.
My question is how to I add an admin user to this group? Is it done
via Active Directory and if so what rights does the person need?
We are running MSSQL 2005 and Windows Server 2003.
Thanks for any help
Regards
MarkusReporting Services by default is integrated with Windows integrated
security. But, you have to map a user or group to a role in RS. By default
any member of the local adminstrators group is an admin in RS.
What I do is add appropriate users to the local adminstrators group on the
server running RS for adminstrative rights. But you could just assign
another group to the appropriate role in RS. For browsing I add a local
group and then to that local group I add individual users and domain groups.
That local group is then assigned to the appropriate role.
Read up on roles in RS.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<MarkusJNZ@.gmail.com> wrote in message
news:1183531995.432312.93700@.m37g2000prh.googlegroups.com...
> Hi, we have a webpage which makes a call to the reporting services
> function GetSystemPermissions via C# to get permissions for our
> intranet.
> My question is how to I add an admin user to this group? Is it done
> via Active Directory and if so what rights does the person need?
> We are running MSSQL 2005 and Windows Server 2003.
> Thanks for any help
> Regards
> Markus
>