error 1203,severity 20, state 1

hi
im getting the below erro
error 1203,severity 20, state
i was running my interest calculation procedures..its a abanking site..and it updates around 1-2 million records.
profiler is showing this error as exception..but when i saw sysprocess ..that spid is runnable and i can see cpu and io values updated.
wot can be the source of error.
thanks
sanjayHi.
On BOOKS ONLINE:
Error 1203
Severity Level 20
Message Text
Process ID %d attempting to unlock unowned resource %.*ls.
Explanation
This error occurs when Microsoft=AE SQL ServerT is engaged in some activity other than normal post-processing cleanup and it finds that a particular page it is attempting to unlock is already unlocked. The underlying cause for this error may be related to structural problems within the affected database. SQL Server manages the acquisition and release of pages to maintain concurrency control in the multi-user environment. This mechanism is maintained through the use of various internal lock structures that identify the page and the type of lock present. Locks are acquired for processing of affected pages and released when the processing is completed.
Action
Execute DBCC CHECKDB against the database in which the object belongs. If DBCC CHECKDB reports no errors, attempt to reestablish the connection and execute the command
>--Original Message--
>hi,
> im getting the below error
> error 1203,severity 20, state 1
>i was running my interest calculation procedures..its a abanking site..and it updates around 1-2 million records..
>profiler is showing this error as exception..but when i saw sysprocess ..that spid is runnable and i can see cpu and io values updated..
>wot can be the source of error..
>thanks >sanjay
>.
>|||thnks for reply..
i tried but same error..

Erro whit J# - Urgent

Hi...Urgent...
The following errors are occurring when we try to give one printing to print in the screen a consultation to the one bank SQL. This site that makes to the consultation this in IIS 6.0 and following errors is occurring. Somebody already saw these errors?
Erro whit J# 2.0 - Exception of type 'java.lang.ExceptionInInitializerError'
was thrown.

Erro whit J# 1.1 - Could not load file or assembly 'vjslib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one
of its dependencies. The system cannot find the file specified.

Hi,

You would need to register all the dependent assemblies J# needs (like vjslib) in the database using CREATE ASSEMBLY statement. You would find these assemblies in your .NET Framework installation folder.

J# is officially not supported by CLR Integration in SQL Server 2005 and that is a reason why you need to register these libraries (as 'unsafe'). When you register an assembly as unsafe, SQL Server does not provide and security or reliability guarantees. Make sure that you adequately test your code for reliability and security.

Thanks,

-Vineet.

|||my erro coms up when i try to send a e-mail, and wont let me send the e-mail..

Erro whit J# - Urgent

Hi...Urgent...
The following errors are occurring when we try to give one printing to print in the screen a consultation to the one bank SQL. This site that makes to the consultation this in IIS 6.0 and following errors is occurring. Somebody already saw these errors?
Erro whit J# 2.0 - Exception of type 'java.lang.ExceptionInInitializerError'
was thrown.

Erro whit J# 1.1 - Could not load file or assembly 'vjslib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one
of its dependencies. The system cannot find the file specified.

Hi,

You would need to register all the dependent assemblies J# needs (like vjslib) in the database using CREATE ASSEMBLY statement. You would find these assemblies in your .NET Framework installation folder.

J# is officially not supported by CLR Integration in SQL Server 2005 and that is a reason why you need to register these libraries (as 'unsafe'). When you register an assembly as unsafe, SQL Server does not provide and security or reliability guarantees. Make sure that you adequately test your code for reliability and security.

Thanks,

-Vineet.

|||my erro coms up when i try to send a e-mail, and wont let me send the e-mail..

Erro whit J# - Urgent

Hi...Urgent...
The following errors are occurring when we try to give one printing to print in the screen a consultation to the one bank SQL. This site that makes to the consultation this in IIS 6.0 and following errors is occurring. Somebody already saw these errors?
Erro whit J# 2.0 - Exception of type 'java.lang.ExceptionInInitializerError'
was thrown.

Erro whit J# 1.1 - Could not load file or assembly 'vjslib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one
of its dependencies. The system cannot find the file specified.

Hi,

You would need to register all the dependent assemblies J# needs (like vjslib) in the database using CREATE ASSEMBLY statement. You would find these assemblies in your .NET Framework installation folder.

J# is officially not supported by CLR Integration in SQL Server 2005 and that is a reason why you need to register these libraries (as 'unsafe'). When you register an assembly as unsafe, SQL Server does not provide and security or reliability guarantees. Make sure that you adequately test your code for reliability and security.

