error defragging index

I received this meesage when trying to defrag an index.
DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38% complete.
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:1191
Expression: 0 == pageFull
SPID: 68
Process ID: 724
Connection Broken
Can anyone tell me what it means?
Thanks,
Dan D.
Looks like a bug or the database has a corrupt page. What SP are you
running?
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:78F2C631-D958-475C-88C4-5C610C8E557F@.microsoft.com...
> I received this meesage when trying to defrag an index.
> DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38% complete.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: pageref.cpp:1191
> Expression: 0 == pageFull
> SPID: 68
> Process ID: 724
> Connection Broken
> Can anyone tell me what it means?
> Thanks,
> --
> Dan D.
|||When I run "select @.@.version" I get:
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Is service pack 4 for windows or Sql Server?
Dan D.
"Paul S Randal [MS]" wrote:

> Looks like a bug or the database has a corrupt page. What SP are you
> running?
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:78F2C631-D958-475C-88C4-5C610C8E557F@.microsoft.com...
>
>
|||You're on SP2 and you've hit a bug that is fixed in SP3. You should upgrade
if possible or contact PSS as there may be a hotfix you can apply to SP2.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:8DAA85A5-072D-4A3F-8E3C-4025D79BD770@.microsoft.com...
> When I run "select @.@.version" I get:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)[vbcol=seagreen]
> Is service pack 4 for windows or Sql Server?
> --
> Dan D.
>
> "Paul S Randal [MS]" wrote:
rights.[vbcol=seagreen]
complete.[vbcol=seagreen]

error defragging index

I received this meesage when trying to defrag an index.
DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38% complete.
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:1191
Expression: 0 == pageFull
SPID: 68
Process ID: 724
Connection Broken
Can anyone tell me what it means?
Thanks,
--
Dan D.Looks like a bug or the database has a corrupt page. What SP are you
running?
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:78F2C631-D958-475C-88C4-5C610C8E557F@.microsoft.com...
> I received this meesage when trying to defrag an index.
> DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38% complete.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: pageref.cpp:1191
> Expression: 0 == pageFull
> SPID: 68
> Process ID: 724
> Connection Broken
> Can anyone tell me what it means?
> Thanks,
> --
> Dan D.|||When I run "select @.@.version" I get:
Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 C
opyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT
5.0 (Build 2195: Service Pack 4)
Is service pack 4 for windows or Sql Server?
--
Dan D.
"Paul S Randal [MS]" wrote:

> Looks like a bug or the database has a corrupt page. What SP are you
> running?
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:78F2C631-D958-475C-88C4-5C610C8E557F@.microsoft.com...
>
>|||You're on SP2 and you've hit a bug that is fixed in SP3. You should upgrade
if possible or contact PSS as there may be a hotfix you can apply to SP2.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:8DAA85A5-072D-4A3F-8E3C-4025D79BD770@.microsoft.com...
> When I run "select @.@.version" I get:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)[vbcol=seagreen]
> Is service pack 4 for windows or Sql Server?
> --
> Dan D.
>
> "Paul S Randal [MS]" wrote:
>
rights.[vbcol=seagreen]
complete.[vbcol=seagreen]

error defragging index

I received this meesage when trying to defrag an index.
DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38% complete.
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:1191
Expression: 0 == pageFull
SPID: 68
Process ID: 724
Connection Broken
Can anyone tell me what it means?
Thanks,
--
Dan D.Looks like a bug or the database has a corrupt page. What SP are you
running?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:78F2C631-D958-475C-88C4-5C610C8E557F@.microsoft.com...
> I received this meesage when trying to defrag an index.
> DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38% complete.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: pageref.cpp:1191
> Expression: 0 == pageFull
> SPID: 68
> Process ID: 724
> Connection Broken
> Can anyone tell me what it means?
> Thanks,
> --
> Dan D.|||You're on SP2 and you've hit a bug that is fixed in SP3. You should upgrade
if possible or contact PSS as there may be a hotfix you can apply to SP2.
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:8DAA85A5-072D-4A3F-8E3C-4025D79BD770@.microsoft.com...
> When I run "select @.@.version" I get:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
> Is service pack 4 for windows or Sql Server?
> --
> Dan D.
>
> "Paul S Randal [MS]" wrote:
> > Looks like a bug or the database has a corrupt page. What SP are you
> > running?
> >
> > --
> > Paul Randal
> > Dev Lead, Microsoft SQL Server Storage Engine
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> > news:78F2C631-D958-475C-88C4-5C610C8E557F@.microsoft.com...
> > > I received this meesage when trying to defrag an index.
> > >
> > > DBCC: Compaction phase of index 'tmxvesta_2.dbo.RNWLWEEK' is 38%
complete.
> > > Server: Msg 3624, Level 20, State 1, Line 1
> > >
> > > Location: pageref.cpp:1191
> > > Expression: 0 == pageFull
> > > SPID: 68
> > > Process ID: 724
> > >
> > > Connection Broken
> > >
> > > Can anyone tell me what it means?
> > >
> > > Thanks,
> > > --
> > > Dan D.
> >
> >
> >sql

Error converting data type varchar to int.

can anyone see as to why I would get this error with the following SP?

