Authentication, windows or custom

I have read most of the threads regarding form authentication as well as the suggested articles. Unfortunately I am not clear if I need to do custom security or stay with windows authentication

I would like to access a specific report using a URL so that all the features and funcionalty of the report is available to the user. There are to many users and reports to assign and maintain individual users and/or groups to a specific report.

Our users would access the report from either a windows or web application having already passed security. They would have a button to press to obtain the report. We would prefer to pass a specific userid to report services at this point that is authorized to view the report.

Can this be done without switching to custom security? To use form authentication must you switch to custom security? Would impersonation work?Hi,

If you go with Windows Authentication, then you can retrieve the Windows UserId from the Thread class - Thread.CurrentPrincipal.Identity.Name

Regards,
Vikram

Audit Log

Hello,
I wanted a query regarding archiving the data from the log files. Really wha
t I wanted here is as follows:
When we change the data through the application, we can have the log to see
who has changed what data. But when the data is modified through the SQL
Server Enterprise Manager or Query Analyzer we can not have the log. But I
think this will be recorded in the log files. But how can I archive this
data. Means can I write some queries or stored procedures to get the
modifications done in the database?
--With Regards,
Sheshadrinath.Ran UPDATE trigger would be one way.
"Sheshadrinath R" <SheshadrinathR@.discussions.microsoft.com> wrote in
message news:8F77796A-071B-4609-8E0E-F0275E2A7434@.microsoft.com...
> Hello,
> I wanted a query regarding archiving the data from the log files. Really
> wha
> t I wanted here is as follows:
> When we change the data through the application, we can have the log to
> see
> who has changed what data. But when the data is modified through the SQL
> Server Enterprise Manager or Query Analyzer we can not have the log. But I
> think this will be recorded in the log files. But how can I archive this
> data. Means can I write some queries or stored procedures to get the
> modifications done in the database?
> --With Regards,
> Sheshadrinath.R|||Hi,
true said you can do it with INSERTED AND UPDATED TABLE , please go through
the article on the same topic as you ask at :
http://www.netdscure.co.in/Articles/AuditDML.htm
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Sheshadrinath R" wrote:

> Hello,
> I wanted a query regarding archiving the data from the log files. Really w
ha
> t I wanted here is as follows:
> When we change the data through the application, we can have the log to se
e
> who has changed what data. But when the data is modified through the SQL
> Server Enterprise Manager or Query Analyzer we can not have the log. But I
> think this will be recorded in the log files. But how can I archive this
> data. Means can I write some queries or stored procedures to get the
> modifications done in the database?
> --With Regards,
> Sheshadrinath.R

Attach/restore databases in SQL Server 2000

Hi,

I've got a question regarding attaching/restoring of DBs and wonder if anyone could help me out.

Does SQL Server 2000 provide a functionality to attach/restore DB automatically? ie, some kind of polling service to attach/restore DB that were detached previously?

Thanks

Danny.

No.

And why would it. There could be dozens of experimental, sample, demo, 'old' database files on the computer. It should not ATTACH anything that it is not specifically instructed to attach.

|||

why not?

Imagine the scenerio where there are 100 salesman with a laptop each and each laptop running a local version of web portal supported by local MSDE backend (only relevant database will be on the machine).

A WISE script executable will be created for updates of portal and existing database. If there's a new database required, the server should be able to be aware of it an attach it automatically.

Surely there's got to be a way of attaching database to 100 machines automatically.

|||

You can write scripts, you can even write stored procedures that automatically execute when the server first starts, and you can use Replication.

But if you find an 'automatic' way to attach databases, please let us know.

|||

Will certainly do. "Inside SQL Server 2000" just arrived. I'll consult it instead.

|||

SQL Server has no way for automatic / implicit attaching of databases. You will have to use (as Anrie indicated a SP or task to search for files). Why don′t you put that in your installer script ? As from your description, it is running on the machine where the databases reside on.

Jens K. Suessmeyer.

http://www.sqlserver2005.de