Viewing 15 posts - 3,076 through 3,090 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 26, 2011 at 7:11 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 26, 2011 at 7:05 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 26, 2011 at 6:58 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 26, 2011 at 6:52 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 26, 2011 at 6:42 am
This is a local machine connection?
What connection types have been enabled? (You can check in the SQL Server Configuration Manager.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 2:22 pm
It recommends looking at previous entries in the error log for more details. Anything there?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 12:33 pm
Is the SQL Server service running on the machine you are trying to connect to?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 12:31 pm
Yeesh, what is this, attack of the copy/pasters?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 11:05 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 11:00 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 9:42 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 9:37 am
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,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 8:43 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 24, 2011 at 6:34 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 21, 2011 at 12:52 pm
Viewing 15 posts - 3,076 through 3,090 (of 14,953 total)