Hi, I’v known for a while that ado has it’s limits when it comes to dealing with errors… but this one hurts: I have a StoredProcedure (SP) that calls a sub procedure. In the sub procedure an error is raised. The error does not reach ADO for some reason. After some research I find that…

We have upgraded a number of Windows XP clients (from MSDE 1 to MSDE 2000) which interact with a clustered SQL server 7 system (running on Windows NT server) via transactional replication. Our problem is that these clients are connected over ISDN dial up lines and since the upgrade we have noted a significant increase…

what is the advantage and disadvantage of mysql 5.0?

Is it possible to see the explain plan used by Oracle for a select statement that was run yesterday?

I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I’m choosing “Add…”, then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some do,…

The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don’t want it showing up on the…

what are various select statements used and where are they used.what is value table.

I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

I am trying to do a merge replication with about 10 pda’s and a desktop i do not want to use full blown ms sql due to cost, anyone any alternatives PDA’s are running Mobile 6 and sql compact IF need be will change from MS sql to other

does sql supports nonlinear recursive queries

I installed a sql server 2008 cluster, first node went fine, however the 2nd node install fails with the following installing failover node sql server 2008 This resource does not have all the nodes of the cluster listed as ‘Possible Owners’. The group that this resource is a member of will not be able to…

My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant…

i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want…

I have a server 2008 R2 that while in Explorer on the left navigation pane show “Network” and under that a list of workgroup computers (it’s a file server) I have one computer in that network thats name is blue and underlined. Is there significance to this?

I have a SQL Server 2005 standard edition installed with a default instance. I need to install an additional named instance. However I could not find the standard edition installer CD; and my colleague managed to dig out a copy of the Express edition installer. Can i use the Express edition installer to install a…

How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

I have a user defined function that returns a single scalar value, e.g. a formatted name. Is it possible to reference the UDF as the value of a field in SSRS 2008?  If so, how?  Thanks.

Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs into trouble Converting date values…

Hi group, I am installing MS Studio manager 2005 but this will get recomment me to install MSXML 6 ,i installed this but then it recmoment to install Power shell ,i install this too but it recomment to install something new tooo. I installed windows new windows XP 2007SP2.  this error occur 1st time. I…

i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib # Restart JasperServer (there is a shortcut in the start menu to…