The xSQL Data Compare tool has proved extremely useful for database administrators who are required to compare, replicate and generate data using an SQL Server database. It is already widely used throughout the world, but there is now an updated version available, version 4, which promises to offer a number of improvements.
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
Diwali Season Starts now.. We have planned session for this month before Diwali so that you guys are stuffed with information before going for festival. Session details are below
Next session is ready for this month. We skipped last month as we had a session on first week of August so lets have a wonderful UG this time
We are back again this month. We are going to post pone this month UG a week , that is to first week of August. You know why ? We have a fantastic SQL Server guest for UG this month. He voluntarily wanted to take a session for Chennai folks. It’s none other than the Mr. Amit Bansal. He will be visiting Chennai first week of August , we have postponed our UG on first weekend of August so that Amit can gave a wonderful session for you folks.
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. [...]
Setting and Changing Collation – SQL Server 2008 « Blog
| #
[...] to sql-articles.comRead more: http://sql-articles.com/articles/dba/how-to-change-server-collation-in-sql-server-2008/#ixzz1pu2S8XW… Like this:LikeBe the first to like this [...]
VidhyaSagar
| #
Naveen,
I’ll check this out and get back to you.
balakiran
| #
Thanks man, Very simple & easy to understand !!!!