Thanks,

-Vineet.

|||my erro coms up when i try to send a e-mail, and wont let me send the e-mail..

Erro trapping question

I have a batch file that runs SQL Server scripts using commands like:

OSQL -Umyname -Pmypassword -iScript_01.sql -w200 -e -n
>>Consolidation.log

Script_01.sql will contain statements like:
Update SASI.AACT set schoolnum='071' where schoolnum in ('000',' ')
update SASI.AATD set schoolnum='071' where schoolnum in ('000',' ')
update SASI.AATP set schoolnum='071' where schoolnum in ('000',' ')
update SASI.ACHS set schoolnum='071' where schoolnum in ('000',' ')
update SASI.ACLS set schoolnum='071' where schoolnum in ('000',' ')

If one of those tables should not exist, how could I have it continue,
but hopefully the log would have a reference to the error?

I am experimenting, but I am unsuccessfull with something like:
BEGIN TRAN
select count(*) from sasi.aact --this could be an update
statement
if @.@.ERROR =208 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
select count(*) from sasi.astu
if @.@.ERROR <> 0 GOTO err_handle
err_handle:
return
commit Tran<OakRogbak_erPine@.yahoo.com> wrote in message
news:13fdc9b4.0410140645.305d53d3@.posting.google.c om...
>I have a batch file that runs SQL Server scripts using commands like:
> OSQL -Umyname -Pmypassword -iScript_01.sql -w200 -e -n
>>>Consolidation.log
> Script_01.sql will contain statements like:
> Update SASI.AACT set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.AATD set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.AATP set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.ACHS set schoolnum='071' where schoolnum in ('000',' ')
> update SASI.ACLS set schoolnum='071' where schoolnum in ('000',' ')
> If one of those tables should not exist, how could I have it continue,
> but hopefully the log would have a reference to the error?
> I am experimenting, but I am unsuccessfull with something like:
> BEGIN TRAN
> select count(*) from sasi.aact --this could be an update
> statement
> if @.@.ERROR =208 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> select count(*) from sasi.astu
> if @.@.ERROR <> 0 GOTO err_handle
> err_handle:
> return
> commit Tran

Error handling is rather awkward in MSSQL:

http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html

In your case, the easiest thing is probably to avoid the error by checking
if the table exists before trying to query it:

if object_id('sasi.aact') is not null and
objectproperty(object_id('sasi.aact'), 'IsTable') = 1
begin
... -- do something here
end
else
begin
... -- log to an error table
end

Simon

Erro Mssage: tempdb is skipped. You cannot run a query that requires tempdb

While access a view (which is described as following), I encountered the
following error message:
tempdb is skipped. You cannot run a query that requires
tempdb
After I reboot the database, the error goes away.
What cauases this error, and how can I fix it?
Thanks.
-- Charlie Lu
=========================================== View:
SELECT USERTBL.name AS User_Name
,ROLETBL.name AS Role_Name
,RM.Is_Primary
FROM sysusers USERTBL
INNER JOIN sysmembers SM
ON USERTBL.uid = SM.memberuid
INNER JOIN sysusers ROLETBL
ON SM.groupuid = ROLETBL.uid
INNER JOIN ROLE_MAP RM
ON ROLETBL.name = RM.Role_NameI can't get that far to try and reproduce, because I get:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'ROLE_MAP'.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"C. Ming Lu" <cminglu@.qmxs.com> wrote in message
news:eDVWJVdaEHA.556@.tk2msftngp13.phx.gbl...
> While access a view (which is described as following), I encountered the
> following error message:
> tempdb is skipped. You cannot run a query that requires
> tempdb
> After I reboot the database, the error goes away.
> What cauases this error, and how can I fix it?
> Thanks.
> -- Charlie Lu
> ===========================================> View:
> SELECT USERTBL.name AS User_Name
> ,ROLETBL.name AS Role_Name
> ,RM.Is_Primary
> FROM sysusers USERTBL
> INNER JOIN sysmembers SM
> ON USERTBL.uid = SM.memberuid
> INNER JOIN sysusers ROLETBL
> ON SM.groupuid = ROLETBL.uid
> INNER JOIN ROLE_MAP RM
> ON ROLETBL.name = RM.Role_Name
>|||Sorry about the , I cut it out of the view. Role_Map is the user defined
table.
Here is the selection statement.
SELECT USERTBL.name AS User_Name
,ROLETBL.name AS Role_Name
FROM sysusers USERTBL
INNER JOIN sysmembers SM
ON USERTBL.uid = SM.memberuid
INNER JOIN sysusers ROLETBL
ON SM.groupuid = ROLETBL.uid
Regards,
-- C. Ming Lu
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u$$GozdaEHA.2840@.TK2MSFTNGP11.phx.gbl...
> I can't get that far to try and reproduce, because I get:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'ROLE_MAP'.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "C. Ming Lu" <cminglu@.qmxs.com> wrote in message
> news:eDVWJVdaEHA.556@.tk2msftngp13.phx.gbl...
> > While access a view (which is described as following), I encountered the
> > following error message:
> > tempdb is skipped. You cannot run a query that requires
> > tempdb
> > After I reboot the database, the error goes away.
> >
> > What cauases this error, and how can I fix it?
> >
> > Thanks.
> >
> > -- Charlie Lu
> > ===========================================> > View:
> > SELECT USERTBL.name AS User_Name
> > ,ROLETBL.name AS Role_Name
> > ,RM.Is_Primary
> > FROM sysusers USERTBL
> > INNER JOIN sysmembers SM
> > ON USERTBL.uid = SM.memberuid
> > INNER JOIN sysusers ROLETBL
> > ON SM.groupuid = ROLETBL.uid
> > INNER JOIN ROLE_MAP RM
> > ON ROLETBL.name = RM.Role_Name
> >
> >
>

