Componente Services + win xp sp2

Hi.
I've intalled windows xp service pack 2, since there I cant' view Component
Services -> Transaction Statistics from a remote server.
I'm not using XP Firewall.
Any ideia?
Thanks
EsioI found the problem...
RPC changed.
http://msdn.microsoft.com/security/productinfo/XPSP2/networkprotection/restrict_remote_clients.aspx
Esio
"Esio Nunes" <esio_nunes@.hotmail.com> escreveu na mensagem
news:uznYoqk%23EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Hi.
> I've intalled windows xp service pack 2, since there I cant' view
> Component Services -> Transaction Statistics from a remote server.
> I'm not using XP Firewall.
> Any ideia?
> Thanks
> Esio
>

Componente Services + win xp sp2

Hi.
I've intalled Windows XP service pack 2, since there I cant' view Component
Services -> Transaction Statistics from a remote server.
I'm not using XP Firewall.
Any ideia?
Thanks
EsioI found the problem...
RPC changed.
http://msdn.microsoft.com/security/...te_clients.aspx
Esio
"Esio Nunes" <esio_nunes@.hotmail.com> escreveu na mensagem
news:uznYoqk%23EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Hi.
> I've intalled Windows XP service pack 2, since there I cant' view
> Component Services -> Transaction Statistics from a remote server.
> I'm not using XP Firewall.
> Any ideia?
> Thanks
> Esio
>

Completed(?) and urgent Triggers and Transactions question

I use the VB.NET transaction to update an sql server 2000 database. I call a number of stored procedures within this transaction.

The stored procedures will update tables. These tables use triggers..

My question is, when does the trigger get called? Is it after the each stored procedure, or is it after the whole transaction?

Jag

the trigger will execute when

- new records is being inserted into the table

- records get update

- records get deleted

from the table

|||

In my opinion triggers fire as soon as the database updated, and transaction update your table as soon as a query fires. Having triggers do too much is a typical mistake. Triggers should be
left to handle only simple tasks.

cheers

|||

How would you define too much?

At the moment, one of my trigger calls a stored procedure that is doing about 4 selects on a table (one with an MAX()), and maybe a 2 updates.

The stored procedure should be optimised, so it should case too much problems later (?)

EDIT: I am expecting the number of selects to increase to about 10, and the number of updates to 3. The selects will be small selects that mostly pull out ids.

Jag

|||

Hi,

The trigger will be fired immediately after the the update was executed. And the transaction will continue after trigger gets executed.

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

|||

What I was afraid of was that the triggers would not get fired during the transaction, and would be fired after the commit. But after a little testing, I found this was not true.

I am still trying to find out how much I can put into a trigger before a performance becomes an issue. I am not expecting heavy usage - I'm not even expecting moderate usage on the site. Maybe about 10 inputs/edits a day, that's it.

I have written a stored procedure and the trigger calls this if needed. The stored procedure will have upto 20 select statements to pull out values from the database, and then a couple of updates. Is this too much? I don't see it being too much as I am not expecting too much input to be going on.

Jag

|||

Just another quick question.

Same example - there is a transaction with a number of updates/inserts. The tables these apply to have triggers on then. The triggers are fired as soon as the update/insert happens, and not at the end of the transaction.

My question is, if the transaction fails and the changes are reversed, will the changes made by the triggers also be reversed. Common sense says that it should happen, but I need to ensure that it does.

Thanks in advance

Jag

Complete, Differential, Transaction Log -- More backup questions

Greetings all,
I am new to this Newsgroup, so forgive me if my question seems stupid.
We currently have a payroll system that runs on SQL Server 2000. We are
doing a full backup (to a local hard disk) every night of the main database,
which is about 55GB and then sending the SQL Backup off to tape. We can keep
2, maybe 3 days backup online, but space is getting tight.
I have suggested that we do 1 complete backup at the beginning of the
week, then a Differential backup every night, and a transaction log backup
every couple of hours during the day.
My question for you people. If I do the complete backup on Sunday
night, a differential on Monday and Tuesday night, and a couple of
Transaction Log backups on Wednesday, and the System crashes late Wednesday
do I have to restore both Mon and Tue differential and all the Wed
Transaction Logs and restoring the complete from Sun, or can I just restore
the Sun complete, the Tue night differential and the last Transaction Log
from Wed?
I think my actual question is: "Is the Differential backup all the
differences from the last complete or the last Differential, and does the
Transaction Log backup get everything from the last Differential?"
Thanks much
Raymond Fantasia
Fry''s Electronics
ISD DepartmentHi
answered in microsoft.public.sqlserver.newusers
Please do not multi-post as it is harder to know if the question has been
answered yet.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ray Fantasia" <RayFantasia@.discussions.microsoft.com> wrote in message
news:A8241F2A-6630-4B96-A9A0-2CB30BEEA7E9@.microsoft.com...
> Greetings all,
> I am new to this Newsgroup, so forgive me if my question seems stupid.
> We currently have a payroll system that runs on SQL Server 2000. We are
> doing a full backup (to a local hard disk) every night of the main
> database,
> which is about 55GB and then sending the SQL Backup off to tape. We can
> keep
> 2, maybe 3 days backup online, but space is getting tight.
> I have suggested that we do 1 complete backup at the beginning of the
> week, then a Differential backup every night, and a transaction log backup
> every couple of hours during the day.
> My question for you people. If I do the complete backup on Sunday
> night, a differential on Monday and Tuesday night, and a couple of
> Transaction Log backups on Wednesday, and the System crashes late
> Wednesday
> do I have to restore both Mon and Tue differential and all the Wed
> Transaction Logs and restoring the complete from Sun, or can I just
> restore
> the Sun complete, the Tue night differential and the last Transaction Log
> from Wed?
> I think my actual question is: "Is the Differential backup all the
> differences from the last complete or the last Differential, and does the
> Transaction Log backup get everything from the last Differential?"
> Thanks much
> Raymond Fantasia
> Fry''s Electronics
> ISD Department

