msg 3721

I tried to run the following in query analyzer:
ALTER TABLE Products_table enable Trigger XXX_ins_upd_trg;
But I got the error message : Server: Msg 3721, Level 16, State 1, Line 1
And I tried to search Microsoft support website for this message and none of
them is relevant to my case. Can anyone please help? Thanks.
Hi,
See if the table name provided is correct.
Thanks
Hari
" 009SteveJobs" <steve@.jobs.com> wrote in message
news:uyEImlEDHHA.4024@.TK2MSFTNGP04.phx.gbl...
>I tried to run the following in query analyzer:
> ALTER TABLE Products_table enable Trigger XXX_ins_upd_trg;
> But I got the error message : Server: Msg 3721, Level 16, State 1, Line 1
> And I tried to search Microsoft support website for this message and none
> of them is relevant to my case. Can anyone please help? Thanks.
>
|||Just checked. It's correct.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:Owr6xIFDHHA.4396@.TK2MSFTNGP02.phx.gbl...
> Hi,
> See if the table name provided is correct.
> Thanks
> Hari
> " 009SteveJobs" <steve@.jobs.com> wrote in message
> news:uyEImlEDHHA.4024@.TK2MSFTNGP04.phx.gbl...
>

msg 3721

I tried to run the following in query analyzer:
ALTER TABLE Products_table enable Trigger XXX_ins_upd_trg;
But I got the error message : Server: Msg 3721, Level 16, State 1, Line 1
And I tried to search Microsoft support website for this message and none of
them is relevant to my case. Can anyone please help? Thanks.Hi,
See if the table name provided is correct.
Thanks
Hari
" 009SteveJobs" <steve@.jobs.com> wrote in message
news:uyEImlEDHHA.4024@.TK2MSFTNGP04.phx.gbl...
>I tried to run the following in query analyzer:
> ALTER TABLE Products_table enable Trigger XXX_ins_upd_trg;
> But I got the error message : Server: Msg 3721, Level 16, State 1, Line 1
> And I tried to search Microsoft support website for this message and none
> of them is relevant to my case. Can anyone please help? Thanks.
>|||Just checked. It's correct.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:Owr6xIFDHHA.4396@.TK2MSFTNGP02.phx.gbl...
> Hi,
> See if the table name provided is correct.
> Thanks
> Hari
> " 009SteveJobs" <steve@.jobs.com> wrote in message
> news:uyEImlEDHHA.4024@.TK2MSFTNGP04.phx.gbl...
>>I tried to run the following in query analyzer:
>> ALTER TABLE Products_table enable Trigger XXX_ins_upd_trg;
>> But I got the error message : Server: Msg 3721, Level 16, State 1, Line 1
>> And I tried to search Microsoft support website for this message and none
>> of them is relevant to my case. Can anyone please help? Thanks.
>>
>|||You didn't post the message text. I looked in SQL Server 2000 sysmessages table and didn't find
error 3721, which makes it very hard for us to suggest something.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
" 009SteveJobs" <steve@.jobs.com> wrote in message news:e88ceZFDHHA.3604@.TK2MSFTNGP03.phx.gbl...
> Just checked. It's correct.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:Owr6xIFDHHA.4396@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> See if the table name provided is correct.
>> Thanks
>> Hari
>> " 009SteveJobs" <steve@.jobs.com> wrote in message news:uyEImlEDHHA.4024@.TK2MSFTNGP04.phx.gbl...
>>I tried to run the following in query analyzer:
>> ALTER TABLE Products_table enable Trigger XXX_ins_upd_trg;
>> But I got the error message : Server: Msg 3721, Level 16, State 1, Line 1
>> And I tried to search Microsoft support website for this message and none of them is relevant to
>> my case. Can anyone please help? Thanks.
>>
>>
>

msg 3721

I tried to run the following in query analyzer:
ALTER TABLE Products_table enable Trigger XXX_ins_upd_trg;
But I got the error message : Server: Msg 3721, Level 16, State 1, Line 1
And I tried to search Microsoft support website for this message and none of
them is relevant to my case. Can anyone please help? Thanks.Hi,
See if the table name provided is correct.
Thanks
Hari
" 009SteveJobs" <steve@.jobs.com> wrote in message
news:uyEImlEDHHA.4024@.TK2MSFTNGP04.phx.gbl...
>I tried to run the following in query analyzer:
> ALTER TABLE Products_table enable Trigger XXX_ins_upd_trg;
> But I got the error message : Server: Msg 3721, Level 16, State 1, Line 1
> And I tried to search Microsoft support website for this message and none
> of them is relevant to my case. Can anyone please help? Thanks.
>|||Just checked. It's correct.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:Owr6xIFDHHA.4396@.TK2MSFTNGP02.phx.gbl...
> Hi,
> See if the table name provided is correct.
> Thanks
> Hari
> " 009SteveJobs" <steve@.jobs.com> wrote in message
> news:uyEImlEDHHA.4024@.TK2MSFTNGP04.phx.gbl...
>|||You didn't post the message text. I looked in SQL Server 2000 sysmessages ta
ble and didn't find
error 3721, which makes it very hard for us to suggest something.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
" 009SteveJobs" <steve@.jobs.com> wrote in message news:e88ceZFDHHA.3604@.TK2MSFTNGP03.phx.gbl
..
> Just checked. It's correct.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:Owr6xIFDHHA.4396@.TK2MSFTNGP02.phx.gbl...
>

