xp_cmdshell issues

Question

Post reply

xp_cmdshell issues

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 1

IO got lucky... or maybe my Yabingooglewho has gotten a lot better and I found it on the first shot.

http://www.sommarskog.se/grantperm.html

--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)

Emil B SSCertifiable Points: 5568 More actions · Answer 2

Jeff Moden (12/3/2014)
IO got lucky... or maybe my Yabingooglewho has gotten a lot better and I found it on the first shot.
http://www.sommarskog.se/grantperm.html

Hi Jeff,

In my first post on this topic i provided this link :hehe:

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 3

Emil Bialobrzeski (12/4/2014)
Jeff Moden (12/3/2014)
IO got lucky... or maybe my Yabingooglewho has gotten a lot better and I found it on the first shot.
http://www.sommarskog.se/grantperm.html
Hi Jeff,
In my first post on this topic i provided this link :hehe:

Thanks, Emil... I missed that big time.

--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)

schleep SSChampion Points: 12582 More actions · Answer 4

One more question:

Let's assume I go with the certificate method.

Each night, we do database transfers to various target servers, using smo.Transfer.

Does the certificate/permissions granted by the cert travel w/ the DB?

P

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 5

schleep (12/12/2014)
One more question:
Let's assume I go with the certificate method.
Each night, we do database transfers to various target servers, using smo.Transfer.
Does the certificate/permissions granted by the cert travel w/ the DB?
P

Sorry for the late reply. I have no idea when it comes to the certificate method because I don't personally use it.

--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)