• ms sql query problem with a case statement

    [strong]This code works: SELECT     passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...

    Rinkratt20 pointsBadges:
  • SQL Server 2005 distribution agent failed

    Getting this error message

    ITKE352,420 pointsBadges:
  • Most popular blog posts this week

    10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...

    ITKE352,420 pointsBadges:
  • Tree View Control

    i am trying 2 make and explorer using the tree view control in my project using VB 6, SQL Server 2000 and crystal reports. in the looping statements i had inculed the details and all. i need 2 display the results in the Grid Box when click the nodes in the Tree control. please provide the code for...

    RAYNISH35 pointsBadges:
  • Restore a View Sql Server 2005

    I over-wrote a VIEW by mistake. How do I recover the original version of the view? Is there a way to ROLLBACK a "CREATE VIEW..." command?

    VelameLaCosa110 pointsBadges:
  • The most-watched IT questions this week: Oct. 13, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: Are you feeling...

    Michael Morisy8,323 pointsBadges:
  • Resource usage of SQL Server 2005 Generate Script

    Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.

    Db23290 pointsBadges:
  • Trying to setup a Merge publication between two database Need Help!

    HI I am trying to setup a Merge publication between two database and I am having troubles.  I have to server one is HKDD01 and LDDD01 and the HKDD01 is set as the distribution and the LDDD01 is set as the subscriptions. I am trying to create a Merge publication with pull subscription and I am...

    Fubarms5 pointsBadges:
  • Pulling data from tables on different servers

    I have a join between a table on my local database and a table on a different database on the same server. I reference the non-local database with DatabaseName.TableName. Now I find that the non-local database might be on a different server. I tried ServerName.DatabaseName.TableName, but I got this...

    CO Bill120 pointsBadges:
  • Retreiving AS/400 SQL scripts

    When I start sql on our iSeries, the system returns my previous scripts I have run. Which fle do these live in in the iSeries and can I report on them?

    Morticia00110 pointsBadges:
  • file user open exceptions for printer file

    i'm opening a program defined printer file in SQLRPGLE.. i get error file is already open.... if that is the case, then i'm trying to write in that file but now this gives me exception that attempting to write in closed file...   Please help

    Nutangujar895 pointsBadges:
  • Can I Use Tomcate as a “Witness” Server in SQL 2005 Mirroring

    Hello i am using SQL 2005 and i have Tomcat as an Application Server i want to use Mirroring on my DB and i am looking for the way that let me make Tomcat as my Witness server [Br class="height5" />[small] [/small]

    ITKE352,420 pointsBadges:
  • Replication Causes Client Application to Hang

    I've got 25 Sites that are running an application that connects to MS SQL 2005, All the sites have their own copy of a database and have one similar database that holds information gathered from the different sites, now what is happening is that if a client registers at one institution and then...

    Sanisto45 pointsBadges:
  • Diff. between PF and a sql table

    can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index.....

    Anky10 pointsBadges:
  • How does SQL Server 2000 CAL licensing work

    Hi, Just wondering how SQL Server CAL licensing work. For example in one of our client SQL Server 2000, we notice in the SQL Server 2000 licensing icon in Control Panel, it is set to CAL of 50. Does this mean if the 51st client tries to access the SQL Server, an error will occur? Thanks in advance.

    Db23290 pointsBadges:
  • Full vs Transaction Log Backups

    Is it nessisary to perform a log backup on a database that is set to Full recovery if I am uninterested in doing a point in time restore? I could opt for Simple, but, really my question is, why? My question also goes on to the size of the ldf file, and will it reuse space and not have to grow if I...

    Jagoodie60 pointsBadges:
  • Why are naturl JOIN keywords not an option for producing a self-join?

    Why are naturl JOIN keywords not an option for producing a self-join?

    Meganlh5 pointsBadges:
  • Change SQL Server licensing

    Hi, I was wondering if it is possible for a 50 seat (i.e. maximum of 50 connection) SQL Server 2000 or 2005 license to be change to a 10 seat? If it is possible is there any limitation on the number of seat that can be change? Thanks

    Db23290 pointsBadges:
  • The most-watched IT questions this week: Oct. 6, 2009

    Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to...

    Michael Morisy8,323 pointsBadges:
  • Best way to copy large amount files

    I have 50 GB of files on an iServer that was copied onto an external hardrive.  What is the best way to copy these files onto a Seagate NAS Server.  The external HD is plugged into the USB and appears as a drive.  Should I use xcopy is DOS or can I drag and drop in windows SP?

    Gyakstis5 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