ALTER PROCEDURE [dbo].[SP]@.IDint = 0,@.emailFromVARCHAR(50) =Null,@.emailDateVARCHAR(50) =Null,@.emailSubjVARCHAR(50) =Null,@.emailTxtBodyVARCHAR(1000) =Null,@.emailHtmlBodyVARCHAR(1000) =NullAS-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON;DECLARE @.NotesVARCHAR (8000)DECLARE @.TicketIDINTDECLARE @.emailBodyVARCHAR (1000)DECLARE @.LengthIntSET @.Notes =''SET @.Length =LEN(@.emailSubj)-- insert a new entryINSERT INTO PopEmail ( emailFrom, emailDate, emailSubj, emailTxtBody, emailHtmlBody )VALUES ( @.emailFrom, @.emailDate, @.emailSubj, @.emailTxtBody, @.emailHtmlBody )-- get the new IDSET @.ID =@.@.identityIf ( @.ID <> 0 )AND (ISNUMERIC(@.emailSubj) = 1 )BeginIF @.emailTxtBodyISNULLBEGINSet @.emailBody = @.emailHtmlBodyPRINT'@.emailHtmlBody: ' + @.emailBodyENDELSEBEGINSET @.emailBody = @.emailTxtBodyPRINT'@.emailTxtBody: ' + @.emailBodyENDSET @.TicketID =CAST( @.emailSubjAS int )SET @.Notes = @.emailFrom +', ' + @.emailDate +', ' + @.emailBodySelect @.ID = IDFrom TicketDetailsWhere TicketDetails.TicketID = @.TicketIDExec differentSP @.ID, @.TicketID, @.NotesPRINT'Subject: [' + @.emailSubj +']'print'length: ' +CAST(@.Lengthas varchar (10))Print'emailSubj: ' +CAST( @.emailSubjAS int )PRINT'ID: ' +Cast( @.IDas varchar ( 10 ) )PRINT'TicketID: ' +Cast( @.TicketIDAS Varchar ( 10 ) )PRINT'Notes: ' + @.NotesPRINT'ID: ' +Cast( @.IDas varchar ( 10 ) )ENDELSEBEGINPrint'ID: ' +CAST(@.IDAS VarChar(10))PRINT'ISNUMERIC: ' +CAST(ISNUMERIC(@.emailSubj)AS VarChar (10))PRINT'Subject: [' + @.emailSubj +']'END

Which line caused this error? I found at least this line was wrong:

Print'emailSubj: ' +CAST( @.emailSubjAS int )

Should be

Print'emailSubj: ' +CAST( @.emailSubjAS Varchar(10) )

|||

I found that I am just new and prone to making mistakes... The SP that I am calling has several variables that it is looking for, and the @.Notes variable is not until the end of the list. So my call of the SP should look like this:

EXEC someSP @.ID, @.TicketID, , , , , @.Notes.

Now she works... ahhhh the joys of learning.

Thanks,

CK

Error changing SA password

I'm getting the following error when trying to change the
SA password for SQL Server2000 (SP3).
"Error 21776:[SQL_DMO]The name 'dbo' was not found in the
Users collection. If the name is a qualified name, use []
to separate various parts of the name, and try again"
I can't seem to connect under the old or the new
password. Any help would be appreciated.
Thanks
RonAre you a domain admin..? If so connect to SQL via Query Analyser using
Windows Authentication. Then issue the following :-
Examples
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
--
HTH
Ryan Waight, MCDBA, MCSE
"Ron" <rgowdy@.phcs.com> wrote in message
news:18c201c38695$637b2610$a001280a@.phx.gbl...
> I'm getting the following error when trying to change the
> SA password for SQL Server2000 (SP3).
> "Error 21776:[SQL_DMO]The name 'dbo' was not found in the
> Users collection. If the name is a qualified name, use []
> to separate various parts of the name, and try again"
> I can't seem to connect under the old or the new
> password. Any help would be appreciated.
> Thanks
> Ron|||Just to add to Ryan's reply, you can change the password
with Query Analyzer but you will still have the issue of a
dbo being mapped to a non-existant login - that's what
causes the error. You should still update your databases
using sp_changedbowner so that they are owned by logins that
exist on the server.
-Sue
On Mon, 29 Sep 2003 07:24:27 -0700, "Ron" <rgowdy@.phcs.com>
wrote:
>I'm getting the following error when trying to change the
>SA password for SQL Server2000 (SP3).
>"Error 21776:[SQL_DMO]The name 'dbo' was not found in the
>Users collection. If the name is a qualified name, use []
>to separate various parts of the name, and try again"
>I can't seem to connect under the old or the new
>password. Any help would be appreciated.
>Thanks
>Ron|||I believe Sue is on the money here. See the link below
http://www.google.com/groups?selm=utApDPZeDHA.2080%40TK2MSFTNGP12.phx.gbl&oe=UTF-8&output=gplain
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Ron" <rgowdy@.phcs.com> wrote in message
news:18c201c38695$637b2610$a001280a@.phx.gbl...
> I'm getting the following error when trying to change the
> SA password for SQL Server2000 (SP3).
> "Error 21776:[SQL_DMO]The name 'dbo' was not found in the
> Users collection. If the name is a qualified name, use []
> to separate various parts of the name, and try again"
> I can't seem to connect under the old or the new
> password. Any help would be appreciated.
> Thanks
> Ron