First of all Happy new year to everyone. Hope it should be a good start for everyone. We have planned user group meeting this month. Going to start with fresh look on SQL Server Denali aka SQL Server 2012. SQL Server 2012 is expected to reach market by this year, so this month topic is based on SQL Server 2012 only. Venue and topic details below
We had wonderful session this month. I reached the venue on time and I could see some of the participants and after some time everyone started reaching the venue. I really appreciate all the participants who came to the session , it’s really nice to see you guys. I have started my session and then followed by Amit Bansal and then by Madhi. Surprising we had a volunteer speaker who wanted to take a 10 min session.
Time to rock again this month with Venkat and Rami’s session. The sessions which we left last month will be continued by both the speakers. Thanks for your time to vote for conference room and rating for speakers however I could see only few participants voted. Going forward please give us feedback, this will help us to improve better.
April event is the second SQL Server user group meet in this year. As you all know Mr. Pinal Dave has stepped into our meet this time and its nice to meet him after Teched. We planned to start it by 9.30 AM however we could see some of the participants already reached the venue by 9 AM itself, appreciate their interest in learning things. The day has started somewhat ok because you know power cut happened on the entire Chennai and we couldnt get any other conference hall at that time. Venkat has jumped with his office colleagues and he managed to get a generator with in 45 min, which I wanted to really appreciate him and all the efforts he has taken to bring the power back. Thanks Venkat.
Hey Folks, We are back this month with wonderful guest attending our UG meet with two sessions, one is for DBA track and another is for DEV track. Its none other than super star Mr.Pinal Dave.
RA
| #
Thanks for the script. I had database with space between the names.
I modified to use square brackets:
FROM [?].sys.database_principals a
LEFT OUTER JOIN [?].sys.database_role_members
and
from [?].sys.database_permissions join [?].sys.sysusers U
on grantee_principal_id = uid join [?].sys.sysobjects
Gangadhar NG
| #
This tip is helpful enough for me.
thanks.
Zukunftsmusik
| #
Thanks! That helped my a lot. But there’s a little mistake:
SQL_Latin1_General_CP1_CI_AS stands for “Latin1-General, case-insensitive, accent-sensitive [...]” therefore sort order 52.
If you want to set the sort order to 54 the correct collation would be “SQL_Latin1_General_CP1_CI_AI”
Amit Bhatt
| #
Hi Deepak,
Thanks for such a nice article.
You missed one thing to add in code:
@article = ‘all’,
Hence the script will be like this:
EXEC sp_addsubscription
@publication = ‘mypublication’,
@article = ‘ALL’,
@subscriber = ‘Subscriberservername’,
@destination_db = ‘mydestinationdbname’,
@reserved=’Internal’
Error 18486 | Platformblog
| #
[...] SQL-Articles » Troubleshooting Login failed Error 18456This is one of the infamous error message (and number) that most of the DBAs …. 18486. Login failed for user ‘%.*ls’ because the account is currently locked out. [...]