• 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]

    ITKE351,965 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:
  • Oracle LIKE statement on SQL Server 2005

    I'm trying to execute the LIKE statement but it's not displaying  any values SELECT R_NAME FROM LAWSON.DEPTCODE WHERE (R_NAME LIKE :r_name)

    Huhemp5 pointsBadges:
  • Reordering the Table position in SSRS

    Is there any provision to reorder the table position in a rdl? I have two tables, say A and B where A is placed after B at design time. Can I reposition them with B coming first and then A at run time?

    UmaD5 pointsBadges:
  • installing sql server 2000 32-bit on vista 64-bit

    how to install sql server 2000 32-bit into vista 64-bit?

    Alalifa20 pointsBadges:
  • Working TRIGGER and TRANSACTIONS QUESTION

    Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table,...

    LUISCGG5 pointsBadges:
  • The IT Blog Top 10: Oct. 1, 2009

    10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing....

    Michael Morisy8,323 pointsBadges:
  • Making a WAN

    Hi, I would like to know the best way to setup a WAN. We have 4 small companies and one main Head quarter.  2 companies are in one city and 2 are in another city. Below is the detail on what each site has. HQ(head quarter)- HP Mail Server (HP ML350) - Win 2003 Server + Exchange Server...

    PRINCESS85 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