Viewing 15 posts - 1,651 through 1,665 (of 9,715 total)
Ed Wagner (6/10/2016)
WayneS (6/10/2016)
Phil Parkin (6/8/2016)
IF COL_LENGTH('dbo.mytable', 'col1') IS NULL
BEGIN
...
June 10, 2016 at 11:34 am
Steve Jones - SSC Editor (6/10/2016)
Brandie Tarvin (6/10/2016)
We're currently using a data warehouse for this. The ETL isn't too nasty, but it took us forever to figure out the best...
June 10, 2016 at 11:32 am
Steve Jones - SSC Editor (6/10/2016)
Steve Thompson-454462 (6/10/2016)
Brandie Tarvin (6/10/2016)
Thanks for the reply.
I wonder... Our reporting team has a database where they essentially flatten all our data into giant tables...
June 10, 2016 at 10:29 am
Steve Thompson-454462 (6/10/2016)
Brandie Tarvin (6/9/2016)
Y.B. (6/9/2016)
I realize...
June 10, 2016 at 8:57 am
And some of us thought the Microsoft certification process was debt-heavy. Glad none of us have to do this.
June 10, 2016 at 8:56 am
ThomasRushton (6/10/2016)
Ed Wagner (6/10/2016)
Brandie Tarvin (6/10/2016)
Wait. Are you talking about you or the OP?I thought you were talking about the OP.
I thought so too. They can be a little...
June 10, 2016 at 6:40 am
ThomasRushton (6/10/2016)
Brandie Tarvin (6/10/2016)
ThomasRushton (6/10/2016)
Am I being unreasonable in now thinking "perhaps you're not the one who should be doing this"?
I'm going to say Yes only because DB Mail is...
June 10, 2016 at 5:07 am
ThomasRushton (6/10/2016)
Am I being unreasonable in now thinking "perhaps you're not the one who should be doing this"?
I'm going to say Yes only because DB Mail is incredibly confusing the...
June 10, 2016 at 4:50 am
naveenareddy.dba (6/9/2016)
i tried this but its giving the error like this
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62
The configuration option 'Database Mail XPs' does not exist, or it...
June 10, 2016 at 4:47 am
naveenareddy.dba (6/10/2016)
yes it is the sql server 2012.
i have done all the things still mail is not sending the status is failed its saying.
i uploaded the screen... please suggest the...
June 10, 2016 at 4:40 am
Y.B. (6/9/2016)
I realize that there are good...
June 9, 2016 at 8:25 am
Ed Wagner (6/8/2016)
Lynn Pettis (6/8/2016)
Won't be surprised if we...
June 9, 2016 at 6:16 am
Ahha! A clue.
The SQL Server Agent Service is running under an application domain account instead of our usual SQL Server Agent Service account for some reason. So I am now...
June 8, 2016 at 12:28 pm
<headdesk>
User asks me to move this bit of code into QA:
ALTER TABLE MyTable
ADD Col1 INT,
Col2 INT
GO
I push back and say "Please add your statement terminator" because...
June 8, 2016 at 12:04 pm
Eric M Russell (6/8/2016)
In MSDB, the following database level roles grant members various levels of permission to do things like monitor or start jobs.SQLAgentUserRole
SQLAgentReaderRole
SQLAgentOperatorRole
https://msdn.microsoft.com/en-us/library/ms188283(v=sql.110).aspx
The testers already had those...
June 8, 2016 at 8:49 am
Viewing 15 posts - 1,651 through 1,665 (of 9,715 total)