• differences between SQL server 2000 & SQL server 2005

    Hai  Can any one tell me What are the Main differences between SQL server 2000 & SQL server 2005. Thanks and Regards

    Sukumardba5 pointsBadges:
  • how to save file doc, xls, into database sql server 2000 in VB6

    how to save file doc, xls, into database sql server 2000 in VB6 with rdoconnection?

    Rlino5 pointsBadges:
  • Select – Top 10

    Hello, I have to tables, one with name CONTRACT, second AGENT IN table CONTRACT these data: ClientID ClientName ClientSurname ContractNR AgentID AGENT data: ClientID Sum ContractNR I need to select 10 agent's clients, who have a bigest sum. One agent have 100 clients, second only 2 or one client....

    Svetlaneto5 pointsBadges:
  • Conversion of SQL Server 2000 to iSeries DB2 V6R1

    Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.

    Tprusko5 pointsBadges:
  • Set identity to not for replication in T-SQL

    Hi, Does anyone know the TSQL to change the identity column on a table in SQL Server 2000. And also the TSQL to change trigger to not for replication. Thanks

    Db23290 pointsBadges:
  • Replication sync_method set to concurrent in SQL Server 2000

    Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been...

    Db23290 pointsBadges:
  • MS SQL Server 2000 Vulnerability

    Hello, I have installed on one of my servers SQL Server 8.00.2273 - SP4 (Standard Edition). At the last vulnerability tests it founds the followings: 1. Microsoft SQL Server MTF Data Structures Memory Corruption Vulnerability (MS08-040) 2. Microsoft SQL Server 'sp_replwritetovarbin' Remote Memory...

    MariusRO15 pointsBadges:
  • Tree View Control

    i am trying 2 make and explorer using the tree view control in my project using VB 6, SQL Server 2000 and crystal reports. in the looping statements i had inculed the details and all. i need 2 display the results in the Grid Box when click the nodes in the Tree control. please provide the code for...

    RAYNISH35 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:
  • 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:
  • installing sql server 2000 32-bit on vista 64-bit

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

    Alalifa20 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:
  • SQL Server 2000 hang and shrink won’t stop

    I'm troubleshooting a SQL 2000 database problem. It's a db for our datawarehouse system that pull everyday data from host. Current size is 461Gb for db and 67Gb for log. Because of space concern, I want to detach the log file and create new, but today I cannot open the database locally or remotely....

    ITKE344,855 pointsBadges:
  • sql 2008 system tray icon

    how can i add a system tray icon for sql 2008 just like sql 2000?

    Saga10 pointsBadges:
  • SQL server 2000 increase database auto-grow

    Does it matter to increase database auto-grow from 10MB to 250MB? We expereience some bottleneck at database size of 36 GB for a reporting database. But the physical disk has 100 GB free disk space, CPU usage is not high. Occasionally has some COM error Not sure what the problem it is

    ITKE344,855 pointsBadges:
  • SQL Server datetime

    Hi - When I run this: select cast ('461129' as datetime) i get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results. thx

    DBM10 pointsBadges:
  • comparing variable to a field with comma-separated values

    "m trying to compare a variable (@item) to a field which has multiple item numbers separated by commas. I've used "LIKE" and "IN" to no avail. I've also tried appending wildcard characters to the variable (@item2), which also hasn't worked. Full-text indexing is not activated on the DB (SQL Server...

    Caruncles20 pointsBadges:
  • Encrypt the password in SQL 2000

    How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to...

    S09875 pointsBadges:
  • SQL Server Database Date Time Values

    I am developing a software using Date Time values. i am using SQL server 2000 as the database. can i create a coloumn with only time value or data value. Only datetime is available. how can i eliminate a part of it in the database. when inserting the time values the date part is 01 jan 1900. i want...

    RAYNISH35 pointsBadges:
  • VB 6, SQL Server 2000 & Crystal Reports

    i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.

    RAYNISH35 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