Viewing 15 posts - 3,091 through 3,105 (of 9,725 total)
ashok_k_ghattamaneni (9/22/2014)
Public Function Divider (ByVal Dividend As Double, ByVal Divisor As Double)
If IsNothing(Divisor) Or Divisor = 0
Return...
September 22, 2014 at 10:38 am
Just because the men volunteer work the odd shifts, doesn't mean their bodies aren't reacting to the stress. It just means they're ignoring it. It's also the product of an...
September 22, 2014 at 6:20 am
Shawn Melton (9/19/2014)
Brandie Tarvin (9/19/2014)
Shawn Melton (9/17/2014)
Grant execute explicitly to that procedure for the login being used.
Odd that granting EXECUTE on the entire schema in Master didn't work, but explicitly...
September 19, 2014 at 10:46 am
Brandie Tarvin (9/19/2014)
Shawn Melton (9/17/2014)
Grant execute explicitly to that procedure for the login being used.
Odd that granting EXECUTE on the entire schema in Master didn't work, but explicitly granting that...
September 19, 2014 at 7:04 am
Shawn Melton (9/17/2014)
Grant execute explicitly to that procedure for the login being used.
Odd that granting EXECUTE on the entire schema in Master didn't work, but explicitly granting that proc did.
Thanks,...
September 19, 2014 at 6:41 am
As long as you have the install files, there's always a way to run repair.
Unfortunately, you're not giving much detail that enables anyone to assist. I know you say the...
September 18, 2014 at 4:43 am
Shawn Melton (9/17/2014)
What query are your trying to execute to get job status?
[linkedserver].master.dbo.xp_sqlagent_enum_jobs
September 17, 2014 at 9:57 am
This sounds like a job for SSIS!
@=)
September 17, 2014 at 9:43 am
Did you check the Event Viewer or just the SQL logs?
September 17, 2014 at 9:41 am
What Greg said, combined with what ZZartin said.
If you want your job to use an Integration Services step to run the package, you need to have IS installed and running...
September 17, 2014 at 9:40 am
Andrei-176105 (9/17/2014)
I have a bunch of servers (2000, 2005,2008,2012) that run bakups to network filer.
All servers (and SQL Agents) run under the same domain account.
This account has full permissions to...
September 17, 2014 at 9:36 am
Steve Jones - SSC Editor (9/10/2014)
Admin stuff fairly similar in most cases. Lots of T-SQL changes. The Inside SQL Server stuff, especially Itzik's Windowing book are great.
Thanks, Steve. I'll look...
September 10, 2014 at 9:49 am
thomashohner (9/10/2014)
I thought the 2008 cert was expired anyway?
After I posted here, I read an article on MSSQL Tips that said no more 2008 certs would be handed out after...
September 10, 2014 at 9:49 am
Wunderbar! I'll take a look.
Thank you.
September 10, 2014 at 5:37 am
Viewing 15 posts - 3,091 through 3,105 (of 9,725 total)