Viewing 15 posts - 16 through 30 (of 117 total)
Refer http://sqlism.blogspot.com/2014/09/script-to-sync-up-logins-and-database.html
syncup the logins and users
USE DATABASE
GO
EXEC sp_change_users_login 'update_one'
,'databse username'
,'loginname'
GO
September 23, 2014 at 6:08 pm
Thanks everyone for the replies
I found some solution. Thought of sharing
CREATE procedure [dbo].[INS] ...
June 13, 2014 at 11:17 am
Thank you very much for detailed explaination
June 5, 2014 at 9:44 am
My SQL agent on secondary serevr is running on local system , how can i grant SQL agent of Secondary server to have access to MDW database on primary server?
April 17, 2014 at 4:14 pm
I can see them as access denied issues.
On Centralised database(MDW-Primary Server) I can see all jobs running sucessfully, but all jobs on other server(Secondary) where data collection is enabled are...
April 17, 2014 at 1:53 pm
Hi Robert,
Thanks for the reply. I ran the query, I was not able to see any other instance name except the server that MDW is hosted on. Also, my sql...
April 17, 2014 at 1:30 pm
Thanks everyone for sharing the ideas. 🙂
October 24, 2013 at 11:33 am
Currently in our scenario this is nt possible.any other suggestions plz. Thanks fr the reply 🙂
October 23, 2013 at 6:14 pm
Help on this please, I am having similar issue.
October 21, 2013 at 4:02 pm
Thank you Sean and Scott for your replies.
This is the query I am using currently... I created a SP with it and enabled in a job for every hour like...
August 22, 2013 at 5:02 pm
Thanks Hanshi
Your Post helped me
August 20, 2013 at 10:47 am
Thank you! it helped me
August 14, 2013 at 3:42 pm
Got it 🙂
=Format(Avg(Fields!TimeSec.Value, "CycleTime"),"N2") & " Seconds"
August 12, 2013 at 4:17 pm
Viewing 15 posts - 16 through 30 (of 117 total)