Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Command(s) completed successfully. only output set parseonly NOT checked Expand / Collapse
Author
Message
Posted Wednesday, March 6, 2013 12:18 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 10:52 AM
Points: 72, Visits: 448
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
Posted Wednesday, March 6, 2013 1:11 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 2:29 PM
Points: 541, Visits: 1,050
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
Posted Wednesday, March 6, 2013 1:55 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 10:52 AM
Points: 72, Visits: 448
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
Posted Wednesday, March 6, 2013 2:31 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 2:29 PM
Points: 541, Visits: 1,050
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
Posted Wednesday, March 6, 2013 2:36 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 10:52 AM
Points: 72, Visits: 448
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
Posted Wednesday, March 6, 2013 3:18 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 2:29 PM
Points: 541, Visits: 1,050
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
Posted Wednesday, March 6, 2013 3:22 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 10:52 AM
Points: 72, Visits: 448
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
Posted Wednesday, March 6, 2013 3:32 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 2:29 PM
Points: 541, Visits: 1,050
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 »

Add to briefcase

Permissions Expand / Collapse