Erro message during import of access DB...

Hello All!
I am getting an error whle I try to import an Access DB into a MSSQL DB.
Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
Overflow. Invalid character value for cast specification.
Now, during the DTS wizard I tried changing the types to smalldate, or
just plain text but neither work.
any thoughts?
thanks!
Luis
Hi
Usually this is caused by incorrect data. You may want to load into a
staging table and make the date column char or validate the data before
loading.
http://groups-beta.google.com/group/...514b83c7397d2c
John
"Anon" wrote:

> Hello All!
> I am getting an error whle I try to import an Access DB into a MSSQL DB.
> Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
> Overflow. Invalid character value for cast specification.
> Now, during the DTS wizard I tried changing the types to smalldate, or
> just plain text but neither work.
> any thoughts?
> thanks!
> Luis
>
|||hmmm. that stinks since we have almost 100k records in this table...mayb
eI can make some sort of update query to these records. Ok, thanks!
Luis
John Bell wrote:[vbcol=seagreen]
> Hi
> Usually this is caused by incorrect data. You may want to load into a
> staging table and make the date column char or validate the data before
> loading.
> http://groups-beta.google.com/group/...514b83c7397d2c
> John
> "Anon" wrote:
>
|||Hi
It may highlight a deficiency in the current application, therefore any
clean up operation would have to be repeated each time you loaded your
SQL server database. Finding out why you have poor data would be
necessary to ensure a smoother transfer in the future. If you loaded
into staging tables your clean-up code could be used when transforming
that data into the live tables, this would mean you are not depending
on the current data source.
100K records is not actually that many, hopefully not all of them are
duff!!
John
Anon wrote:
> hmmm. that stinks since we have almost 100k records in this
table...mayb[vbcol=seagreen]
> eI can make some sort of update query to these records. Ok, thanks!
> Luis
>
> John Bell wrote:
a[vbcol=seagreen]
before[vbcol=seagreen]
http://groups-beta.google.com/group/...514b83c7397d2c[vbcol=seagreen]
MSSQL DB.[vbcol=seagreen]
or[vbcol=seagreen]

Erro message during import of access DB...

