Yep

I have SSMS 2008 on my laptop, managing 2000/2005/2008 boxes

Activity Monitor don't work for 2000 (SSMS 2005 does), but that's more reasons to upgrade 2000. I rely on sp_who2 and...

Just tried with Prometric Canada, for a 70-4XX SQL 2005 exam

says NAM40UP Promotion not found.

Canada IS North America... I wonder why it fails

© 2009 Microsoft Corporation. All rights reserved. NORTH...

It looks certainly possible from Books Online, I am not sure of the exact steps though as I have not done one personally

http://msdn.microsoft.com/en-us/library/ms143393.aspx

SQL Server 2008 Standard1,2

SQL Server 2008 Standard

SQL...

It's irrelevant

but I am just happy if they can call 2008 Enterprise edition the next SQL Server 2011 I'd be happy enough

I care about the features, not so much the...

I think

1. SQL Server 2008 (which includes VS2008 BIDS as well). This should install .Net 3.5 SP1 too

2. Visual Studio 2008 (it would know not to install SQL 2008 Express)

Honestly...

Those questions have been probably asked and answered MANY times here, Google, etc..

My suggestion is (I was in similar shoes, started studying 70-431 and stopped for a year, even when...

Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager

It'll show both SQL Server instances in there, default being 2000 (MSSQLSERVER), the other will...

I don't remember exactly

Could it be that the SQL Server login is default to a DB you don't have access to?

Although I think 'master' is open to 'public' role

I...

Is there an error log?

Read the Books Online

You add it via the Log Shipping Wizard, click on the "Add Seconary Server" button near the bottom of the window

etc.... I suppose...

possible to delete all the SQL Agent jobs as well?

They'll show up with GUID in their names that don't make sense

Try to read the file, if it lists logical names, it's a SQL Native Backup and you can restore from it

RESTORE FILELISTONLY FROM DISK = '\\filepath\filename.bbk'

Books Online

Go to the report on the website Report Manager

click on the "New Subscription" on the top toolbar, then create one with Daily schedule, and Excel format

Look into the db_executor role (search on SSC or Google)

Idea is you create a Database Role

Assign GRANT EXECUTE to that role on all stored procedures (possibly with a TRIGGER so...

+1 for above

You can do the same thing (change owner) to a SQL Agent Job as well

as sometimes it won't run without the "correct" owner who has permission

6 servers is totally doable with DIY solutions 🙂

We have 50+ servers and they use in-house script/jobs with mix of Maint. Plan

I don't know any good free ones, maybe SQLLite...