You can remove access to all databases.  The login would still function, but have no access to any data.

Manager, DBA and programming skill, in NYC, for $60K? 

The way you structure your query can cause SQL to not be able to use an index.  Post your query and you'll get better help.  Also, this thread shouldn't be...

You can select the "Auto Shrink" option in EM database properties, or ask your DBA to do that.  This should get rid of the extra unused space without requiring a...

You don't have to post a question twice.

Responses are here:  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=294968

UNION ALL also does not sort the records in the result set.  You get the results from the first query followed by the results of the second query. 

The individual jobs can send email, but the plan won't send the report.  I'll try resetting the mail settings on the Agent and see if that solves it.

My best fun program was a game called Sword of Aragon, published by SSI, about twenty years ago.  It sold fairly well.  I think I made about $1 per hour. ...

I'd like to write, as well.  I started a novel, but at the rate I'm going, it won't ever get finished.  I'd like to spend 2-3 hours writing every day,...

So more than a month later, I picked up this app again, and within minutes had the solution (found on the net, of course).  The keystroke combination I was looking...

I would have thought that would work.  It complains mightily that table #results doesn't exist.  So, it should work if I can get it to output the result set without...

Thank you, Mark.

We're using SQL 2000 Enterprise, mostly because of the increased RAM handling capability.  (We're running it on a 16GB box, so the entire database fits in RAM.) 

I...

If you're talking about the SQL data disk, step one is to delete the sample databases: pubs and northwind for 2000.  Make sure to delete the data files after you...

It's not as elegant as scraping the screen, but I have set up an LPT1: Print to Text driver.  Still, if anyone else has screen scraping  a solution, please let...

I am using the overloaded version with process info, because redirecting stdout was the first thing I tried.  From the appearance of the output, it looks like it's using direct IO...