SQL Server 2000

sql server 2000 how can i make backup 4 file only and restore

how can i make backup 4 file only and restore

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.

Formating Sysmessage text

How does SQl Server generate this error message What happens when an error occurs in a User defined Stored Procedure. Which System stored procedure is fired I know that the error messages are stored in "sysmessages" table in "Master" Database - but which system stored procedure calls this table...

Connection of Crystal Report 2008 with VB6.

Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..

How to move SQL Server databases to a new drive.

I have installed all my databases (nice_cls and nice_audit) in D:/ drive and need to move them to E:/ drive.

Is it possible to connect from the SSIS Analysis Services task to SQL Server 2000 Analysis Services?

Using the Analysis Services Processing Task in SSIS 2005, we are trying to connect to SQL Server 2000 Analysis Server cubes. While we are able to successfully create an Analysis Services connection, when we try to configure the task and specify the connection created above, we receive the following...

Field in crystal reports duplicating lines from quote

Using Crystal Reports XI on windows XP accessing SQL 2000 running on windows 2003 server using a Visual Manufacturing database. This is hard to describe accurately but here goes... I am running a report that uses QUOTE, QUOTE_LINE, QUOTE_PRICE and QUOTE_Binary_to_notes. QUOTE_Binary_to_notes is...

Migrate User & Permissions SQL 2000 to SQL XXXX

Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

Prevent unauthorized users from accessing SQL Server 2000

One of the SQL Server 2000 databases that I administer is configured for Windows authentication. I added an integrated logon for the domain user group. However, 20 of those in the domain user group who should not have access to the server are still able to access it. How can I prevent these...

Retrieving System information

I need to retrieve logins and users for all databases by server for SS2000 - 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the...

Moving .MDF files from SQL Server 2000 to 2005

Is it possible to just copy and paste .MDF files from SQL Server 2000 to 2005 instead of going through the whole migration process? My company doesn’t have the time that a full migration requires, so we are thinking about just keeping the files and pasting them once we have SQL Server 2005...

Transact SQL stored executed from AS/400 CL program.

How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.

Enterprise Manager problem

Any nvarchar column content is shown as <binary> when using table browsing or view from enterprise manager in SQL Server 2000.

Optimize the query in sql server

CREATE VIEW [dbo].[vwResults] AS SELECT r.ResultsPK, b.PersonID, dbo.ltcPerson.FirstName, dbo.ltcPerson.LastName, dbo.ltcPerson.PersonFriendlyID, b.DateCreated, b.FormName, r.FieldName, r.ValueString, r.ValueNumber, r.ValueDate, r.ValueTextInt, r.ValueBit, b.UserID,...

How to make VB6 and SQL Server 2000 multiuser and client-server?

how to make vb6 and sql server 2000 multiuser and client server??i use adodc for connection please tell me the source code. thx

Find exact point where SQL Server 2000 job fails

I am running an SQL Server Job, that executes a stored procedure with about 900 commands (mostly insert commands). The job was working OK, but suddenly fails, due to erroneous data (error message : overflow in converting numeric data to dadatype numeric !!). How can I find the exact point (command)...

Purpose of creating SQL Server stored procedures at run time

Hi Experts, I am a programmer in SQL. Please explain me the purpose of creating stored procedures during run time and it's effects on performance and memory. Please provide me if there is any best alternative for this. Thanks in advance

Bulk Insert with collation change

Hi, One of our client wants to change the collation of the database and the collation of the columns from SQL_Latin1_CP1_CS_AS to SQL_Latin1_CP1_CI_AS to match the SQL Server setting. So we are moving the data from one database to another database on the same server. We are re creating the...

Changing Database Collation

Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.

SQL Server Agent Job Creation

Hello, My self Ashish Amodia from India, I want to send Automatic mail with an attachment for that I have created job and from job that I want to open my web page automatically - I am using SQL server 2000. If u know how to open web page from job than please let me know :) Thank you