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
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
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
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
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
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
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
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??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
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
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
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
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
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
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
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
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?
Answer Question | May 15, 2009 7:18 PM
SQL Server 2000, SQL Server stored procedures
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
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