• Error during SQL Server 2000 installation

    When I attempt to install SQL Server 2000 using Windows XP Service Pack 2 for IT Professionals and Developers, I encounter the following error: "Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for...

    SQL Server Ask the Experts2,585 pointsBadges:
  • XML Schema Problem

    hi I have an xml file <UserRoleConsumers> <UserRoleConsumer> <ConsumerID>67</ConsumerID> <RoleConsumerID>89</RoleConsumerID> </UserRoleConsumer> <UserRoleConsumer> <ConsumerID>45</ConsumerID> <RoleConsumerID>78</RoleConsumerID>...

    Dilipd0065 pointsBadges:
  • SQL Insert Error Against Runtime Control Error in FLP

    am trying to insert into sql-2000 database my code is: StringBuilder sb=null; sb=new StringBuilders; sb.Append("Insert into dummy(name,amount) values"); foreach(Control ctl in this.FlowLayoutPanel1.Controls) { if( ctls.Name.Contains("tb") && ctl is TextBox) { sb.Append(ctl.Text); } }...

    Maheshwag260 pointsBadges:
  • Parameter Date Conversion in SQL 2000

    my code is : string sql="insert into dummy(date)values(@date)"; sqlcommand cmd=new sqlcommand(sql,con); cmd.parameters.add("@date",sqldbtype.datetime).values=maskedtextbox1.text text; cmd.executenonquery(); the problem is it's throw and error like  conversion of varchar to date; Note :- my demand...

    Maheshwag260 pointsBadges:
  • SQL Server 2005 error after development

    I developed an application and when we moved it to the clients site we started getting this error from their SQL 2005 box: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...

    TeachMeIT975 pointsBadges:
  • SQL 2008 R2 CPU Count

    The SQL 2008 R2 Std specification says it can use up to 4 cpus.  If I have two quad-core xeon processors.  Would this count as 8 or 2?

    LeeHerr15 pointsBadges:
  • Connect JasperServer and Sql 2008

    i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program...

    Edkettavan5 pointsBadges:
  • SSRS Dynamic Report Parms

    I am desiging a report to use several parameters. The first parm is report type. I need the other parameters to show or hide depending on the selection made to the first parameter. Can anyone help? Thanks

    Mgee165 pointsBadges:
  • Select into vs Insert into in SQL Server

    Hi experts, What is better between Select into vs Insert into in SQL Server when it comes to performance? thx

    DBM10 pointsBadges:
  • Network Connection Freezes

    For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the...

    DboiSOBE0 pointsBadges:
  • Updating database index

    when i create a table with nearly 100 rows, database index gets update to accomodate those 100 rows. Can i find out the time taken by the index to get updated from previous state to a state to accomodate those 100 rows?

    Ravikanthtodeti5 pointsBadges:
  • High Disk usage on SQL Server 2005

    We recently upgraded our application from version 3.1 to 3.5. We had run the latest schema and other DB changes on the existing 3.1 Database. This is how we upgrade to higher versions. Now the problem is, after the upgrade, the disk usage has gone very high. What are the possible reasons for high...

    Jsql155 pointsBadges:
  • Call Stored Procedure Multiple times

    I want to use a SQL script that takes values from one table and then calls a stored procedure multiple times for each of those values. Each time, I am passing in those values as a parameter for each stored procedure call. How can I do that?

    Kyoseix5 pointsBadges:
  • Help navigating SQL Server 2008 database?

    Hi all, I'm facing an interesting challenge... Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I can get my...

    Palloquin95 pointsBadges:
  • What are the query optimization techniques used in SQL 2000?

    What are the query optimization techniques used in SQL?

    Gomsbk35 pointsBadges:
  • Answer a Question, Win The Official Ubuntu Server Book!

    At the beginning of the month, we gave away The Official ubuntu Book, and now we're giving away The Official ubuntu Server Book, Second Ed.! The book includes a DVD that contains the versions of Ubuntu Server needed for different CPU architectures. You also receive a code for a free online version...

    MelanieYarbrough6,345 pointsBadges:
  • Prophet 21 Database Dictionary

    Is there a data dictionary for the prophet 21 database? I am looking to create applications that use data stored by prophet 21 software. Is there available software to interface with prophet 21 data?

    Carlosburkle5 pointsBadges:
  • SQL Server 2008 Restore error message

    I get this error when trying to restore a 30 mg database "Callback:SQL Server 2008: Out of memory on restore" and then get the error ""There is insufficient system memory in resource pool ‘internal’" Anyone have any ideas?

    Kmmc1122334455665 pointsBadges:
  • server temporary freezing

    I have Dell poweredge 700 with Dell CERC SATA 1.5/6ch Raid controller card in RAID 5 I have about 20-30 stations connected to it at any moment. The disk queue is small below 1 from time to time people will experience desconnection problems such as i will try to access file and server will stop...

    Dimchik0 pointsBadges:
  • Indexing in Microsoft SQL

    What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

    TeachMeIT975 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