• rpg sql

    I am using dynamic sql in an rpgle pgm. This pgm is called from 2 different menu options. When I take the 2nd option, everything works fine. I exit out of that option and take the first option. Everything is still work fine. I exit the first option and go back to the 2nd option and the pgm hangs up...

    mcg15 pointsBadges:
  • SQL connection failure error handling

    Application group wants batch job to terminate if it is unable to establish SQL session to external database. Job log indicates MSGID QSQLMSG/SQ30080 "Communication error occurred during distributed database processing.   This appears in the joblog as a level 30 diagnostic message. When this...

    Midranger25 pointsBadges:
  • SQL0444 when I tried to access schema folder from CAE tree

    I am getting an error message indicating the following; [SQL0444] External program QPZA004366 in QIWS not found. Cause An attempt was made to CALL procedure or invoke function QZDGDBLL in QIWS. I open client access > Logged in > click on Database > Schema and I get this prompt message of...

    I5user5 pointsBadges:
  • which version of sql can be installed on windows vista 32 bit?

    which version of sql can be installed on windows vista 32 bit?

    Keerthishetti5 pointsBadges:
  • How to save data back to databse from radio button? SQL Server 2005

    I am using 4 radio button, what so ever radio button I select, so how data revert back to database, I am doing this in asp.net 3.5 using sql server 2005

    Shaktilpu15 pointsBadges:
  • SQL Server Business INtelligence

    While creating a report, is it ok to create data set using stored procedure by calling an existing one from the database, or, by creating a stored procedure within BIDS and imeplement it? Please, explain. Thanx in advance.

    RonitReno25 pointsBadges:
  • Locking and concurrency in SQL server 2008

    In microsft SQL 2008 enterprise edition, readers block writers and writers block readers. What does it mean? Is it that on same set of records only one query be processed.

    Akansha150 pointsBadges:
  • SSRS 2008 and SharePoint programmatically

    In SharePoint Integrated Mode of SSRS 2008, how to get the Report Server Instance Name, Report Server DB Name and SQL Server Instance Name hosting Report Server DB programmatically? Can it be done using SharePoint object model or through ReportService2006 web methods?

    PrashantGupta5 pointsBadges:
  • OLTP in SQL Server 2008

    While using OLTP in Micrsoft SQL 2008 enterprise edition, does the row level locking happens or table level locking happens?

    Akansha150 pointsBadges:
  • Microsoft Live Chat: Introducing Microsoft SQL Server 2008 R2 on 4/22 11am ET

    Join us on April 22nd at 11am ET to hear how SQL Server 2008 R2 can provide your IT environment with an end-to-end approach that increases efficiencies, reduced costs and an increased competitive advantage for your business. Visit the blog today to learn more and ask your questions in the...

    EmNichs3,250 pointsBadges:
  • WinXP shows no logon icons

    Customer's machine was set up as a single user machine - meaning that it went straight to the desktop from booting. Now, it shows the login screen with the "To begin, click your user name" message - with NO names or icons. I've checked a number of KB articles from MS which refer to setupact.log for...

    Bobkberg1,070 pointsBadges:
  • Objects explorator FILTER doesn’t work, SQL Server Management Studio de sql server 2008

    Hello friends, On my PC (Windows Xp 2002 SP3) in SQL-Server management studio 2008, the object explorator filter doesn't work. The funnel symbol is simply greyed. I can't access to the box bialog filter parameters. Please, anybody has an idea ? Jean-Max PS : Microsoft SQL Server Management Studio...

    Poussines50 pointsBadges:
  • Will we really save money having users shut down computers at end of day?

    The article below caught my attention. It says that 217 million dollars a year is wasted just in the UK alone by employees leaving computers on overnight. I never shut mine down...my old mentor thought it was actually harmful. Needless to say, we don't have a policy about shutting down computers...

    NoFX3915 pointsBadges:
  • How to use Insert command between two servers to speed up performance

    We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the data got there....

    Studentofsql5 pointsBadges:
  • Implement SQL Service Broker with SP

    Hi, Can some one help me by giving a sample program in detail on how to implement service broker concept using Stored procedures across different servers, and with in a DB and between Databases. It would be a great help if I could get answer at the earlest. Regards Jeevan

    SQLHELP5 pointsBadges:
  • Data retrieval from TextBox and insert in to database

    Hi i am learning c#2008 and asp.net3.5. I want to get data from my textbox control and insert it in database so i cant find any source code or presentation so please tell me how to do it or give me site address where i can find this Thanks

    Nimitparmar19875 pointsBadges:
  • view active directory data using SQL server 2005

    How could I view active directory data using SQL server 2005. For example I have all of the data available in Human Resource system and I would like to pull some of the information to the active directory like name, position and department … ext where the user name is primary key. Thanks alot for...

    Reem15 pointsBadges:
  • test management tool

    I'm in the process of researching test management tools and was wondering if anyone has any insight to what worksfor them and what doesn't. Also any information on free vs purchasing. Soem features I'm looking for are: user story documentation, test case documentation, defect capture and process,...

    Flyershockey25 pointsBadges:
  • 16 node failover clustering in SQL Server 2008

    How can 16 node failover clustering be achieved in Microsft SQL 2008 enterprise edition? Are all nodes in active state? How many nodes can remain active?

    Akansha150 pointsBadges:
  • Retrieving records from main database and logs database

    Our system has one main database (jadeappdbase) but the system logs (logs per transaction/process) are stored on a separate database on a monthly basis (a specific database is created every start of the month to hold all the logs for the said month). How will I get certain records from the...

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following