manage exception message

How to manage sql server runtime message to users understand it?

In my web form I added folowed code

If Session("Action") = "Edit" Then

Try

ObjectDataSource1.Update()

Catch ex As Exception

lblMessage.Text = ex.GetBaseException.Message

End Try

for manage user input for update the record.

This is message returned by sql server 2005

The UPDATE statement conflicted with the REFERENCE constraint "FK_DEVIZE_RELATION__DRZAVE". The conflict occurred in database "Trgo2006", table "dbo.Devize", column 'Drzava'. The statement has been terminated

This message not understand for users. How to manage messages retrned by sql server, or prepare exception to return message understanded for users.

YOu could build a generic wrapper class for Sqlexceptions like this one mentioned here:

http://weblogs.asp.net/guys/archive/2005/05/20/408142.aspx

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Malicious User

Not sure if its the right place..but need help cracking this...Just
inherited a bad place......
Users access a certain share point site and browse a directory for a host of
folders.This afternoon one of the folders was deleted which has loads of
subfolders(as it is a sharepoint server).....now I need to find out who thi
s
kool dude is!...
What I have now: System state backup of the Machine,SQL full backup and the
backup(SQL and System) just after the files have
been deleted.
All I have is just Auditing for success and failure but nothing with object
access,didnt think if it would matter even if
object acess was enabled...
now...with the given situation...how do I get to this dude?Can someone
enrich my novice knowledge please?SQL server security...what do i look for
and where?
thanks
maverickHi maverick,
Not sure how Sharepoint works with SQL Server in this case but to find
out what people are using on the SQL Server level you should be using
SQL Profiler to capture a trace of all activity carried out against the
SQL Server. Hope this helps.
Jonathan
maverick wrote:
> Not sure if its the right place..but need help cracking this...Just
> inherited a bad place......
> Users access a certain share point site and browse a directory for a host
of
> folders.This afternoon one of the folders was deleted which has loads of
> subfolders(as it is a sharepoint server).....now I need to find out who t
his
> kool dude is!...
>
> What I have now: System state backup of the Machine,SQL full backup and th
e
> backup(SQL and System) just after the files have
> been deleted.
> All I have is just Auditing for success and failure but nothing with objec
t
> access,didnt think if it would matter even if
> object acess was enabled...
> now...with the given situation...how do I get to this dude?Can someone
> enrich my novice knowledge please?SQL server security...what do i look for
> and where?
>
> thanks
> maverick

Maintenance Plans - Restrict users from deleting or editing

Hi,
Is it possible to restrict users that use Enterprise Manager from deleting
maintenance plans? Could anyone please point me to a good URL that talks
about this.
thanks a lot,1) Try placing strict security on the msdb tables related to jobs/plans?
2) Not sure if you can do this but possibly triggers on same tables to check
login and rollback if appropriate.
TheSQLGuru
President
Indicium Resources, Inc.
"Uday" <Uday@.discussions.microsoft.com> wrote in message
news:60A6EF35-0306-428E-993B-04A76B9484B8@.microsoft.com...
> Hi,
> Is it possible to restrict users that use Enterprise Manager from deleting
> maintenance plans? Could anyone please point me to a good URL that talks
> about this.
>
> thanks a lot,
>

Maintenance Plans - Restrict users from deleting or editing

Hi,
Is it possible to restrict users that use Enterprise Manager from deleting
maintenance plans? Could anyone please point me to a good URL that talks
about this.
thanks a lot,
1) Try placing strict security on the msdb tables related to jobs/plans?
2) Not sure if you can do this but possibly triggers on same tables to check
login and rollback if appropriate.
TheSQLGuru
President
Indicium Resources, Inc.
"Uday" <Uday@.discussions.microsoft.com> wrote in message
news:60A6EF35-0306-428E-993B-04A76B9484B8@.microsoft.com...
> Hi,
> Is it possible to restrict users that use Enterprise Manager from deleting
> maintenance plans? Could anyone please point me to a good URL that talks
> about this.
>
> thanks a lot,
>

Maintenance Plans - Restrict users from deleting or editing

Hi,
Is it possible to restrict users that use Enterprise Manager from deleting
maintenance plans? Could anyone please point me to a good URL that talks
about this.
thanks a lot,1) Try placing strict security on the msdb tables related to jobs/plans?
2) Not sure if you can do this but possibly triggers on same tables to check
login and rollback if appropriate.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Uday" <Uday@.discussions.microsoft.com> wrote in message
news:60A6EF35-0306-428E-993B-04A76B9484B8@.microsoft.com...
> Hi,
> Is it possible to restrict users that use Enterprise Manager from deleting
> maintenance plans? Could anyone please point me to a good URL that talks
> about this.
>
> thanks a lot,
>