http://blogs.msdn.com/gp/archive/2009/06/27/week-3-did-you-know-series-of-the-week.aspx
Check out the MS GP Community Site for lots more great info!
About Me
Search My Blogs
Monday, June 29, 2009
Wednesday, June 17, 2009
Thursday, May 21, 2009
Leaving Feedback for Dynamics Great Plains
How do I leave feedback for Dynamics GP? Check this article out:
http://blogs.msdn.com/gp/archive/2009/05/19/ever-wonder-where-your-product-feedback-goes.aspx
http://blogs.msdn.com/gp/archive/2009/05/19/ever-wonder-where-your-product-feedback-goes.aspx
Thursday, April 16, 2009
List Windows Groups Membership from SQL
Ever wanted to see who was in a windows group?
As a SQL DBA, I used to be able to see this kind of information using SQL 2000, but that part of the GUI got left behind in SQL 2005/2008, however, there is a stored procedure that you can use to see this information:
xp_logininfo 'BUILTIN\Administrators', 'members'
This lists all the users who belong to a given group, in this example, it lists the members of the Administrators group, good stuff to know if you need to know just who can administer the SQL box that your Dynamics GP / Great Plains is running on!
As a SQL DBA, I used to be able to see this kind of information using SQL 2000, but that part of the GUI got left behind in SQL 2005/2008, however, there is a stored procedure that you can use to see this information:
xp_logininfo 'BUILTIN\Administrators', 'members'
This lists all the users who belong to a given group, in this example, it lists the members of the Administrators group, good stuff to know if you need to know just who can administer the SQL box that your Dynamics GP / Great Plains is running on!
Thursday, April 2, 2009
Can't Login After Moving Databases to New Server
If you ever move your Great Plains databases from one server to another, make sure you do the following:
use master
go
GRANT EXEC ON smDEX_Max_Char TO PUBLIC
GRANT EXEC ON smDEX_Build_Locks TO PUBLIC
I've been burned more than once by forgetting these. Without them, you can't login and you'll pull your hair out because everything looks right (and indeed is right!) security setup-wise.
Having trouble logging in after a server move? Try this and see if it helps!
use master
go
GRANT EXEC ON smDEX_Max_Char TO PUBLIC
GRANT EXEC ON smDEX_Build_Locks TO PUBLIC
I've been burned more than once by forgetting these. Without them, you can't login and you'll pull your hair out because everything looks right (and indeed is right!) security setup-wise.
Having trouble logging in after a server move? Try this and see if it helps!
SharePointSaturday in DC on May 2nd - FREE Event!
For all you local SharePoint guys and gals out there!
http://www.sharepointsaturday.org/dc/Pages/about.aspx
http://www.sharepointsaturday.org/dc/Pages/about.aspx
Wednesday, March 25, 2009
FREE Microsoft TechDays Live 24 Hour Virtual Event - It's FREE!
Not exactly a Great Plains specific event, but definitely something for Microsoft Developer's to check out:
https://www.msfttechdays.com/public/home.aspx
TechDays is a free, one day (24 hour), live virtual conference/event. It's on the web, so its in your region! Sign up and build your schedule already. Don't worry, you don't have to attend the whole 24 hours (except you hard core devs, you know who you are). Did I mention that it's free?
https://www.msfttechdays.com/public/home.aspx
TechDays is a free, one day (24 hour), live virtual conference/event. It's on the web, so its in your region! Sign up and build your schedule already. Don't worry, you don't have to attend the whole 24 hours (except you hard core devs, you know who you are). Did I mention that it's free?
Subscribe to:
Posts (Atom)