• Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • Adding New Parameter to a existing Crystal reports 9.5

    I have a exsiting crystal rpt that passes 5 parameters to a stored proc.  We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter "new" (new being the added parameter).   I have been unable to get around this. Can...

    Ftrucks015 pointsBadges:
  • What are the best tools for SQL monitoring and SQL diagrams?

    we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

    Persa5 pointsBadges:
  • Access or SQL Server tables

    Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more...

    Imjnice15 pointsBadges:
  • Exchange Server auto-reply setup

    We have an exchange server that has been servicing records as follows: user1@alpha.company.com is an alias for user1@bravo.company.com. All mail destined for alpha is forwarded to bravo e-mail address. We now need to only use the @bravo.company.com e-mail and set up an auto reply on the...

    FlyNavy0 pointsBadges:
  • Using a variable in the LABEL ON SQL statement

    Is it possible to use a variable in the label-string of the LABEL ON sql statement so that the variable can be changed dynamically in an SQLRPGLE program ?

    aderene180 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • How to create data security in SQL server 2005 so that the code will not be opened

    how to create data security in sql server 2005 so that the code will not be opened

    Gkhlhlhjhhghgg15 pointsBadges:
  • Recovering lost SQL Server 2000 data

    I lost a LDF file for SQL server 2000 -- but I have the MDF. How can I recover my data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I use SQL codes in delphy7?

    I am going to use the sql code below in a query in delphy7 SELECT     left(edit1.text, 5)+'0 ' FROM        edit.text2

    Ramin5 pointsBadges:
  • How do I retrieve data from Visual Basic 6.0 with SQL?

    how can i rertieve data in vb6.0 from sql?

    Escabarte5 pointsBadges:
  • Question on SQL 2005 table

    tablename:-software pname             packagename                    cost MARY               README                             1200 ANAND             PARACHUTES                     6000...

    Vijaykumar45625 pointsBadges:
  • SQL Server 2005 procedure to Create stored procedure

    sir,plz tell me the procedure from strating that how to create stored procedure

    Gkhlhlhjhhghgg15 pointsBadges:
  • Crystal Reports 8.5 compatibility with SQL 2005

    Is crystal 8.5 compatible with SQL Server 2005?

    CrystalPrincess5 pointsBadges:
  • Hide SQL Server 2008 input parameters

    Hi Sir, I wanna help from you . i have designed a report on reportserver . (sql 2008). its includes two variables which are userid and password. Because entering the user id and password , only the data who can view authorised section. User id and password should be keyed and it check with the...

    Virajtky5 pointsBadges:
  • Add an Active node to SQL Server Active Passive Cluster

    how will i add an active node to an existing Active/passive SQL Server 2005 Cluster. so that when any active node fails the passive will be used.will there be a down time for the current cluster Jasina

    Jasina30 pointsBadges:
  • Advantages and disadvantages of MySQL 5.0

    Can someone explain me what are the advantages and disadvantages of MySQL 5.0??

    Espada0075 pointsBadges:
  • Why can’t I connect to Oracle DB from virtual xp running under windows 7 host

    I am running plsqldeveloper on a windows xp virtual machine. (Created on a windows 7 box). When I start plsql developer on the virtual xp machine I type in a vallid Username/Password there are no Databases in the drop down list so I type in a valid database name then I get the following error:...

    PLSqlWannaB30 pointsBadges:
  • What is a good book for SQL?

    which is the Good book for SQL?

    Prcvjr220 pointsBadges:
  • DB2 Stored Procedure V4R4 without ILE C/400

    We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we've run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we've been...

    MODMOD0 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