Just upgraded a vendor app from sql 2005 to sql 2008 r2 sp1 and are consistently getting Error: 18056, Severity: 20, State: 29. The client was unable to reuse a session with SPID 72, which had been reset for connection pooling. I have applied all patches and stil lcan’t get rid of error. User’s seeing…

Hi I have to create a package which process the analysis services cube and its partitions,and dimensions. This package should run every 15 minutes to process the cube. I have a procedure which creates the database in analysis services db and relational db for the current month. I have another procedure which creates daily tables…

I’m trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server.  What must I do to see other servers in the Event Forwarding Server drop-down box?

How can I hide or show columns based on a parameter in SQL Server Reporting Services.

Take advantage of Ubuntu 11.04, and let The Official Ubuntu Book 6th Ed. get you up and running quickly. To win this essential resource, simply answer one of five questions and post the link to your answer in the discussion section below. PSOD with ESX 3.5 MIMIX replication issue What would you like to see…

Does anyone know how often the witness instance pings the partners? I am aware of the timeout setting but want to know exactly how often the ping is initiated. Is it the same or different from the timeout value. Thanks in advance for your reply.

how to upload sqlserver management studio database on online

how to upload sqlserver management studio database on online

I have a application in VB.NET with SQL Server 2005 Express Edition. In the last few days, the database is continuously corrupting. I repair it, but the problem continues. I revise my code, but I can’t find transactions errors that could produce the problems. Do you have any general ideas?

I have a application in VB.NET with SQL Server 2005 Express Edition. In the last few days, the database is continuously corrupting. I repair it, but the problem continues. I revise my code, but I can’t find transactions errors that could produce the problems. Do you have any general ideas?

Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol

These days enterprise applications are all the rage, with the ultimate question being: Who’s going to build it? You know the saying, If you build it, they will come, and while I’m not quite sure how the second part of that saying fits, we have the resource to help you build it. Development with the…

steps for accesing sql data through ado.net code over LAN NETWORK

Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query rows display fine…

I need to run a stored procedure (with two input parameters ) that has no output, on an AS400. When I try using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider, I get the following error [Execute SQL Task] Error: Executing the query “CALL TPSDTA50GQ.PMCTESTTP(‘PETER’, 4)” failed with the following error: “TPSDTA50GQ.PMCTESTTP is…

Hi, i am trying to update a DBCS data defined through ODW BPCS version 6 to DB400 and i run into error SQL-332.I do not whether the problem is with the host variable.I find all the definition of variable being handled properly. Thanks, karthick

Table have delete and update trigger. How to identify which columns are affected by this triigers? or  which column have  triggers ?

Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features of Symantec…

We are running a VB Application in Windows 2003 environment. The database Server is SQL 2005. The Application runs in a separate server and the database in another. Remote Users connect to the application through the Remote Desktop facility. Users can go for direct print as well as save to PDF and print. Whenever more…

Hi, I am hosting a cold fusion application which was developed in version 6.1 in CF8 server. There is a application variable which is set to a value of 1000 in the Application.cfm and we invoke components and have a loop till the max value of this variable which runs a sp on SQL Server2005.…