Is it possible to read a transation log?

Is it possible to read a transaction log or can they only be used for
restoration purposes?
thanks in advance
Russ White
rwhite@.cascodev.comYes. There is a third-party product from Lumigent called Log Explorer that
is very good for reading transaction logs. It has a lot of features for
finding transactions and undoing or redoing them.
www.lumigent.com
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Russell White" <rwhite04@.maine.rr.com> wrote in message
news:OdHbKLUgEHA.3676@.TK2MSFTNGP12.phx.gbl...
> Is it possible to read a transaction log or can they only be used for
> restoration purposes?
> thanks in advance
> Russ White
> rwhite@.cascodev.com
>
>

is it better to use Begin-Commit?

Hi All,
is it better to use Begin...Commit in all SP?
does this help preventing deadlocks?
thanks in advance.
joujIt is not that simple. Serializing the access though some objects can in some cases reduce the
likelihood for deadlocks. But it can also have the opposite effect, as locks will be held for a
longer time increasing the risk that two or more operations executes partly concurrently. Also, you
need proper error handling, and not just add begin tran and commit tran, or you will not have the
desired logic. Analyze the requirements for your modifications and code your transactions according
to that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:D0FB6737-8D16-4BF3-9FD9-E640AF51EAC8@.microsoft.com...
> Hi All,
> is it better to use Begin...Commit in all SP?
> does this help preventing deadlocks?
> thanks in advance.
> jouj
>|||Jouj,
Using this, your entire transaction will not be committed until you use
commit tran. It is good to use is sp in error trapping, since if an error
occurred somewhere, you can jump to an Error section and use 'rollback
transactions' command to undo the entire set of transactions.
I have noticed that after you open the transactions, (from begin tran) to
till you close the transactions (Commit or Rollback), update tables are
locked for modifications.
We use this in transactions than need to happen in all or nothing manner.

Is B-Tree the only Index structure within SQL Server 2005 database?

Hi, All,

Is B-Tree the only Index structure used within SQL Server 2005 database?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

Yes, B-trees are the only index structure available. These are used for nonclustered indexes, and for clustered indexes. An unordered "heap" structure is used to store the data in tables with no clustered index.

Thanks,
--R

|||

Hi, Ryan, thanks a lot for your guidance.

With best regards,

Yours sincerely,

Is B-Tree the only Index structure within SQL Server 2005 database?

Hi, All,

Is B-Tree the only Index structure used within SQL Server 2005 database?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

Yes, B-trees are the only index structure available. These are used for nonclustered indexes, and for clustered indexes. An unordered "heap" structure is used to store the data in tables with no clustered index.

Thanks,
--R

|||

Hi, Ryan, thanks a lot for your guidance.

With best regards,

Yours sincerely,