error 1105 & 9002

Hi ,
For these 2 error 1105 & 9002 , at what stage will it start to raise the
alert ?
when there's no more disk space or it left for example 200M or 10% ? if
there's a field to be set for the alert to me prompted where can i set it ?
appreciate ur advise
tks & rdgs
Message posted via http://www.droptable.comWhen space is needed for a modification and no space is available. They do n
ot fire in advance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim via droptable.com" <u14644@.uwe> wrote in message news:5fad88d638fcb@.uwe...eagreen">
> Hi ,
> For these 2 error 1105 & 9002 , at what stage will it start to raise the
> alert ?
> when there's no more disk space or it left for example 200M or 10% ? if
> there's a field to be set for the alert to me prompted where can i set it
?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.droptable.com|||Hi
If you want to manage the database size or disc space usage you can add
alerts in Perfmon or use a product such as MOM to monitor the system.
John
"maxzsim via droptable.com" wrote:

> Hi ,
> For these 2 error 1105 & 9002 , at what stage will it start to raise the
> alert ?
> when there's no more disk space or it left for example 200M or 10% ? if
> there's a field to be set for the alert to me prompted where can i set it
?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.droptable.com
>|||tks so much for ur info ppl appreciate it
John Bell wrote:[vbcol=seagreen]
>Hi
>If you want to manage the database size or disc space usage you can add
>alerts in Perfmon or use a product such as MOM to monitor the system.
>John
>
>[quoted text clipped - 7 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200605/1

error 1105 & 9002

Hi ,
For these 2 error 1105 & 9002 , at what stage will it start to raise the
alert ?
when there's no more disk space or it left for example 200M or 10% ? if
there's a field to be set for the alert to me prompted where can i set it ?
appreciate ur advise
tks & rdgs
--
Message posted via http://www.sqlmonster.comWhen space is needed for a modification and no space is available. They do not fire in advance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"maxzsim via SQLMonster.com" <u14644@.uwe> wrote in message news:5fad88d638fcb@.uwe...
> Hi ,
> For these 2 error 1105 & 9002 , at what stage will it start to raise the
> alert ?
> when there's no more disk space or it left for example 200M or 10% ? if
> there's a field to be set for the alert to me prompted where can i set it ?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com|||Hi
If you want to manage the database size or disc space usage you can add
alerts in Perfmon or use a product such as MOM to monitor the system.
John
"maxzsim via SQLMonster.com" wrote:
> Hi ,
> For these 2 error 1105 & 9002 , at what stage will it start to raise the
> alert ?
> when there's no more disk space or it left for example 200M or 10% ? if
> there's a field to be set for the alert to me prompted where can i set it ?
> appreciate ur advise
> tks & rdgs
> --
> Message posted via http://www.sqlmonster.com
>|||tks so much for ur info ppl appreciate it
John Bell wrote:
>Hi
>If you want to manage the database size or disc space usage you can add
>alerts in Perfmon or use a product such as MOM to monitor the system.
>John
>> Hi ,
>[quoted text clipped - 7 lines]
>> tks & rdgs
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1

Error :Execute Trigger From Remote Server To another Server By Linked Server

i did "Linked server" between To Servers , and it's Working.

For Example :

Server 1 =S1.

Server = S2.

i create table in S1 : name = TblS1

i create same table in S2 : name TblS2

and i create trigger(name tr_cpD) From S1 in TblS1 For send data To TblS2 in S2

/****************** trigger Code ***************

CREATE TRIGGER dbo.tr_cpD

ON dbo.TblS1

AFTER INSERT

AS

BEGIN

SET NOCOUNT ON;

insert into [S2].[dbname].[dbo].[TblS2] Select ID,Name from inserted

END

**************************************************

result is :

Msg 7399, Level 16, State 1, Procedure tr_cpD, Line 14

The OLE DB provider "SQLNCLI" for linked server "S2" reported an error. The provider did not give any information about the error.

Msg 7312, Level 16, State 1, Procedure tr_cpD, Line 14

Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked server "S2". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

how i can execute this trigger

Just to clarify: does the insert statement work outside of the trigger from the same S1 server?|||

Yes.

it's Work from Stored Procduers without TRAN (Transaction) .

if i use Transaction From Stored Procduers is not work.

Give me same result above.

|||Is MSDTC enabled on both servers? I think insert from the trigger into a linked server is done inside the distributed transaction.
But I would expect some transaction specific error if it was not so.|||

Microsoft proived some solution, how to overcome this problem. Try it.

http://support.microsoft.com/kb/873160

I tried in the LAN its working fine. But, still in the WAN is not working.

Error :Execute Trigger From Remote Server To another Server By Linked Server

i did "Linked server" between To Servers , and it's Working.

For Example :

Server 1 =S1.

Server = S2.

i create table in S1 : name = TblS1

i create same table in S2 : name TblS2

and i create trigger(name tr_cpD) From S1 in TblS1 For send data To TblS2 in S2

/****************** trigger Code ***************

CREATE TRIGGER dbo.tr_cpD

ON dbo.TblS1

AFTER INSERT

AS

BEGIN

SET NOCOUNT ON;

insert into [S2].[dbname].[dbo].[TblS2] Select ID,Name from inserted

END

**************************************************

result is :

Msg 7399, Level 16, State 1, Procedure tr_cpD, Line 14

The OLE DB provider "SQLNCLI" for linked server "S2" reported an error. The provider did not give any information about the error.

Msg 7312, Level 16, State 1, Procedure tr_cpD, Line 14

Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked server "S2". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

how i can execute this trigger

Just to clarify: does the insert statement work outside of the trigger from the same S1 server?|||

Yes.

it's Work from Stored Procduers without TRAN (Transaction) .

if i use Transaction From Stored Procduers is not work.

Give me same result above.

|||Is MSDTC enabled on both servers? I think insert from the trigger into a linked server is done inside the distributed transaction.
But I would expect some transaction specific error if it was not so.|||

Microsoft proived some solution, how to overcome this problem. Try it.

http://support.microsoft.com/kb/873160

I tried in the LAN its working fine. But, still in the WAN is not working.

ERROR : Unexpected database error (-2147159548) 0x80040e21

When I tried an run my Example of "Reporting services" application for the
first time.I got an error "The report server cannot decrypt the symmetric
key............" for which I found a page dedicated to this problem and
the URL is
"http://support.microsoft.com/kb/842421" and when I tried the 3rd step of
"RSKeyMgmt -r InstallationID" . I received an error
"Unexpected database error (-2147159548) 0x80040e21" and the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>RSKeyMgmt -r f0b56789-7e84-4igh9-ath4-8rhf0c7a1777
Are you sure you want to delete this key (Y/N)? y
"Unexpected database error (-2147159548) 0x80040e21".
Kindly help!!!!!!!!!!Was wondering if you had any luck solving this problem? I've had the same
issue, and have been unable to resolve for the last 2 months.
Thanks
Marvin
"LazyBugger" wrote:
> When I tried an run my Example of "Reporting services" application for the
> first time.I got an error "The report server cannot decrypt the symmetric
> key............" for which I found a page dedicated to this problem and
> the URL is
> "http://support.microsoft.com/kb/842421" and when I tried the 3rd step of
> "RSKeyMgmt -r InstallationID" . I received an error
> "Unexpected database error (-2147159548) 0x80040e21" and the
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>RSKeyMgmt -r f0b56789-7e84-4igh9-ath4-8rhf0c7a1777
> Are you sure you want to delete this key (Y/N)? y
> "Unexpected database error (-2147159548) 0x80040e21".
> Kindly help!!!!!!!!!!
>
>