reading a transaction log

Does anyone know of a utilty that i can use to open and view the transaction
log file.
one such utility: Log Explorer from Lumigent www.lumigent.com
Keith
"Emil" <laserview@.hotmail.com> wrote in message
news:eUFUu7QaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Does anyone know of a utilty that i can use to open and view the
transaction
> log file.
>
|||Microsoft doesn't provide a tool for reading the transaction log files, but
you might want to look at Lumigent Log Explorer (www.lumigent.com) or Log
P.I. (www.logpi.com).
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Emil" <laserview@.hotmail.com> wrote in message
news:eUFUu7QaEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Does anyone know of a utilty that i can use to open and view the
> transaction
> log file.
>
|||In message <#w9QtDRaEHA.2972@.TK2MSFTNGP12.phx.gbl>, Keith Kratochvil
<sqlguy.back2u@.comcast.net> writes
>one such utility: Log Explorer from Lumigent www.lumigent.com
>
Just for completeness, there are a couple more-
Log PI
(http://www.logpi.com/)
Log Navigator
http://www.apexsql.com/index_lognavigator.htm
Personally I have used Log Explorer quite happily.
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Read only user and not seeing Tables, views etc

I would like to be able to setup a user that can only select information
from a View.
But when I enable security for this user, the user can see all the
tables, Views, Store Proc etc. I know it is only the names, but I don't
want the user to be able to do this, as he is only allowed to view the
view I have enabled for him.
The user can log in using Enterprise Manager and flick through the
tables, views etc, but can't read them, but he can get the names which
is what I don't want to happen.
Is there anyway of stopping the user from seeing all the other
information?
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Hi,
In Enterprise manager you cant control that.
Thanks
Hari
MCDBA
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:ObOG040BEHA.892@.TK2MSFTNGP09.phx.gbl...
> I would like to be able to setup a user that can only select information
> from a View.
> But when I enable security for this user, the user can see all the
> tables, Views, Store Proc etc. I know it is only the names, but I don't
> want the user to be able to do this, as he is only allowed to view the
> view I have enabled for him.
> The user can log in using Enterprise Manager and flick through the
> tables, views etc, but can't read them, but he can get the names which
> is what I don't want to happen.
> Is there anyway of stopping the user from seeing all the other
> information?
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

Read Only permission for ReportingServices.GetPolicies()

I would like for a user to view the groups that have permssion for a
particular folder in SQL Reporting Services that they have access to via the
Web Services by calling ReportingServices.GetPolicies(). I realize
(according to MS's website and trial and error) that the user must have the
"Read Security Policies" right for that folder. The only way I have found
to set this via a Role is to allow "Set security for individual items".
Is there any way to allow a user to only view the security information via
ReportingServices.GetPolicies() without allowing them to change the security
policies?
Any help would be greatly appreciated. Thank you.
Jeremy M. WhiteWell, I found a way to do it, but I'm not really excited about it.
Currently, I am selecting directly from the SQL Reporting services database.
Again, I would prefer to do it through the web services, but I guess this
will suffice. For anyone interested, here is the SQL statement to retrieve
the policy information:
SELECT
U.UserName, U.UserType, R.RoleName, R.Description
FROM
Catalog As C INNER JOIN
PolicyUserRole As PU
ON (C.PolicyID = PU.PolicyID)
INNER JOIN
Roles As R
ON (PU.RoleID = R.RoleID)
INNER JOIN
Users As U
ON (PU.UserID = U.UserID)
WHERE
C.Path = @.ItemName
If anyone is able to determine how to provide read-only access to the
policies via a role, please let me know.
Thanks,
Jeremy
"Jeremy M. White" <jeremy_white@.dart.biz> wrote in message
news:uEkE3mbzEHA.1300@.TK2MSFTNGP14.phx.gbl...
> I would like for a user to view the groups that have permssion for a
> particular folder in SQL Reporting Services that they have access to via
the
> Web Services by calling ReportingServices.GetPolicies(). I realize
> (according to MS's website and trial and error) that the user must have
the
> "Read Security Policies" right for that folder. The only way I have found
> to set this via a Role is to allow "Set security for individual items".
> Is there any way to allow a user to only view the security information via
> ReportingServices.GetPolicies() without allowing them to change the
security
> policies?
> Any help would be greatly appreciated. Thank you.
> Jeremy M. White
>

read from transaction log

Hi,
I have transaction log backup every hour. Is there any way I can view the
transaction log to see what changes are done in past hour? ThanksThere are some third party tools that can read the log. The most
known is log Explorer from lumigent (www.lumigent.com).
Adi
On Feb 5, 9:54 pm, Jen <J...@.discussions.microsoft.com> wrote:
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks|||http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html
Andrew J. Kelly SQL MVP
"Jen" <Jen@.discussions.microsoft.com> wrote in message
news:FC8333C5-00BC-41D7-8CC4-67F71DC5FC48@.microsoft.com...
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks

read from transaction log

Hi,
I have transaction log backup every hour. Is there any way I can view the
transaction log to see what changes are done in past hour? ThanksThere are some third party tools that can read the log. The most
known is log Explorer from lumigent (www.lumigent.com).
Adi
On Feb 5, 9:54 pm, Jen <J...@.discussions.microsoft.com> wrote:
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks|||http://sqlserver2000.databases.aspf...
log-files.html
Andrew J. Kelly SQL MVP
"Jen" <Jen@.discussions.microsoft.com> wrote in message
news:FC8333C5-00BC-41D7-8CC4-67F71DC5FC48@.microsoft.com...
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks

read from transaction log

Hi,
I have transaction log backup every hour. Is there any way I can view the
transaction log to see what changes are done in past hour? Thanks
There are some third party tools that can read the log. The most
known is log Explorer from lumigent (www.lumigent.com).
Adi
On Feb 5, 9:54 pm, Jen <J...@.discussions.microsoft.com> wrote:
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks
|||http://sqlserver2000.databases.aspfaq.com/how-do-i-recover-data-from-sql-server-s-log-files.html
Andrew J. Kelly SQL MVP
"Jen" <Jen@.discussions.microsoft.com> wrote in message
news:FC8333C5-00BC-41D7-8CC4-67F71DC5FC48@.microsoft.com...
> Hi,
> I have transaction log backup every hour. Is there any way I can view the
> transaction log to see what changes are done in past hour? Thanks

re: This recordset is not updatable

Hi all,

I created a form that links to a view. The view joins the two tables and both of these tables are defined w/ Primary keys. But when I try to update the table is giving an error in Access form: "This recordset is not updatable".
Would anyone have an explanation for this?
I'm using AC2K and SQL Server 2K.
Thanks!You can only update columns in the view from one table with one update statement. You can only update columns if you have all of the columns in the declared PK for the table in the view.

-PatP

Re: What is the syntax for isnull in the IIF function in the query statement

Hi all,

What is the syntax for isnull in the IIF function in the query statement for SQL Server2K?

I'm trying to create a view to get a total in a field. If the quantity is null I want to display 0 in that field.

Thanks!!

SELECT dbo.tblShipping_sched.work_ord_num, dbo.tblShipping_sched.work_ord_line_num, IIf(dbo.tblBag_data.bag_quantity IS NULL, 0,
dbo.tblBag_data.bag_quantity) AS qty_on_hand, dbo.tblShipping_sched.cust_num, dbo.tblShipping_sched.cust_name,
dbo.tblShipping_sched.apple_part_num, dbo.tblShipping_sched.apple_catalog_num
FROM dbo.tblShipping_sched LEFT OUTER JOIN
dbo.tblBag_data ON dbo.tblShipping_sched.work_ord_line_num = dbo.tblBag_data.work_ord_line_num AND
dbo.tblShipping_sched.work_ord_num = dbo.tblBag_data.work_ord_num
GROUP BY dbo.tblShipping_sched.work_ord_num, dbo.tblShipping_sched.work_ord_line_num, dbo.tblBag_data.bag_quantity, dbo.tblShipping_sched.cust_num,
dbo.tblShipping_sched.cust_name, dbo.tblShipping_sched.apple_part_num, dbo.tblShipping_sched.apple_catalog_numsql server doesn't support IIF, you have to use CASE

incorrect --

IIf(dbo.tblBag_data.bag_quantity IS NULL, 0, dbo.tblBag_data.bag_quantity)

correct --

case when dbo.tblBag_data.bag_quantity IS NULL then 0 else dbo.tblBag_data.bag_quantity end