You could do that by having a failure launch a step that would alter the job to stop sending notifications.

Check out sp_update_job for details on how you could do that.

You'd...

Simple inline sub-selects are one way to do it.

select

lastname,

(select sum(offerings)

from dbo.TitheAndOffering

where MemberIdentityID = Members.MemberIdentityID) as TotalOfferings

from dbo.Members;

Just add in sub-selects like that to get...

I really like my current job and employer. When I was interviewing, they were the only one that, after the interview, I felt, "Wow! This'll be a good...

Are you connecting to multiple servers, or just to multiple databases on one server?

If multiple databases on one server, rather than what you're doing, why not just select from sys.databases?

That...

You've got serious "tuple multiplication" inherent in that structure.

Run the final query without the aggregations, you'll see lots of "duplicate" values.

The whole design needs to be rethought. Sorry, that...

This is a local machine connection?

What connection types have been enabled? (You can check in the SQL Server Configuration Manager.)

It recommends looking at previous entries in the error log for more details. Anything there?

Is the SQL Server service running on the machine you are trying to connect to?

Yeesh, what is this, attack of the copy/pasters?

You'd have to do it outside the scope of SQL Server, in the Windows scheduler or some third-party task scheduler.

You can, via the command-line, issue a service-stop for the SQL...

I've run into this before.

Explaining that Top and Order By in views doesn't order the data, it just restricts which rows are returned, has clarified it for a large number...

The symmetric key itself is encrypted with the certificate. That means you don't have to transmit the key in plaintext, which would kind of defeat the purpose of encryption...

There's an article on MSDN on that: http://msdn.microsoft.com/en-us/library/ms190639.aspx

It also contains links to a number of related articles.

There's some data on heaps here: http://msdn.microsoft.com/en-us/library/ms188270.aspx

Since heaps are tables without a clustered index,...

Should we copy-and-paste from this: http://www.sqlservercentral.com/blogs/steve_jones/archive/2010/4/30/plagiarism.aspx

Post exact copies of it on a dozen or more other SQL Server sites, just sign it as if it were our own.

Each of us...

I've tested simultaneous full and log backups, never had a problem with it.

Every night, on my production servers, full backups run at midnight. So do log backups. Every...