Can't CHECKDB model

Hello,
When i run DBCC CHECKDB on model, DBBC never end. I try to
backup Model database and the following error appear.
"BAckup, CHECKALLOC, bulk copy, select into, and file
manipulation(such as create file) operations on a database
must be serialized. Reissue the statement after the
current backup, CHECKALLOC or file manipulation is
completed. Backup or Restore operation terminating
abnormally"
I dont know what am i supose to do :\
Best regardsIs the model db backing up right now? Have you backed it up recently?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards|||The error message says it all. There are some operations that cannot be perf
ormed simultaneously for a
database. Make sure you schedule your jobs properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:ebab01c43cf6$af264a00$a3
01280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards

Can't CHECKDB model

Hello,
When i run DBCC CHECKDB on model, DBBC never end. I try to
backup Model database and the following error appear.
"BAckup, CHECKALLOC, bulk copy, select into, and file
manipulation(such as create file) operations on a database
must be serialized. Reissue the statement after the
current backup, CHECKALLOC or file manipulation is
completed. Backup or Restore operation terminating
abnormally"
I dont know what am i supose to do :\
Best regards
Is the model db backing up right now? Have you backed it up recently?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards
|||The error message says it all. There are some operations that cannot be performed simultaneously for a
database. Make sure you schedule your jobs properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards
sql

Can't CHECKDB model

Hello,
When i run DBCC CHECKDB on model, DBBC never end. I try to
backup Model database and the following error appear.
"BAckup, CHECKALLOC, bulk copy, select into, and file
manipulation(such as create file) operations on a database
must be serialized. Reissue the statement after the
current backup, CHECKALLOC or file manipulation is
completed. Backup or Restore operation terminating
abnormally"
I dont know what am i supose to do :\
Best regardsIs the model db backing up right now? Have you backed it up recently?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards|||The error message says it all. There are some operations that cannot be performed simultaneously for a
database. Make sure you schedule your jobs properly.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards

Cant access table due to no owner (I think)

I can't access a number of tables on my SQL Server 7.0 database. Have checked using Enterprise Manager and the table does not appear to have any owner. When trying to do anything with the table I always get the following message

{SQL-DMO} The name 'Table Name' was not found in the tables collection. If the name is a qualified name, use [] to seperate various parts of the name, and the try again.

Have tried to change the owner by using sp_changeobjectowner but I am either getting the syntax wrong or it ain't working.

Any ideas??

c8lWhen you look in Enterprise Manager, what do you see?|||Hi,

The only thing I see is the table name (TABLE1), the type (USER) and the creation date. The owner column is blank. Normally you would expect it to say dbo.|||Blank?

What happends when you run this in QA?

SELECT * FROM INFORMATION_SCHEMA.Tables

Maybe you need to close EM and relaunch it. ...|||Thanks for the help but the problem has been resolved, I had to manually update the sysobject table so that the UID for each of the objects that could not be accessed was set to 1. For some reason this was 6.

Cheers
c8l

CanShrink property

I'm confused about this property. I have a textbox that I want to appear
under certain conditions. If it's not visible, won't it shrink as well if I
set the property? Thanks!Yes.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Wrench" <rwrench@.icsecurity.com> wrote in message
news:%23zZmUD4YEHA.2344@.TK2MSFTNGP11.phx.gbl...
> I'm confused about this property. I have a textbox that I want to appear
> under certain conditions. If it's not visible, won't it shrink as well if
I
> set the property? Thanks!
>|||But it doesn't - why?
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:%23lblCxEZEHA.2480@.tk2msftngp13.phx.gbl...
> Yes.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Richard Wrench" <rwrench@.icsecurity.com> wrote in message
> news:%23zZmUD4YEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > I'm confused about this property. I have a textbox that I want to
appear
> > under certain conditions. If it's not visible, won't it shrink as well
if
> I
> > set the property? Thanks!
> >
> >
>|||To clarify further, if the Hidden property of the textbox is a constant
(say, always true), the textbox won't collapse. On the other hand, if the
Hidden property of the textbox is an expression like following:
=iif(ReportItems!textbox3.Value = "Test", true, false)
then the space occupied by the textbox will be collapsed when the expression
evaluates to true. This is regardless of the CanShrink property.
Note that CanShrink property only applies to height, not width - it
indicates whether the height of a textbox can decrease according to its
content.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Wrench" <rwrench@.icsecurity.com> wrote in message
news:epVsYkSZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> But it doesn't - why?
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:%23lblCxEZEHA.2480@.tk2msftngp13.phx.gbl...
> > Yes.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Richard Wrench" <rwrench@.icsecurity.com> wrote in message
> > news:%23zZmUD4YEHA.2344@.TK2MSFTNGP11.phx.gbl...
> > > I'm confused about this property. I have a textbox that I want to
> appear
> > > under certain conditions. If it's not visible, won't it shrink as well
> if
> > I
> > > set the property? Thanks!
> > >
> > >
> >
> >
>