Lots of good information so far. Although there seems to me to be two different categories of businesses that categorize 'outages' - NON-MS companies have standards for doing this most...

I would connect to the server using QA and then execute a few things:

• sp_helpdb
• dbcc checkdb(master)
• dbcc checkdb(user_database)

If these tings function correctly I would probably reinstall EM on the client machine.

However of...

Finding a good recruiter is very much like finding a new job. You should be interviewing them just as much as they you, if not more. I say this because...

It is not theft

more like 'object reuse'

Let me see if I am on the same page ... You have written a service application that duplicates, for all intents and purposes, the SQL Agent. If I am...

There is no file created by SQL Server that I am aware of. I would say just delete it. My guess as to the files origin is one of two...

Please do not double post:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=324&messageid=397907

The 'Cloud' ???

No Way Jose !!!

MS already has their fingers into too much already, including our collective wallets. Do you want them to pilfer a...

You could just delete the tempdb mdf and ldf files ... but that opens up another can of worms ... you have to clean out the deleted files folder too...

noeld what were the 'other' conditions that you allude to. I ask because the shop I just came from experienceds a mass logon ever M-F of roughly 500-700users between 7:30...

Slightly incorrect ... if the stored procedure is created in the master database and prefixed sp_ you can execute it in any database ... the databasename sets the execution context (use...

In most instances:

USE databasename

go

exec sp_reindexing_procedure

is equivalent to:

USE master

go

exec databasename..sp_reindexing_procedure

Out of curiosity why do you need to create the same SP in all user databases ? When  a stored procedure prefixed with sp_ in the master database accomplishes the...

Try this abbreviated version Ryan:

SET NOCOUNT ON

USE master

--create "array" of db names

DECLARE for_each_loop CURSOR

FOR SELECT name FROM sysdatabases WHERE name NOT IN ('master', 'model', 'msdb', 'tempdb', 'Northwind', 'AdventureWorks')

OPEN for_each_loop

DECLARE @name...

I believe that anything in tempdb will be on the disk only when SQL Server experiences a dirty shutdown (beter know as crash). If you look at the C: drive...