Hello All!
I am getting an error whle I try to import an Access DB into a MSSQL DB.
Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
Overflow. Invalid character value for cast specification.
Now, during the DTS wizard I tried changing the types to smalldate, or
just plain text but neither work.
any thoughts?
thanks!
LuisHi
Usually this is caused by incorrect data. You may want to load into a
staging table and make the date column char or validate the data before
loading.
http://groups-beta.google.com/group/comp.databases.ms-sqlserver/msg/c7514b83c7397d2c
John
"Anon" wrote:
> Hello All!
> I am getting an error whle I try to import an Access DB into a MSSQL DB.
> Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
> Overflow. Invalid character value for cast specification.
> Now, during the DTS wizard I tried changing the types to smalldate, or
> just plain text but neither work.
> any thoughts?
> thanks!
> Luis
>|||hmmm. that stinks since we have almost 100k records in this table...mayb
eI can make some sort of update query to these records. Ok, thanks!
Luis
John Bell wrote:
> Hi
> Usually this is caused by incorrect data. You may want to load into a
> staging table and make the date column char or validate the data before
> loading.
> http://groups-beta.google.com/group/comp.databases.ms-sqlserver/msg/c7514b83c7397d2c
> John
> "Anon" wrote:
>
>>Hello All!
>>I am getting an error whle I try to import an Access DB into a MSSQL DB.
>>Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
>>Overflow. Invalid character value for cast specification.
>>Now, during the DTS wizard I tried changing the types to smalldate, or
>>just plain text but neither work.
>>any thoughts?
>>thanks!
>>Luis|||Hi
It may highlight a deficiency in the current application, therefore any
clean up operation would have to be repeated each time you loaded your
SQL server database. Finding out why you have poor data would be
necessary to ensure a smoother transfer in the future. If you loaded
into staging tables your clean-up code could be used when transforming
that data into the live tables, this would mean you are not depending
on the current data source.
100K records is not actually that many, hopefully not all of them are
duff!!
John
Anon wrote:
> hmmm. that stinks since we have almost 100k records in this
table...mayb
> eI can make some sort of update query to these records. Ok, thanks!
> Luis
>
> John Bell wrote:
> > Hi
> >
> > Usually this is caused by incorrect data. You may want to load into
a
> > staging table and make the date column char or validate the data
before
> > loading.
> >
> >
http://groups-beta.google.com/group/comp.databases.ms-sqlserver/msg/c7514b83c7397d2c
> >
> > John
> >
> > "Anon" wrote:
> >
> >
> >>Hello All!
> >>I am getting an error whle I try to import an Access DB into a
MSSQL DB.
> >>
> >>Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
> >>Overflow. Invalid character value for cast specification.
> >>
> >>Now, during the DTS wizard I tried changing the types to smalldate,
or
> >>just plain text but neither work.
> >>
> >>any thoughts?
> >>
> >>thanks!
> >>
> >>Luis
> >>

Erro message during import of access DB...

Hello All!
I am getting an error whle I try to import an Access DB into a MSSQL DB.
Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
Overflow. Invalid character value for cast specification.
Now, during the DTS wizard I tried changing the types to smalldate, or
just plain text but neither work.
any thoughts?
thanks!
LuisHi
Usually this is caused by incorrect data. You may want to load into a
staging table and make the date column char or validate the data before
loading.
http://groups-beta.google.com/group...7397d
2c
John
"Anon" wrote:

> Hello All!
> I am getting an error whle I try to import an Access DB into a MSSQL DB.
> Insert Error, ('DATEBIRTH', DBTYPE_DBTIMESTAMP), status 6; Data
> Overflow. Invalid character value for cast specification.
> Now, during the DTS wizard I tried changing the types to smalldate, or
> just plain text but neither work.
> any thoughts?
> thanks!
> Luis
>|||hmmm. that stinks since we have almost 100k records in this table...mayb
eI can make some sort of update query to these records. Ok, thanks!
Luis
John Bell wrote:[vbcol=seagreen]
> Hi
> Usually this is caused by incorrect data. You may want to load into a
> staging table and make the date column char or validate the data before
> loading.
> http://groups-beta.google.com/group...739
7d2c
> John
> "Anon" wrote:
>|||Hi
It may highlight a deficiency in the current application, therefore any
clean up operation would have to be repeated each time you loaded your
SQL server database. Finding out why you have poor data would be
necessary to ensure a smoother transfer in the future. If you loaded
into staging tables your clean-up code could be used when transforming
that data into the live tables, this would mean you are not depending
on the current data source.
100K records is not actually that many, hopefully not all of them are
duff!!
John
Anon wrote:
> hmmm. that stinks since we have almost 100k records in this
table...mayb[vbcol=seagreen]
> eI can make some sort of update query to these records. Ok, thanks!
> Luis
>
> John Bell wrote:
a[vbcol=seagreen]
before[vbcol=seagreen]
http://groups-beta.google.com/group...7514b83c7397d2c[vbcol=s
eagreen]
MSSQL DB.[vbcol=seagreen]
or[vbcol=seagreen]

Erro install Reportig Service

