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 a view in the DB: CREATE VIEW dbo.[Quote Binary to Notes] AS [...]

Answer Question   |  July 15, 2009  6:01 PM
Crystal Reports, Crystal Reports XI, SQL Server 2000, Visual Manufacturing, Windows XP

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.

Answer Question   |  June 25, 2009  4:26 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration, SQL Server permissions, SQL Server User Accounts, SQL Server user permissions, Upgrade from SQL Server 2000 to SQL Server 2005

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 unauthorized users [...]

Answer Question   |  June 23, 2009  4:06 PM
Integrated Logon, SQL Server 2000, SQL Server security, Windows authentication

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

Answer Question   |  June 18, 2009  5:53 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008

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 installed. Will [...]

Answer Question   |  June 14, 2009  4:49 PM
.MDF files, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server 2005 migration

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.

Answer Question   |  June 10, 2009  2:39 PM
554 transaction failure, AS/400, CL Program, SQL Database, SQL Server 2000, T-SQL Stored Procedures

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

Answer Question   |  June 4, 2009  12:37 PM
SQL Server 2000, SQL Server Enterprise Manager

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, b.BatchID, b.ParentID, r.Active, CASE WHEN b.ParentID = 0 THEN 0 ELSE 1 END AS IsChildRecord, CAST(b.PersonID AS varchar(4)) AS PersonIDStr FROM dbo.ltcBatch b INNER JOIN dbo.ltcResults r ON b.BatchID = r.BatchID INNER JOIN dbo.ltcPerson ON b.PersonID [...]

Answer Question   |  June 3, 2009  12:35 PM
SQL Server 2000, SQL Server Query, SQL Server query optimization

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

Answer Question   |  May 28, 2009  7:49 AM
ADODC, Client/Server, Multiuser, SQL Server 2000, VB 6, Visual Basic 6

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) where the job fails [...]

Answer Question   |  May 30, 2009  8:21 AM
SQL Server 2000, SQL Server development, SQL Server error messages

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

Answer Question   |  June 3, 2009  7:33 AM
RunTime, SQL Server 2000, SQL Server development, SQL Server stored procedures

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 database with the database and [...]

Answer Question   |  May 30, 2009  1:48 AM
Bulk Inserts, Database collation, Database migration, SQL Server 2000, System tables

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.

Answer Question   |  May 20, 2009  9:23 AM
Collation, Database collation, SQL Server 2000

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

Answer Question   |  May 15, 2009  4:48 AM
SQL Server 2000, SQL Server 2000 administration, SQL Server Agent, SQL Server Agent Jobs

SQL 2000 Upgrade
I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?

Answer Question   |  May 29, 2009  4:23 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades, Upgrade from SQL Server 2000 to SQL Server 2005

Deadlocks and Conflicting resources
I have a program that loops through a temp table, and for each row looks up a value in another table, and depending on the result returned inserts a record into one of two tables. Some days this takes 10 minutes to run and others it takes 2 hours to run. There are no other [...]

Answer Question   |  May 13, 2009  1:52 PM
SQL Server 2000, SQL stored procedures

SQL Server 2000 Database Table Limit?
Is there a limit to how many tables a single database can hold in SQL 2000?

Answer Question   |  May 7, 2009  8:18 PM
SQL Limits, SQL Server 2000, SQL Server database, SQL Server tables

How do you create stored procedures in SQL Server 2000?
How do you create stored procedures in SQL Server 2000?

Answer Question   |  May 15, 2009  7:18 PM
SQL Server 2000, SQL Server stored procedures

Execute a view/query is slower in SQL Server 2005 than 2000
Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query “select top 500 * from myview order by name”, it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely [...]

Answer Question   |  May 2, 2009  9:15 AM
SQL Server 2000, SQL Server 2005, SQL Server Query, SQL Server query optimization, VARCHAR

SQL Server Table and View Index
Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

Answer Question   |  April 28, 2009  9:29 AM
Index Scan, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server upgrades, SQL Server views