MSDTC unable to go online

Hi,
I have a problem starting my MSDTC.
I have enable network DTC access (following the instructions in MS KB
817064) on two of my servers before I clustered them. The DTC services run
well. After that, I configured my servers in cluster Node A and B
(Active/Passive). The DTC immediately failed to start. I carried on and
configured my MSDTC resources (following the instructions in MS KB 301600) on
Node A. The other resources like IP, Physical disk, Network name able to
bring online except for DTC.
What is happening? I have tried my best to follow all instructions as
closely as possible. I seems to be struck. Still have to install SQL 2005
but now spend days to resolve the MSDTC issue. Please kindly help me!
Thanks a lot in advance!
Received error like
MS DTC was unable to start because the installation was not configured to
run on a cluster. Please create a MS DTC resource through cluster
administrator. Error Specifics:
d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetu phelper.cpp:534, Pid: 3192,
CmdLine: C:\WINDOWS\system32\msdtc.exe
Could not start the MS DTC Transaction Manager.
MS DTC Transaction Manager start failed. LogInit returned error 0x3.
Dear Shann Lim,
Have a look at this KB http://support.microsoft.com/kb/867520
and let us know if that solved your problem
good luck,
Edwin.
"Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message
news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...
> Hi,
> I have a problem starting my MSDTC.
> I have enable network DTC access (following the instructions in MS KB
> 817064) on two of my servers before I clustered them. The DTC services
run
> well. After that, I configured my servers in cluster Node A and B
> (Active/Passive). The DTC immediately failed to start. I carried on and
> configured my MSDTC resources (following the instructions in MS KB 301600)
on
> Node A. The other resources like IP, Physical disk, Network name able to
> bring online except for DTC.
> What is happening? I have tried my best to follow all instructions as
> closely as possible. I seems to be struck. Still have to install SQL
2005
> but now spend days to resolve the MSDTC issue. Please kindly help me!
> Thanks a lot in advance!
> Received error like
> MS DTC was unable to start because the installation was not configured to
> run on a cluster. Please create a MS DTC resource through cluster
> administrator. Error Specifics:
> d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetu phelper.cpp:534, Pid:
3192,
> CmdLine: C:\WINDOWS\system32\msdtc.exe
> Could not start the MS DTC Transaction Manager.
> MS DTC Transaction Manager start failed. LogInit returned error 0x3.
>
>
>
>
|||Microsoft has a fix that I have used several times. Free from PSS. Only the web page for version 6 & 7 are not on the net today.
Google shows this though:
Availability of the Windows Server 2003 Post-Service Pack 1 COM+ ...897667 (http://support.microsoft.com/kb/897667/) Availability of Windows Server 2003 Post-Service Pack 1 COM+ 1.5 Hotfix Rollup Package 6 ...
support.microsoft.com/kb/921981 - Similar pages
Could be because SP2 is right around the corner now...
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...
> Hi,
> I have a problem starting my MSDTC.
> I have enable network DTC access (following the instructions in MS KB
> 817064) on two of my servers before I clustered them. The DTC services run
> well. After that, I configured my servers in cluster Node A and B
> (Active/Passive). The DTC immediately failed to start. I carried on and
> configured my MSDTC resources (following the instructions in MS KB 301600) on
> Node A. The other resources like IP, Physical disk, Network name able to
> bring online except for DTC.
> What is happening? I have tried my best to follow all instructions as
> closely as possible. I seems to be struck. Still have to install SQL 2005
> but now spend days to resolve the MSDTC issue. Please kindly help me!
> Thanks a lot in advance!
> Received error like
> MS DTC was unable to start because the installation was not configured to
> run on a cluster. Please create a MS DTC resource through cluster
> administrator. Error Specifics:
> d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetu phelper.cpp:534, Pid: 3192,
> CmdLine: C:\WINDOWS\system32\msdtc.exe
> Could not start the MS DTC Transaction Manager.
> MS DTC Transaction Manager start failed. LogInit returned error 0x3.
>
>
>
>
|||Hi,
I appreciate all the helps.
But may I noe where to d/l the COM+ patch?
Thank you.
"Rodney R. Fournier [MVP]" wrote:
[vbcol=seagreen]
> Microsoft has a fix that I have used several times. Free from PSS. Only the web page for version 6 & 7 are not on the net today.
> Google shows this though:
> Availability of the Windows Server 2003 Post-Service Pack 1 COM+ ...897667 (http://support.microsoft.com/kb/897667/) Availability of Windows Server 2003 Post-Service Pack 1 COM+ 1.5 Hotfix Rollup Package 6 ...
> support.microsoft.com/kb/921981 - Similar pages
>
> Could be because SP2 is right around the corner now...
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...
|||Hi,
Sorry. I think I forgotten to include that I am using Win2k3 SP 1 for my
nodes. THe articles given by Mr Fournier and Mr Mierlo seems to be for
Win2k. Is it applicable for my case?
Thanks again.
"Rodney R. Fournier [MVP]" wrote:
[vbcol=seagreen]
> Microsoft has a fix that I have used several times. Free from PSS. Only the web page for version 6 & 7 are not on the net today.
> Google shows this though:
> Availability of the Windows Server 2003 Post-Service Pack 1 COM+ ...897667 (http://support.microsoft.com/kb/897667/) Availability of Windows Server 2003 Post-Service Pack 1 COM+ 1.5 Hotfix Rollup Package 6 ...
> support.microsoft.com/kb/921981 - Similar pages
>
> Could be because SP2 is right around the corner now...
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...
|||Dear Shann Lim,
http://support.microsoft.com/kb/897667
is for Windows 2003
HTH,
Edwin.
"Shann Lim" <ShannLim@.discussions.microsoft.com> wrote in message
news:D3B191E6-503E-445A-8B0D-20109E5D1E7F@.microsoft.com...[vbcol=seagreen]
> Hi,
> Sorry. I think I forgotten to include that I am using Win2k3 SP 1 for my
> nodes. THe articles given by Mr Fournier and Mr Mierlo seems to be for
> Win2k. Is it applicable for my case?
> Thanks again.
> "Rodney R. Fournier [MVP]" wrote:
the web page for version 6 & 7 are not on the net today.[vbcol=seagreen]
....897667 (http://support.microsoft.com/kb/897667/) Availability of Windows
Server 2003 Post-Service Pack 1 COM+ 1.5 Hotfix Rollup Package 6 ...[vbcol=seagreen]
news:36DA21D5-FF1C-47D7-82EC-585E86597416@.microsoft.com...[vbcol=seagreen]
services run[vbcol=seagreen]
and[vbcol=seagreen]
301600) on[vbcol=seagreen]
to[vbcol=seagreen]
2005[vbcol=seagreen]
to[vbcol=seagreen]
Pid: 3192,[vbcol=seagreen]

MSDTC service not starting

I have to install MSDTC on an Active/Passive cluster. I got instructions
from microsoft's website on how to enable MSDTC:
http://support.microsoft.com/kb/817064/
but when I follow the instructions, the service never starts. Even when I
try to start the service manually I am unsuccessful.
P.S. The cluster is being prepared for use by SQL Server 2005, and the DB
files will be stored on a Dell CX300 (SAN)..
Any suggestions on what may have caused this.
OK I got the service to start, but only after killing the cluster (in cluster
admin). Now while this was great at the time, it does not make much sense.
The reason being that anytime the cluster is present after that, the MSDTC
service stops. The new issue I have is that while configuring the MSDTC, I
was unable to create the "Physical Disk" resource (for the MSDTC Group),
because the wizard is unable to see/recognise any drives at all !!. Now I
really need some suggestions...
Can anyone help? It wil be most appreciated.
"iqv1" wrote:

> I have to install MSDTC on an Active/Passive cluster. I got instructions
> from microsoft's website on how to enable MSDTC:
> http://support.microsoft.com/kb/817064/
> but when I follow the instructions, the service never starts. Even when I
> try to start the service manually I am unsuccessful.
> P.S. The cluster is being prepared for use by SQL Server 2005, and the DB
> files will be stored on a Dell CX300 (SAN)..
> Any suggestions on what may have caused this.
|||Thank you very much for your assistance Edwin...
"Edwin vMierlo [MVP]" wrote:

> First of all, you need to properly configure MSDTC in your cluster.
> Exact instructions here : http://support.microsoft.com/kb/301600
> You do not necessarily have to create a seperate group with a seperate disk
> resource, unless you expect heavy usage of the MSDTC.
> It is acceptable to put your MSDTC in the default cluster group, using the
> Quorum disk.
> If you have problems adding disk to your cluster, you might want to try this
> article : http://support.microsoft.com/kb/555312
> Rgds,
> Edwin.
>
> "iqv1" <iqv1@.discussions.microsoft.com> wrote in message
> news:C6706333-DB5E-42AE-9CE0-0999A127BDE8@.microsoft.com...
> cluster
> sense.
> I
> instructions
> I
> DB
>
>