• SAN configuration best practices for SQL Server using NetApp

    Good day all, Have recently purchased NetApp SAN to be implemented as our primary storage to host our database environment. As I'm not an expert in storage management wondering what would be the best practice / general rule of thumb in order to provide an optimal I/O performance towards our...

    blueivy5 pointsBadges:
  • WSS3/MOSS Search no wildcards?

    When I search in WSS3 or MOSS, I must type a full word and I cannot use wildcards. Examples: "Wilso" will not find "Wilson". "Wilso*" will not find anything. "Wilson" will find all documents with Wilson in the name or in the document body (content search is working). Is there something I haven't...

    FWilson15 pointsBadges:
  • VB.NET application not running a in network

    Hello all, I have developed a small application in VB.NET 2005 with SQL Server 2000. The application is running in a machine is okay. But when I'm going to access the application through another machine in the network is not running. How can I solve this problem please help? Thanks!

    Sowmi ssk5 pointsBadges:
  • SQL Injection Validation

    How can I use validation codes in order to avoid SQL injection into my web server. I mean, everybody knows that HTML modification is very easy so do I have to use web services to do this or get another app?

    Underworld5 pointsBadges:
  • What’s the career lifetime for SQL Server, C#, ASP.NET and SharePoint?

    I want to know career and technology lifetime for SQL Server, C#, ASP.NET and SharePoint. Also, how is their growth compared to big data or SAP in the future? Please give your suggestion.

    vitalreddy5 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • Insert values into database from form VB.NET

    Hi guys, Having a bit of trouble with inserting values that i have in my form into my SQL database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want...

    Darthswift0040 pointsBadges:
  • Recovering lost data from SQL Server 2005

    Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting...

    BClawson10 pointsBadges:
  • Trigger Use in SQL Server 2005

    I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

    Jjc98105 pointsBadges:
  • SQL Server 2005 database conversion

    Hi, we plan to migrate SQL Server 2005 from SQL Server 2000. We have a database with average size of 12GB. Can any one please let me know how to convert our database from SQL 2000 to SQL 2005.Thanks in advance.

    Anto5 pointsBadges:
  • Slow outer JOIN after delete rows

    Hi, I've tried this on two installations of SQL Server 2005 service pack 2. If I delete rows of a table, an outer join on the empty table is extremely slow...if I truncate it's ok, if I delete with the tablock hint it's ok. Any ideas why? The code to reproduce this follows, the outer join takes...

    dpaproskijr5 pointsBadges:
  • Exporting a SQL database to MySQL

    I have a MS SQL .BAK database that I need to convert to MySQL. I was able to import the database but not actually export to MySQL. A friend of mine told me to use MySQL Migration Toolkit but it's been replaced by MySQL Workbench. Can I use this tool to migrate the database? Or is there another way...

    ITKE351,880 pointsBadges:
  • Delete all tables in SQL Server database?

    How to delete all tables of a database in SQL Server?

    Prcvjr220 pointsBadges:
  • Restoring a SQL database with an .mdf file

    How can I restore a SQL database with an .mdf file?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need to create SQL DTS Package

    We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also, I want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script?

    JimmyIT1,725 pointsBadges:
  • Export XML from SQL Server 2000

    We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?

    JHM5 pointsBadges:
  • Error In SQL SERVER DataBase

    am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : "True" to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help me. i am...

    SrimanBenivolent5 pointsBadges:
  • Oracle 10g terminated_with_error

    While I'm running an Oracle 10g report using the following code: declare   repid REPORT_OBJECT;   v_rep VARCHAR2(100);   rep_status VARCHAR2(50);  BEGIN   repid := FIND_REPORT_OBJECT('REPORT1');   SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'rep_app_oracle_forms');...

    K197070 pointsBadges:
  • How to Schedule jobs in DTS in sql server 2000

    I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

    SRI HARSHA10 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