John-476812 (2/4/2010)

---

Clearly I am having an ID10T moment. I cannot find the download link to the zip archive ANYWHERE. I have looked all over the article for about...

michael_davis2 (2/4/2010)

---

It is possible to change the limit for the purge of the execution log. Shown in the images for the Diagnostic Reports are the configurations for one of...

Definitely great reports, easy to deploy (unzip, add into VS2008 solution as project, add new Data Source, deploy)

Works on SSRS 2008 (and VS 2008 client)

I deployed them into the same...

sorry to bring up an old thread

I added a trigger on the msdb.dbo.restorehistory to "only print out the restored db name" and it never kicked in after 10 restores, despite...

The timing is great

See this Aaron's blog post about it

http://sqlblog.com/blogs/aaron_bertrand/archive/2010/01/24/decrypting-a-question-of-morals-ethics-or-both.aspx

This runs beautifully with the Central Management Servers

I fixed all maintenance plans and jobs on 20+ servers in 1 run 🙂

--get the owners of the maintenance plans

IF @@VERSION LIKE '%SQL...

SQL database goes through default TCP port 1433 (unless your SQL instance runs on a different port)

Add that to the Windows Firewall and give it a try

It's nice to hear the other side's opinions as I have never been in the hiring position to go through the entire process

The numbers posted (1000 resumes, 30% not even...

I don't think it's an easy task (at least from how normal Windows don't show it easily unless you map the drive, and only TreeSize "Pro" version has this ability)

Why...

I believe this may also work, granting users to the roles in MSDB

http://technet.microsoft.com/en-us/library/ms188283.aspx

SQL Server 2005 introduced the following msdb database fixed database roles, which give administrators finer control over...

Maybe

Schedule it as a SQL Agent job, and email the "operator" the job step details

Don't you just replace ' with '' for your sendmail query parameter?

EXEC msdb.dbo.sp_send_dbmail

@recipients=N'user@domain.com',@body='Here is the count...

Is this a LOCAL or a REMOTE server?

If it's REMOTE, try Remote Desktop and use SSMS locally to see if such problem exists

Any 3rd party plugin for SSMS? like RedGate,...

Did you try a "Test Email" to that user email address?

If other email address work, then it's an invalid user

If no email address work, it's Database Mail setup issue

A lot of filters you see online will

1. ignore DBID <= 4 (exclude system databases)

2. ignore SPID 50

AND @@spid

ORDER BY spid DESC

[/code]

I wouldn't worry too much about it

I am pretty sure it is

In the 70-443 Microsoft Press book, their practices all use Virtual PC as platforms

Much easier to setup for OS, virtual IP, virtual names, and etc..

2008...