> Hello,
>
> I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> Standard, but appers error message no log file rsstp.log
>
> InstallBootstrapPackage' Return='2' GetLastError='183
>
> anyone can help me?
> Clayton Cardozo.hi i am having trouble opening my emails it just goes in to error
"Clayton Cardozo" wrote:
> > Hello,
> >
> > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> > Standard, but appers error message no log file rsstp.log
> >
> > InstallBootstrapPackage' Return='2' GetLastError='183
> >
> > anyone can help me?
> > Clayton Cardozo.
>
>|||"Clayton Cardozo" wrote:
> > Hello,
> >
> > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> > Standard, but appers error message no log file rsstp.log
> >
> > InstallBootstrapPackage' Return='2' GetLastError='183
> >
> > anyone can help me?
> > Clayton Cardozo.
> i need help opening my email it has been ok upto now not sure whats happened it just goes in to error everytime i try.
>

erro in reporting

hi friends,

i got one problem with my reporting.

i tried to generate report in asp.net by using xmldataset with the following code

rv_translate.ProcessingMode =ProcessingMode.Local;

rv_translate.LocalReport.ReportPath ="Translate.rdlc";

Microsoft.Reporting.WebForms.ReportDataSource dts =new Microsoft.Reporting.WebForms.ReportDataSource();

dts.Name ="NewDataSet_Table1";

dts.Value = xmldataset.Tables["Table1"];

rv_translate.LocalReport.DataSources.Add(dts);

rv_translate.LocalReport.Refresh();

but it shows error as "

ASP.NET session has expired "

i couldnt fine the reason. and i am new to the asp.net report generation...

please help me

thanks

Try to increase the value of session timeout for that virtual directory.Otherwise Increase the session timeout value for the page where the reportviewer control is placed.

Erro in Internet Explorer

Hi,
I'm new to this Discussion forums.I've a problem in IE.
I've configured my IE and when i'm trying to connect to Internet,i get the
following error.Kindly help me in resolving the issue.
"Internet Explorer could not open the search page".
Any help in this regard would be appreciated.
Regards,
ShyamI do not know if I am in the correct place for help so I apologise if I am.
I have a problem of getting IE to connect to any websites apart from
hotmail. Everytime I put in a web address in the address bar it just comes
back saying application not found. But it will go to websites via the search
bar on msn homepage.Then when I try to go to the home address it wont do it
it stays at whatever website adress is in the address bar and sometimes I
have an error saying something like error unable to close down and about 40
tiled IE blank web pages start up. I have now reinstalled mozilla and that
works ok( i had to download it onto my laptop and transfer it here to the pc
.)
I have noticed that the icon next to a web address on the adress bar and in
my history is like a data icon and when i go into history and click on a web
address it says application not found then it lainches choose application to
open this file and when i choose IE it opens the link. I have also found tha
t
when i go to a website to download anything such as a file from microsoft it
wont let me it says same data not found.
I have tried scf/scannow but it just kept saying please insert the correct
disc. I have xp pro with service pack 2 but it would not read it and I know
the cd rom works correctly I also have a service pack 2 disc that a friend
gave me but that also did not work. I just kept doing cancel and again it
installed some files but not all.
I have also logged on to aother user account to see if IE worked there and
it did not I also created a new user account just in case my one was corrupt
but still had the same issue with IE.
If I do system repair Im going to have same problems as I had once before
with missing files. so I do not want to try that one again.
I have even tried to install a new IE6 but it wont let me it says a previous
installation has pending work requiring a reboot. you need to restart your
computer to complete that installation before running Internet explorer set
up.
I know I could just continue to use firefox but I cannot do windows updates
if I do not have IE. I am completely at a loss what to do now so any help
would be very much appeciated
Edit/Delete Message|||Hi,
may suggest to read following thread :
support.microsoft.com/?kbid=219004
http://www.petri.co.il/forums/showt...10&pp=25&page=3
and
http://www.google.co.in/search?hl=e...ta=lr%3Dlang_en
HTH
Regards
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Hsherriff" wrote:

