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
Usage of xp_servicecontrol is unsupported
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
How to get Conexant AC link Audio working for old Compaq V2000 laptop with Win7
I have a old Compaq V2000 laptop (almost 4.5 years old) (Intel Centrino Mobile and 512 MB ram) and...
Date: 11/07/2009
sp_who2 (or sysprocesses or sys.dm_exec_requests) might show your thread being blocked by SPID -4
You might find that when sp_who2 (or sys.sysprocesses or sys.dm_exec_requests) is executed on a SQL...
Date: 10/02/2009
SQLBrowser fails with "The SQLBrowser service was unable to process a client request"
Recently worked on an issue where sqlbrowser was getting bunch of errors:<error> 07/31/2009...
Date: 08/10/2009
Replication Snapshot Folder Cleanup
Snapshot agent creates snapshots for the subscribers to initialize. These contain various different...
Date: 05/20/2009
"Virtual" subscription entries in the Distribution..MSsubscriptions table
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
Links for using Performance Counters (perfmon) while troubleshooting SQL Server related issues
Understanding Performance Counters data while troubleshooting Performance issues in SQL Server:...
Date: 11/06/2008
Content about SQL Server 2005 on Windows Server 2008
Here are some of the links related to SQL Server 2005 on Windows Server 2008 Cluster: Support...
Date: 11/06/2008
Loading data files using SQLCLR assembly causes Out Of Memory Errors on 32-bit SQL Server
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
Non-dbo users may not be able to create Dabase Diagrams in SQL Server 2005
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
OLEDBDestination in SSIS does not report low-level error message
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
Execute SQL Task in SSIS cannot show the PRINT Statement outputs from a stored proc
If you have a stored proc that has some print statements inside it and you execute it using Execute...
Date: 09/12/2007
Linked Server Creation fails after applying SQL Server 2005 Service Pack 2
I came to know about an issue with Linked Server Creation: Creation of a new linked server using the...
Date: 07/25/2007
SSIS (BIDS) GUI not displaying the borders of the tasks
Recently came across an interesting one where the SSIS GUI was not showing the borders of tasks...
Date: 07/23/2007
Issue with Web Services Task in SSIS
Recently I've observed a new issue with Web Services Task in SSIS (2005 build). The Web Service Task...
Date: 07/13/2007
SSIS Trainings - External Links
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