Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
SSIS, Replication and everything SQL Server
I have seen some posts (and some forums) discussing about using xp_servicecontrol. There was also a...
Date: 01/14/2010
SQL Server 2008 transactional replication to DB2 subscriber can fail with: DB2OLEDBV2: Error "System.DllNotFoundException: Unable to load DLL 'mseidrda.dll': The specified module could not be found
Recently came across a situation where the DB2 subscriber was failing with the below...
Date: 01/14/2010
I have a old Compaq V2000 laptop (almost 4.5 years old) (Intel Centrino Mobile and 512 MB ram) and...
Date: 11/07/2009
You might find that when sp_who2 (or sys.sysprocesses or sys.dm_exec_requests) is executed on a SQL...
Date: 10/02/2009
Recently worked on an issue where sqlbrowser was getting bunch of errors:<error> 07/31/2009...
Date: 08/10/2009
Snapshot agent creates snapshots for the subscribers to initialize. These contain various different...
Date: 05/20/2009
If you are using Transactional Replication, you may find entries in your...
Date: 01/27/2009
Behavior observed due to @immediate_sync parameter of Transaction Replication when adding new article to an existing publication
- sp_addPublication procedure for creating a new transactional replication has a parameter...
Date: 11/07/2008
Understanding Performance Counters data while troubleshooting Performance issues in SQL Server:...
Date: 11/06/2008
Here are some of the links related to SQL Server 2005 on Windows Server 2008 Cluster: Support...
Date: 11/06/2008
Recently got one where using .NET assembly (through SQLCLR) to load data files was failing on 32-bit...
Date: 06/06/2008
How to use 'database snapshot' sync_mode while creating a new Tran/snapshot publication using sp_addpublication
Writing this blog post to ensure other can try - how to use 'database snapshot' mode of snapshot...
Date: 05/30/2008
Altering properties of a Column fails with: Cannot alter column 'column-name' because it is 'REPLICATED'
Recently had one where Altering column properties or running sp_rename against that column was...
Date: 05/22/2008
When non-dbo users opens a Dabase Diagram in SQL Server 2005, they get...
Date: 02/08/2008
A DDL Admin user is not able create/alter/delete tables from inside a database designer diagram in SQL Server 2005
If you create a DDLAdmin user (a member of the Db_ddladmin database role), still she will not be...
Date: 02/08/2008
If you are using SQL Server Notification Services 2.0, you can get "Error 4085: The number of WaitHandles must be less than or equal to 64."
If you are using SQL Server Notification Services 2.0 and you are using a complex NS application...
Date: 02/08/2008
I got a new one where we found that SSIS does not report the actual low-level error message while...
Date: 11/28/2007
You may be unable to connect (using TCP) to a SQL 2005 instance if you have Venturi Wireless Software Installed
I recently came across a situation where If you are trying to use TCP connectivity to connect to a...
Date: 11/22/2007
If you have a stored proc that has some print statements inside it and you execute it using Execute...
Date: 09/12/2007
I came to know about an issue with Linked Server Creation: Creation of a new linked server using the...
Date: 07/25/2007
Recently came across an interesting one where the SSIS GUI was not showing the borders of tasks...
Date: 07/23/2007
Recently I've observed a new issue with Web Services Task in SSIS (2005 build). The Web Service Task...
Date: 07/13/2007
Please find some useful SSIS recorded presentations here (external links): Ignoring a SSIS...
Date: 07/09/2007
MS Access Merge Subscriber not able to upload changes when the column order is non-sequential for article
If you have a merge publication with many articles and you may found that in one of the articles,...
Date: 06/05/2007