You have probably reached this page after receiving the following error message: Server ‘SERVERNAME’ is not configured for RPC. [SQLSTATE 42000] (Error 7411). This article will explain why you are receiving this error, and what can you do resolve it.
your SQL Server Collation choice for your database (or server) will control how characters will be sorted and compared within the database or SQL Server in general.
DBAs must choose a collation carefully that matches the type of characters encountered in a particular database. It is important to take into account as well how this database will interact with other database in the same instances, or through a linked SQL Server instances.
Until recently I had no idea SSIS allowed opening multiple connections to (flat) files, but due to the performance and parallelism implication of such a connection, I thought its definitely worth blogging about.
Hi Sreehari,
SSIS service will run on a separate process...June 28, 6:30 pm by Links Naji
Hi,
Suppose my system has 8GB RAM and I have installed...June 28, 6:30 pm by sreehari
Any idea if we can use the keywordTokenizer along with stemming....August 2, 12:30 pm by kanishka
I think you have remarked some very interesting points...January 21, 1:06 pm by Johnc511
Hi, good article!
Can you help me with one thing.
I'm...August 13, 7:22 pm by Alex