August 2010 UG Scheduled
After a big wonderful event conducted last month we are back on our normal UG sessions. Please go-ahead and register for the event, hope to see all the faces again.
Posts Tagged ‘chennai sql server user group’
May 2010 UG Presentation Material
We have conducted UG on 29th of May 2010 and it’s nice to see peoples around the room. You can download the presentation materials and scripts used during the presentation to play with it. Incase if you need any clarification you are welcome to contact the presenter.We know this is too late since we are busy with SQL Code Camp we are not able to upload it at the earliest.
February 2010 UG Scheduled
September 2009 Month Meeting Scheduled
We are back again for this months UG session. We have a slight change in timing for this week UG due to non-availability of conference room at our usual timings.
Venue: Microsoft Training centre, Radhakrishnan Salai
Landmark: Opposite to President hotel
Timings: 9:30AM to 12:30PM
Date: September 19th 2009
August Month Meeting Presentation Materials
The Chennai SQL Server UG for the month of August was held on 22nd of this month, refer this link for the details. It was a great learning experience and a good space for SQL networking. There were two sessions.
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. [...]