Well, am not sure if foreign key references another table in a different database but as a workaround, you may try the linked server options. By linking 2 DB server,...

use DBCC options to shrink the database.

Check this..but for temp tables

http://www.sql-server-performance.com/nb_avoid_bottlenecks.asp

Hello Folks,

I'm interested to know if someone has cracked it and how did the exam look like. Can a sql 2000 stud come thru this exam ? Thanks...

You may try more other options

- Restart the server, start the sql server via EM

- Look at the services and try starting all sql related services

- Try detach/attach master db.

Hope...

Well, please look at the MS/ articles.

http://support.microsoft.com/kb/239885/en-us

http://www.mcse.ms/archive97-2005-2-1447009.html

http://www.mcse.ms/archive84-2005-8-1781670.html

Just a look up @ eventid.net

See if this helps : http://www.eventid.net/display.asp?eventid=107&source=

-Hth

Take that DB offline.

Move the files to different location.

Detach and then attach using sp pointing to the file location

Hey Andy,

It was simple- straight forward and a top notch article.

Thanks for the same !

Rgds, Arul.

Hello Jyoti,

Look @ :http://www.informit.com/articles/article.asp?p=23574&redir=1

Hello Geetha,

You may have a look at the below articles to enable auditing.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx#EGAA

http://www.databasejournal.com/features/mssql/article.php/3399241

Hope this helps !

Regards, Arul.

The database could be brought online via QA when u get such error message from EM.

Please use the below command within the 'master' DB:

sp_dboption 'pubs','offline','false'

- change the parameter false/true...

Hi there,

u can shrink the db/table to get avail your space.

-A

Will this help you?

exec sp_revokedbaccess 'username'

well...u dont need to have sa rights to run a job.

But u got to use the server service account configured to make sure the jobs are running... It would be...