SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Command(s) completed successfully. only output set parseonly NOT checked


Command(s) completed successfully. only output set parseonly NOT checked

Author
Message
pharmkittie
pharmkittie
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1223 Visits: 867
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.
Erin Ramsay
Erin Ramsay
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2013 Visits: 1119
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?
pharmkittie
pharmkittie
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1223 Visits: 867
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?
Erin Ramsay
Erin Ramsay
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2013 Visits: 1119
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.
pharmkittie
pharmkittie
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1223 Visits: 867
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.
Erin Ramsay
Erin Ramsay
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2013 Visits: 1119
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.
pharmkittie
pharmkittie
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1223 Visits: 867
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!
Erin Ramsay
Erin Ramsay
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2013 Visits: 1119
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...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search