<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server Newbies
»
Command(s) completed successfully. only...
Command(s) completed successfully. only output set parseonly NOT checked
Rate Topic
Display Mode
Topic Options
Author
Message
pharmkittie
pharmkittie
Posted Wednesday, March 06, 2013 12:18 PM
Grasshopper
Group: General Forum Members
Last Login: Thursday, June 06, 2013 9:53 AM
Points: 23,
Visits: 228
Hello,
I have been trying to solve this for hours. I know it's very likely something really basic but...
When I run a built in stored procedure, for example sp_helppublication, in SSMS, I just see this:
Command(s) completed successfully.
No output. I have checked so many settings. I think I have looked everywhere in the settings for SSMS but maybe not. I definitely don't have the set parseonly checked.
Could someone please help?
Thanks in advance.
Post #1427577
Erin Ramsay
Erin Ramsay
Posted Wednesday, March 06, 2013 1:11 PM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 11:03 AM
Points: 438,
Visits: 808
sp_helppublication will return information on all publications that are owned by the user executing this procedure.
Do you own the publications you're trying to get information on?
Post #1427604
pharmkittie
pharmkittie
Posted Wednesday, March 06, 2013 1:55 PM
Grasshopper
Group: General Forum Members
Last Login: Thursday, June 06, 2013 9:53 AM
Points: 23,
Visits: 228
I am on the Publication Access List (PAL). Thank you for reminding me to check it. I am logged in with a windows user ID with system administrator access. I have never run up against a situation where I didn't have full rights to access anything I wanted.
Thanks for your reply. Is there anything else I should check?
Post #1427621
Erin Ramsay
Erin Ramsay
Posted Wednesday, March 06, 2013 2:31 PM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 11:03 AM
Points: 438,
Visits: 808
The only thing I'd recommend is what I would do.. find someone else that CAN get information about the publication and see what the differences are between my account and theirs.
Post #1427636
pharmkittie
pharmkittie
Posted Wednesday, March 06, 2013 2:36 PM
Grasshopper
Group: General Forum Members
Last Login: Thursday, June 06, 2013 9:53 AM
Points: 23,
Visits: 228
Ok thank you. I tried connecting as sa and still no luck. I have been trouble finding who the owner of the publications is as it doesn't display in properties. I know I created one today with my own windows ID but the others were created probably by sa (I wasn't around). Do you know where I find who the owner of each publication is? I have tried googling but my keywords - find owner of replication publisher - are bringing everything back about replication except that.
Thanks again.
Post #1427641
Erin Ramsay
Erin Ramsay
Posted Wednesday, March 06, 2013 3:18 PM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 11:03 AM
Points: 438,
Visits: 808
I always thought that the Agent Job owner was the owner of the distribution. There's the agent security agent but I'm not sure that's the owner.
Post #1427663
pharmkittie
pharmkittie
Posted Wednesday, March 06, 2013 3:22 PM
Grasshopper
Group: General Forum Members
Last Login: Thursday, June 06, 2013 9:53 AM
Points: 23,
Visits: 228
Thanks Erin. I created my newest publication with my windows account and I think I remember reading that replication should be set up with a SQL login. But, the rest of the publications were not created with a windows login. I will post again when I get this figured out but you were absolutely crucial in pointing me in this direction. Thanks!
Post #1427667
Erin Ramsay
Erin Ramsay
Posted Wednesday, March 06, 2013 3:32 PM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 11:03 AM
Points: 438,
Visits: 808
I neglected to mention that all our replications are set up with a SQL Server login. I think you may be on to something there...
Post #1427670
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
