• How to make installer of VB.NET including SQL Server 2000?

    I had done my project in vb.net with sql server 2000 but it's installer doesn't work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn't working please help me.I am stuck in here.thanks in advance.

    Rebi97745 pointsBadges:
  • Problem inserting data using OPENROWSET in SQL Server 2000

    When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Errors creating database with SQL Server 2008 I&M Training Manual

    I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),...

    Howhighthemoon20 pointsBadges:
  • rtf text in SQl Server

    We need to migrate a column of rtf-encoded text in SQL Server 2005 to a plain text field in a different table. Using Access, I can save the encoded text in a .rtf file, then open the file in Word and save it as a .txt, then read the .txt back into Access - Word strips out the rtf tags and returns a...

    EricF5 pointsBadges:
  • Optimizing a SQL Server stored procedure

    I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server trigger, insert result of multiple where clause into a variable

    Hi All, I have a select statement that stores the result in a variable,this works fine if there is only one condition and field in the clause.How do I go about it if there is more than one? For example (Working one) SELECT @Variable = (SELECT [Field] FROM [Table] WHERE [FIELD] = Value) But I am...

    Jacquesvdm20 pointsBadges:
  • Script to restore database permissions during a migration to SQL Server 2005

    We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I'm searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ODBC connection to the SQL server from the iSeries

    Is there a way on the iSeries to establish an ODBC connection to the SQL server?

    a1maida150 pointsBadges:
  • How to connect my application using Visual Studio 2005 to a SQL Server database?

    how to connect my application using visual studio 2005 to a database using sql server?

    MissVeryLittleKnowledge5 pointsBadges:
  • Hardware requirements for SQL Server 2005

    Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db 's will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the CPU's, RAM memory and...

    Arne5 pointsBadges:
  • Lacking a FQDN during database mirroring on SQL Server 2005

    I am trying to work with database mirroring on SQL Server 2005, and I keep receiving the error message, “One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.” I know that the syntax for a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Explaining triggers in SQL Server 2005

    Can you explain to me the syntaxes of triggers used in SQL Server 2005? Could you also give me a simple example of a trigger?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Access 2003 SQL sub-query within query

    I’m trying to extract all Person.ID eligible to sit a Level 1 study exam from our database. So I setup a query to look for members with study exam level 1 not equal to “pass” or Is Null, thinking it would give me all people who hadn’t sat or hadn’t passed level one exam. However where it...

    JimiLotus15 pointsBadges:
  • What is seed and reseed in SQL Server?

    What is seeding and reseeding in SQL Server? How to use it? Where is it used? What is the purpose?

    Jaideep Khanduja8,785 pointsBadges:
  • Bulk update in SQL Server 2005

    I need to update Column A1, Column A2 data in table A with Column B1, Column B2 data in table B for over 100,000 rows. How do I write a procedure to accomplish this in SQL Server 2005?

    Rl10 pointsBadges:
  • COBOL DB2 program for reading a text file and comparing with one of the DB2 table

    I need a sample COBOL DB2 program in which I take the data from text file consisting of order numbers and comparing with orders number in order table in db2, the data not matched to be stored in some other file?

    bestkapil225 pointsBadges:
  • Setting up database mirroring for disaster recovery in SQL Server

    I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, how do I make sure...

    SQL Server Ask the Experts2,585 pointsBadges:
  • as400 db2 to sql server 2005

    how can we take a db2 backup tape and dump to a sql server 2005 database?

    Mingo5 pointsBadges:
  • Design a SQL Server trigger to calculate column averages and return them to another table

    I'm quite new to SQL Server and I’m struggling to design a trigger. I need this trigger to execute daily and calculate averages of columns and return them to another table.

    SQL Server Ask the Experts2,585 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