SQL Server 2000 Questions and Answers

Recent IT Questions

1 - 20 of 307
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>

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...

View Answer   |  Nov 2 2009  9:02 AM GMT
SQL Server 2000
asked by Svetlaneto

  5 pts.

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...

asked by Db23

  230 pts.

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

View Answer   |  Oct 20 2009  5:58 AM GMT
SQL Server 2000, ALTER, T-SQL
asked by Db23

  230 pts.

store image to sql server

would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end Software/Hardware used: vb6

Answer Question   |  Oct 19 2009  8:28 AM GMT
SQL Server Image Store, SQL Server 2000, VB 6.0
asked by Azad

  10 pts.

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...

asked by MariusRO

  15 pts.

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...

View Answer   |  Oct 15 2009  8:55 AM GMT
VB 6, Tree View control, Visual Basic
asked by RAYNISH

  35 pts.

SQL 2000 & Outlook 2000

We have a couple of SQL 2K Servers which have a mailbox associated with them, have always used Outlook 2000 because anything newer does not work and today it has gone wrong!!! We are now getting a "Cannot open the mailbox, information store not available" we cannot get the server to work with...

View Answer   |  Oct 12 2009  2:12 PM GMT
Server 2000, Outlook 2000, Exchange 2007
asked by Paulbeynon

  60 pts.

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...

asked by Db23

  230 pts.

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

View Answer   |  Oct 6 2009  3:18 AM GMT
SQL Server licensing, SQL Server 2000, SQL Server 2005
asked by Db23

  230 pts.

installing sql server 2000 32-bit on vista 64-bit

how to install sql server 2000 32-bit into vista 64-bit? Software/Hardware used: window vista business 64-bit, hpi7

View Answer   |  Oct 2 2009  7:43 AM GMT
SQL Server 2000, SQL Server 2000 32-bit, Vista
asked by Alalifa

  20 pts.

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...

View Answer   |  Sep 29 2009  2:43 PM GMT
SQL Server 2000, SQL Database, Event Viewer
asked by ITKE

  10180 pts.

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...

View Answer   |  Sep 23 2009  10:56 AM GMT
WAN, WAN technologies, WAN hardware
asked by PRINCESS8

  5 pts.

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 ...

View Answer   |  Sep 8 2009  1:32 PM GMT
SQL Server 2000, Auto Grow, Database Sizing
asked by ITKE

  10180 pts.

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

View Answer   |  Aug 25 2009  6:35 PM GMT
SQL Server 2000, SQL datetime, SQL Troubleshooting
asked by DBM

  10 pts.

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

View Answer   |  Aug 20 2009  4:36 PM GMT
SQL Server 2000, SQL INSERT, SQL performance
asked by DBM

  10 pts.

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...

asked by Caruncles

  20 pts.

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...

asked by S0987

  5 pts.

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?

View Answer   |  Aug 3 2009  6:47 PM GMT
LDF, MDF, Data Recovery
asked by SQL Server Ask the Experts

  2445 pts.

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...

asked by SQL Server Ask the Experts

  2445 pts.

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...

View Answer   |  Jul 30 2009  4:11 PM GMT
SQL Server database, SQL Server 2000
asked by RAYNISH

  35 pts.

1 - 20 of 307
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>