> I do not know if I am in the correct place for help so I apologise if I am
.
> I have a problem of getting IE to connect to any websites apart from
> hotmail. Everytime I put in a web address in the address bar it just comes
> back saying application not found. But it will go to websites via the sear
ch
> bar on msn homepage.Then when I try to go to the home address it wont do i
t
> it stays at whatever website adress is in the address bar and sometimes I
> have an error saying something like error unable to close down and about 4
0
> tiled IE blank web pages start up. I have now reinstalled mozilla and that
> works ok( i had to download it onto my laptop and transfer it here to the
pc.)
> I have noticed that the icon next to a web address on the adress bar and
in
> my history is like a data icon and when i go into history and click on a w
eb
> address it says application not found then it lainches choose application
to
> open this file and when i choose IE it opens the link. I have also found t
hat
> when i go to a website to download anything such as a file from microsoft
it
> wont let me it says same data not found.
> I have tried scf/scannow but it just kept saying please insert the correct
> disc. I have xp pro with service pack 2 but it would not read it and I kno
w
> the cd rom works correctly I also have a service pack 2 disc that a friend
> gave me but that also did not work. I just kept doing cancel and again it
> installed some files but not all.
> I have also logged on to aother user account to see if IE worked there and
> it did not I also created a new user account just in case my one was corru
pt
> but still had the same issue with IE.
> If I do system repair Im going to have same problems as I had once before
> with missing files. so I do not want to try that one again.
> I have even tried to install a new IE6 but it wont let me it says a previo
us
> installation has pending work requiring a reboot. you need to restart your
> computer to complete that installation before running Internet explorer se
t
> up.
> I know I could just continue to use firefox but I cannot do windows update
s
> if I do not have IE. I am completely at a loss what to do now so any help
> would be very much appeciated
> Edit/Delete Message

Erro 15138

I have this error message while trying to remove a user.
What should I do now?
Msg 15138, Level 16, State 1, Line 2
The database principal owns a schema in the database, and cannot be dropped.
TIA,
GunRemove the schema first (DROP SCHEMA), or change the owner of the schema (ALTER AUTHORIZATION).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gunawan" <jgun98.milis@.gmail.com> wrote in message news:u8M%23kNIXHHA.3948@.TK2MSFTNGP05.phx.gbl...
>I have this error message while trying to remove a user.
> What should I do now?
> Msg 15138, Level 16, State 1, Line 2
> The database principal owns a schema in the database, and cannot be dropped.
> TIA,
> Gun
>

Erro 15138

I have this error message while trying to remove a user.
What should I do now?
Msg 15138, Level 16, State 1, Line 2
The database principal owns a schema in the database, and cannot be dropped.
TIA,
GunRemove the schema first (DROP SCHEMA), or change the owner of the schema (AL
TER AUTHORIZATION).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gunawan" <jgun98.milis@.gmail.com> wrote in message news:u8M%23kNIXHHA.3948@.TK2MSFTNGP05.phx
.gbl...
>I have this error message while trying to remove a user.
> What should I do now?
> Msg 15138, Level 16, State 1, Line 2
> The database principal owns a schema in the database, and cannot be droppe
d.
> TIA,
> Gun
>

Erro 14040: The server "ServerB" is already a Subscriber

Hello.
I'm trying to create a Push subscription from ServerA to ServerB and am
getting the above message. I am using Enterprise Manager to do this.
ServerB already subscribes to a publication from ServerC.
I noticed that the error occurs on the first step of the "Completing the
Push Subscription Wizard", the one labelled "Enabling this server as a
subscriber" (for ServerB). Makes sense since ServerB would have already been
enabled because of the existing subscription to the publication on ServerC.
Is there a way to tell EM not to enable ServerB for subscriptions, or can
ServerB only subscribe to only one other server?
I'm running SQL 2000 SP3a.
Thanks in advance,
Mike
can you do this query and post the results back here?
select sub, srvname from sysservers where srvname='serverb'
Also check to see if ServerB is an enabled Subscriber. If so, uncheck/check
the check box and see if you get an error message.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mike" <MichaelLopez@.inds.com> wrote in message
news:%233Tf5GbaEHA.2408@.tk2msftngp13.phx.gbl...
> Hello.
> I'm trying to create a Push subscription from ServerA to ServerB and am
> getting the above message. I am using Enterprise Manager to do this.
> ServerB already subscribes to a publication from ServerC.
> I noticed that the error occurs on the first step of the "Completing the
> Push Subscription Wizard", the one labelled "Enabling this server as a
> subscriber" (for ServerB). Makes sense since ServerB would have already
been
> enabled because of the existing subscription to the publication on
ServerC.
> Is there a way to tell EM not to enable ServerB for subscriptions, or can
> ServerB only subscribe to only one other server?
> I'm running SQL 2000 SP3a.
> Thanks in advance,
> Mike
>