• select parent where more than one child

    I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

    Ghjazz5 pointsBadges:
  • Connecting VB2008 to SQLServer2005

    How to connect VB2008 with SQLServer2005 through coding.. Not through OleDBAdaptar.. Also Let me know the code for Add,Edit, Delete & Save in VB2008

    Ishita20095 pointsBadges:
  • Get your FREE ITKnowledgeExchange.com sticker

    Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one for your...

    ITKE334,665 pointsBadges:
  • Execute SP through DOS

    Can you tell me how to execute the parametrized procedure using DOS or command prompt?

    carlosdl67,880 pointsBadges:
  • alert log file to monitor disk space

    I have a sql server which has some Biztalk databases which can grow like wildfire on a daily basis, where log files can grow to 20 gig in an hour. Is there a way to set an alert based upon a log file size growing to big that I can fire an sp on to shrink when needed. Or any other better approach?

    tcstl95 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • Problem with Msn Messenger

    Hi, I have a Win Xp , service Pack 2 computer, and have msn messenger 7.5 on my computer. I am having a problem connecting with msn messenger. Its giving a message stating the key ports are blocked and i am not able to connect, suddenly it started doing this because i was able to connect with msn...

    Mdimthays10 pointsBadges:
  • Crystal report asks for parameter at runtime

    Hello All, I have a problem with crystal reports at runtime...... I have a desktop application in which I have used crystal report... When I run the application, crystal report asks for parameter even though I have supplied it through code in C#. Not able to figure out why this happens..... My...

    Rahuldjain25 pointsBadges:
  • Data type for output file in DB2 SQL

    I am using DB2 SQL on the mainframe - not sure of the version - I want to write out a file and transfer it down to the PC - how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as numeric and not character?

    Kath95675 pointsBadges:
  • Link SQL Server 2008 to AS400

    How to set up a ODBC for SQL 2008 to the AS400

    Jaymz69765 pointsBadges:
  • Storage Area Network Certification

    is there a certification for SAN admin? I am a beginner and want to be a SAN admin where do i start?

    Rick Martinez585 pointsBadges:
  • Error message when restoring a SQL Server database

    This error received when restoring a SQL Server database: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Posting Data Online

    We want to "post" various documents on-line so that we can give members of our outside consulting group access to view, and even possibly download them. Is it possible without opening them up to the public-at-large? In answering, keep in mind the following: 1. We prefer not to purchase any...

    TheVyrys0 pointsBadges:
  • Sharepoint 2010 x64 central administration problem http error:503. The service is unavible

    Hi. I installed Sharepoint 2010 x 64 version. My sql server is Sqlserver 2005 + Sp3+ hotfix. I confingured sharepoint central administration with NTLM. When i tryed open central administration it gives me Service Unavailable   HTTP Error 503> the service is Unavailable . My operating System...

    Eliyevelxan1,235 pointsBadges:
  • Can anyone suggest a good loan APR formula in SQL

    I am getting a rather large error with an Excel RATE function, and so am wondering if someone can suggest a SQL formula or a solution?

    Nrate5 pointsBadges:
  • Changing the computer name?

    Hi, How can I change the computer name without disjounting computer from the domaim(win xp pro sp2)!? Thank you. --- Regards Mahnaz

    Aliyani265 pointsBadges:
  • Connection of VB6 with SQL Server 2000

    I want to connect VB6 application with SQL SErver database such that if anything is saved in VB6 forms it will be saved in the database tables of SQL Server.

    Jayee5 pointsBadges:
  • File Level Identifiers

    If we save and restore SQL generated files which were created under an old OS/400 system software will the Format Level Identifier be changed and how does this affect the file?

    Kevkel5 pointsBadges:
  • Open IT Forum: What are your views on social networking platforms in your network?

    I chatted with David Sacks, CEO of Yammer, last week at Enterprise 2.0, and we talked about IT's changing attitude toward cloud-based offerings such as social networking platforms. I'd love to hear from practicing IT professionals about the impact of these platforms on the network, whether it's...

    MelanieYarbrough6,345 pointsBadges:
  • VNC over Broadband/internet

    Hi all, My IP skills are somewhat rusty - could someone please help me with some high-level steps to remote control using VNC over the internet... scenario: Customer down the road is always requiring assistance - usually I need to jump in the car & go there to sort out the latest dilemma. I'd like...

    SCOOBAMAN0 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