Complete, Differential, Transaction Log -- More backup questions

Greetings all,
I am new to this Newsgroup, so forgive me if my question seems stupid.
We currently have a payroll system that runs on SQL Server 2000. We are
doing a full backup (to a local hard disk) every night of the main database,
which is about 55GB and then sending the SQL Backup off to tape. We can kee
p
2, maybe 3 days backup online, but space is getting tight.
I have suggested that we do 1 complete backup at the beginning of the
week, then a Differential backup every night, and a transaction log backup
every couple of hours during the day.
My question for you people. If I do the complete backup on Sunday
night, a differential on Monday and Tuesday night, and a couple of
Transaction Log backups on Wednesday, and the System crashes late Wednesday
do I have to restore both Mon and Tue differential and all the Wed
Transaction Logs and restoring the complete from Sun, or can I just restore
the Sun complete, the Tue night differential and the last Transaction Log
from Wed?
I think my actual question is: "Is the Differential backup all the
differences from the last complete or the last Differential, and does the
Transaction Log backup get everything from the last Differential?"
Thanks much
Raymond Fantasia
Fry''s Electronics
ISD DepartmentHi
answered in microsoft.public.sqlserver.newusers
Please do not multi-post as it is harder to know if the question has been
answered yet.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ray Fantasia" <RayFantasia@.discussions.microsoft.com> wrote in message
news:A8241F2A-6630-4B96-A9A0-2CB30BEEA7E9@.microsoft.com...
> Greetings all,
> I am new to this Newsgroup, so forgive me if my question seems stupid.
> We currently have a payroll system that runs on SQL Server 2000. We are
> doing a full backup (to a local hard disk) every night of the main
> database,
> which is about 55GB and then sending the SQL Backup off to tape. We can
> keep
> 2, maybe 3 days backup online, but space is getting tight.
> I have suggested that we do 1 complete backup at the beginning of the
> week, then a Differential backup every night, and a transaction log backup
> every couple of hours during the day.
> My question for you people. If I do the complete backup on Sunday
> night, a differential on Monday and Tuesday night, and a couple of
> Transaction Log backups on Wednesday, and the System crashes late
> Wednesday
> do I have to restore both Mon and Tue differential and all the Wed
> Transaction Logs and restoring the complete from Sun, or can I just
> restore
> the Sun complete, the Tue night differential and the last Transaction Log
> from Wed?
> I think my actual question is: "Is the Differential backup all the
> differences from the last complete or the last Differential, and does the
> Transaction Log backup get everything from the last Differential?"
> Thanks much
> Raymond Fantasia
> Fry''s Electronics
> ISD Department

Complete, Differential, Transaction Log -- More backup questions

Greetings all,
I am new to this Newsgroup, so forgive me if my question seems stupid.
We currently have a payroll system that runs on SQL Server 2000. We are
doing a full backup (to a local hard disk) every night of the main database,
which is about 55GB and then sending the SQL Backup off to tape. We can keep
2, maybe 3 days backup online, but space is getting tight.
I have suggested that we do 1 complete backup at the beginning of the
week, then a Differential backup every night, and a transaction log backup
every couple of hours during the day.
My question for you people. If I do the complete backup on Sunday
night, a differential on Monday and Tuesday night, and a couple of
Transaction Log backups on Wednesday, and the System crashes late Wednesday
do I have to restore both Mon and Tue differential and all the Wed
Transaction Logs and restoring the complete from Sun, or can I just restore
the Sun complete, the Tue night differential and the last Transaction Log
from Wed?
I think my actual question is: "Is the Differential backup all the
differences from the last complete or the last Differential, and does the
Transaction Log backup get everything from the last Differential?"
Thanks much
Raymond Fantasia
Fry''s Electronics
ISD Department
Hi
answered in microsoft.public.sqlserver.newusers
Please do not multi-post as it is harder to know if the question has been
answered yet.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ray Fantasia" <RayFantasia@.discussions.microsoft.com> wrote in message
news:A8241F2A-6630-4B96-A9A0-2CB30BEEA7E9@.microsoft.com...
> Greetings all,
> I am new to this Newsgroup, so forgive me if my question seems stupid.
> We currently have a payroll system that runs on SQL Server 2000. We are
> doing a full backup (to a local hard disk) every night of the main
> database,
> which is about 55GB and then sending the SQL Backup off to tape. We can
> keep
> 2, maybe 3 days backup online, but space is getting tight.
> I have suggested that we do 1 complete backup at the beginning of the
> week, then a Differential backup every night, and a transaction log backup
> every couple of hours during the day.
> My question for you people. If I do the complete backup on Sunday
> night, a differential on Monday and Tuesday night, and a couple of
> Transaction Log backups on Wednesday, and the System crashes late
> Wednesday
> do I have to restore both Mon and Tue differential and all the Wed
> Transaction Logs and restoring the complete from Sun, or can I just
> restore
> the Sun complete, the Tue night differential and the last Transaction Log
> from Wed?
> I think my actual question is: "Is the Differential backup all the
> differences from the last complete or the last Differential, and does the
> Transaction Log backup get everything from the last Differential?"
> Thanks much
> Raymond Fantasia
> Fry''s Electronics
> ISD Department