Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,326 through 20,340 (of 59,072 total)

RE: xp_cmdshell --> "Access is denied."

rightontarget (6/2/2015)
Thanks Jeff,
2008 server (A) runs under "local system" account
2012 server (B) runs under "qa" account
Do I need to add "local system" to the "administrator" group on server B?
Thanks,
Most of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 4:06 pm

#1805603
RE: Executing SQL Job from SProc

Definitely a puzzle. My apologies. Hopefully, someone else can help on this problem because I'm out of tricks on this one. :blush:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 9:28 am

#1805497
RE: OPENROWSET problem

n.heyen (6/15/2015)
Thanks for the suggestion Jeff. I did find the db owner was changed to me after I refreshed the contents from a backup. (Have to remember to do this...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 9:26 am

#1805495
RE: How do I do a search on a string ( But I need it to be case sensitive )

mw112009 (6/15/2015)
Ann Arbor, MICHIGAN 48105
Drop by if you are closeby
Auburn Hills, MI here. Do you ever go to the PASS meetings in Southfield?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 9:23 am

#1805492
RE: Executing SQL Job from SProc

john.clyma 97764 (6/15/2015)
The .exe is on the same box that is running SQL
Perfect. The other questions would be...
1. Does the exe require any user input after it starts?
2....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 9:12 am

#1805483
RE: Keepinga running total?

jbalbo (6/15/2015)
Yes it would...:)
Sorry, Rainy Monday morning...
Thanks
Heh... not a problem and right there with you. I thought I might be missing something because I answered prior to my...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 9:09 am

#1805482
RE: Executing SQL Job from SProc

Which box is the .exe actually on? The SQL Server box or something else?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 8:59 am

#1805476
RE: Keepinga running total?

Wouldn't a simple COUNT with a GROUP do the trick for you?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 8:58 am

#1805474
RE: How do I do a search on a string ( But I need it to be case sensitive )

mw112009 (6/15/2015)
Thank you that works!
I owe you a beer.
Beer? BEER? [font="Arial Black"]BEER![/font] Heh... ok... where are you at in the world? I might just try to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 8:39 am

#1805467
RE: Five Minute Refactoring

I don't argue with people about things in code. I let the code do the talking. If they come up with better code (performs better, more scalable, easier...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 8:26 am

#1805459
RE: How do I do a search on a string ( But I need it to be case sensitive )

mw112009 (6/15/2015)
Select * FROM TAB1 wher AI_TEXT_VALUE like '%PE%'
The unfortunate thing is i get entries like <Perennial allergic rhinitis>
I am looking specifically for the term PE ( All...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 8:16 am

#1805457
RE: Moving large databases from SQL Server 2005 to 2008

Jacob Wilkins (6/15/2015)
You can mirror from an older version to a newer version (like 2005->2008), but it's a one way trip. You can fail over to the 2008 instance, but...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 7:28 am

#1805444
RE: Are the posted questions getting worse?

Ed Wagner (6/15/2015)
BrainDonor (6/15/2015)
For those that have an interest in martial arts - specifically the Katana.
An intersting video of Machii Isao, assisting in the configuration of an industrial robot, so...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 6:48 am

#1805432
RE: Are the posted questions getting worse?

BWFC (6/15/2015)
Something similar to this Jeff?
Heh... That's the very scene I think of in all such conversations. It's one of my favorites. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 6:39 am

#1805430
RE: Are the posted questions getting worse?

BrainDonor (6/15/2015)
For those that have an interest in martial arts - specifically the Katana.
An intersting video of Machii Isao, assisting in the configuration of an industrial robot, so it can...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 15, 2015 at 6:17 am

#1805426

Viewing 15 posts - 20,326 through 20,340 (of 59,072 total)