detach db failed due to ghost cleanup

hi
i'm trying to detach a database. However i cant as the db is in use. I can
kill any user processes but not the non-user process 'ghost cleanup'. Because
of this the db is in use and the detach cannot occur.
I realise what the process 'ghost cleanup' is there for - but surely it
shouldn't be in use permanently? (db options such as shrink db are not set on
this db). There any safe way to disable?
Try putting the database in single user mode by using the ALTER DATABSE with
SET SINGLE_USER mode option and then try detaching.
"Dunxz" wrote:

> hi
> i'm trying to detach a database. However i cant as the db is in use. I can
> kill any user processes but not the non-user process 'ghost cleanup'. Because
> of this the db is in use and the detach cannot occur.
> I realise what the process 'ghost cleanup' is there for - but surely it
> shouldn't be in use permanently? (db options such as shrink db are not set on
> this db). There any safe way to disable?
>
|||Thanks
"Pragya" wrote:
[vbcol=seagreen]
> Try putting the database in single user mode by using the ALTER DATABSE with
> SET SINGLE_USER mode option and then try detaching.
>
> "Dunxz" wrote:

detach db failed due to ghost cleanup

hi
i'm trying to detach a database. However i cant as the db is in use. I can
kill any user processes but not the non-user process 'ghost cleanup'. Becaus
e
of this the db is in use and the detach cannot occur.
I realise what the process 'ghost cleanup' is there for - but surely it
shouldn't be in use permanently? (db options such as shrink db are not set o
n
this db). There any safe way to disable'Try putting the database in single user mode by using the ALTER DATABSE with
SET SINGLE_USER mode option and then try detaching.
"Dunxz" wrote:

> hi
> i'm trying to detach a database. However i cant as the db is in use. I can
> kill any user processes but not the non-user process 'ghost cleanup'. Beca
use
> of this the db is in use and the detach cannot occur.
> I realise what the process 'ghost cleanup' is there for - but surely it
> shouldn't be in use permanently? (db options such as shrink db are not set
on
> this db). There any safe way to disable'
>|||Thanks
"Pragya" wrote:
[vbcol=seagreen]
> Try putting the database in single user mode by using the ALTER DATABSE wi
th
> SET SINGLE_USER mode option and then try detaching.
>
> "Dunxz" wrote:
>

detach db failed due to ghost cleanup

hi
i'm trying to detach a database. However i cant as the db is in use. I can
kill any user processes but not the non-user process 'ghost cleanup'. Because
of this the db is in use and the detach cannot occur.
I realise what the process 'ghost cleanup' is there for - but surely it
shouldn't be in use permanently? (db options such as shrink db are not set on
this db). There any safe way to disable'Try putting the database in single user mode by using the ALTER DATABSE with
SET SINGLE_USER mode option and then try detaching.
"Dunxz" wrote:
> hi
> i'm trying to detach a database. However i cant as the db is in use. I can
> kill any user processes but not the non-user process 'ghost cleanup'. Because
> of this the db is in use and the detach cannot occur.
> I realise what the process 'ghost cleanup' is there for - but surely it
> shouldn't be in use permanently? (db options such as shrink db are not set on
> this db). There any safe way to disable'
>|||Thanks
"Pragya" wrote:
> Try putting the database in single user mode by using the ALTER DATABSE with
> SET SINGLE_USER mode option and then try detaching.
>
> "Dunxz" wrote:
> > hi
> >
> > i'm trying to detach a database. However i cant as the db is in use. I can
> > kill any user processes but not the non-user process 'ghost cleanup'. Because
> > of this the db is in use and the detach cannot occur.
> >
> > I realise what the process 'ghost cleanup' is there for - but surely it
> > shouldn't be in use permanently? (db options such as shrink db are not set on
> > this db). There any safe way to disable'
> >
> >

design help

hey all,
you know in an invoice sometimes you have past due amounts and credited
amounts. are these items normally stored or are they calculated on the fly?
thanks,
rodcharThose two are quite a bit different, and the answer is "it depends". What
are you trying to do with them?
MeanOldDBA
derrickleggett@.hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"rodchar" wrote:

> hey all,
> you know in an invoice sometimes you have past due amounts and credited
> amounts. are these items normally stored or are they calculated on the fly
?
> thanks,
> rodchar|||i'm just trying the best way to make them appear on an invoice.
"MeanOldDBA" wrote:
> Those two are quite a bit different, and the answer is "it depends". What
> are you trying to do with them?
>
> --
> MeanOldDBA
> derrickleggett@.hotmail.com
> http://weblogs.sqlteam.com/derrickl
> When life gives you a lemon, fire the DBA.
>
> "rodchar" wrote:
>

design help

hey all,
can someone please help me design the following:
9/29/05 Cut Lawn $20
Date of Service Service Type Price Payment Due Trans Type Payment
Amount Payment Date
9/29/05 Cut Lawn $20 10/29/05 Bill
9/29/05 Cut Lawn $20 10/29/05 Payment $10 10/1/2005
9/29/05 Cut Lawn $20 10/29/05 Payment $15 10/14/2005
Here's what I have so far:
Customer table
Invoice
InvoiceDetails
And here's where I need some help
Would I need a payment table? if so, how would it link to the invoice?
Also, where and how would you keep track of past due amounts and customers
who pay more than the amount billed?
thanks,
ariStart here:
http://www.databaseanswers.org/data...oices/index.htm
-oj
"ari" <ari@.discussions.microsoft.com> wrote in message
news:40BCFA96-97FC-432E-B7E8-19F78FDA7D53@.microsoft.com...
> hey all,
> can someone please help me design the following:
> 9/29/05 Cut Lawn $20
> Date of Service Service Type Price Payment Due Trans Type Payment
> Amount Payment Date
> 9/29/05 Cut Lawn $20 10/29/05 Bill
> 9/29/05 Cut Lawn $20 10/29/05 Payment $10 10/1/2005
> 9/29/05 Cut Lawn $20 10/29/05 Payment $15 10/14/2005
> Here's what I have so far:
> Customer table
> Invoice
> InvoiceDetails
> And here's where I need some help
> Would I need a payment table? if so, how would it link to the invoice?
> Also, where and how would you keep track of past due amounts and customers
> who pay more than the amount billed?
> thanks,
> ari|||Awesome.
Thanks,
ari
"oj" wrote:

> Start here:
> [url]http://www.databaseanswers.org/data_models/customers_and_invoices/index.htm[/url
]
> --
> -oj
>
> "ari" <ari@.discussions.microsoft.com> wrote in message
> news:40BCFA96-97FC-432E-B7E8-19F78FDA7D53@.microsoft.com...
>
>