SQL Server error message ‘Could not find the index entry for RID ’1628000000a412030044160000869a0000040000′ in the database
I’m getting the error ‘Could not find the index entry for RID ’1628000000a412030044160000869a0000040000′ in the database. The table is a very big table and lots of transactions are happening every minute. Please let me know what would be the possible cause and solution for this problem.

Answer Question   |  May 7, 2008  4:21 PM
Index, SQL Server, SQL Server errors

Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?
I’m setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

Answer Question   |  May 7, 2008  4:12 PM
Database mirroring, SQL Server 2005, SQL Server alerts

Is there a query to search text of all SQL Server database objects that reference a specific table/instance?
We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

Answer Question   |  May 9, 2013  3:49 PM
Database objects, Query, SQL Server migration

Error when upgrading SQL Server 2000 to SQL Server 2005
I am upgrading SQL Server from 2000 to 2005. While upgrading I have received the below mentioned error. Kindly review and advise me on this. By the way, I have sufficient disk space on my server. “TITLE: Microsoft SQL Server 2005 Setup SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Database ‘msdb’ [...]

Answer Question   |  May 7, 2008  3:29 PM
SQL Server errors, SQL Server upgrades, Upgrades

Query error when using application role with ADO connection
I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error domainusername does not have a logon on database (referring to the second database). Is there any way around it? [...]

Answer Question   |  May 7, 2008  3:23 PM
ADO, Application development, Domain, SQL Server development, SQL Server errors

How to perform exploratory database testing using ERDs
Can you please advise me on how to perform exploratory testing on a database using ERDs?

Answer Question   |  May 15, 2008  3:05 PM
Database testing, ERD (Entity Relationship Diagram), SQL Server database design and modeling

How to Schedule jobs in DTS in sql server 2000
I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

Answer Question   |  May 7, 2008  5:14 AM
DTS, SQL Server 2000, SQL Server Agent

Connect to Sybase ASE 15 via MS SQL 2005
I’m in a test phase and would like to connect to a Sybase ASE 15 server in much the same way as linking tables in access. How would I accomplish that?

Answer Question   |  May 14, 2008  9:06 PM
SQL Server 2005, Sybase, Sybase ASE 15

Backup SQL database with BRMS AS400
Running BRMS on i520 v5r4 LTO 4 tape library. Company just installed on seperate machines, same network: Windows2003 Server with MSSQL Database. I want to use BRMS and our robust LTO library system to get to the data on the SQL Database. Have little success with the LTO 4 being supported by Microsoft. Any suggestions?

Answer Question   |  May 7, 2008  3:42 PM
AS/400 backup, BRMS, SQL Server

datetime conversion
SQL Analyzer has issues w/below relative to the datetime conversion- – what is the problem? convert(varchar(10),ft.postdate,101) ‘PostDate’,

Answer Question   |  May 6, 2008  3:31 PM
DateTime, SQL Query Analyzer

How do my database sql2005 database to another server with management studio
Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.

Answer Question   |  May 7, 2008  2:10 PM
SQL Server 2005, SQL Server backup, SQL Server Management Studio

DB size
Hi, I am using a software which is using SQL DB. Each time there is an error (one of the tasks fails) the DB grows. I would say over 1G per day! Currently I have DBs which are 45G and I am running out of space. Anyone has any idea how to shrink the DBs [...]

Answer Question   |  May 5, 2008  3:30 PM
SQL Server 2000, SQL Server logs, SQL Server performance tuning

Suspect DB
Hi, I am using sql server 2000 and recently found 2 of the DBs are marked as Suspect and I don’t have access to them any more.Would you please help me with this? Thanks, Ellie

Answer Question   |  May 15, 2008  3:24 PM
SQL Server 2000, SQL Server security, Suspect database

Can’t Install SQL Server 2000 on Window XP SP2
I try to install SQL Server 2000 on Window XP SP2, but there is an error message mean “OS not support.”. What should I do? How can I install SQL Server 2000 on Window XP SP2? Please, give me the best and detail answer. Thanks.

Answer Question   |  May 2, 2008  4:29 AM
SQL Server 2000, SQL Server errors, Windows XP

update query fails as table gets locked by select query (sql blocking issue).
I have a perl script which updates some table records in sqlserver 2000, the flow is like below: * A select query This select query selects IDs(with other records too) * An update query This update query updates a bit column from 0 to 1 for the IDs retrieved from above select query. The problem [...]

Answer Question   |  May 2, 2008  9:32 PM
Perl, SQL Server 2000

Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!
Hello Community If you haven’t noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and [...]

Answer Question   |  May 14, 2008  3:51 PM
AS/400, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Networking, Oracle, SAP, SQL Server, Storage, Virtualization, VoIP

having problem with SSIS package
i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

Answer Question   |  May 2, 2008  7:12 PM
SQL Server Management Studio, SSIS, SSIS Package, SSMS

DTS schedule package
How can I see the scheduled run time of an existing DTS package?

Answer Question   |  May 1, 2008  7:09 PM
Data Transformation Services, DTS, Schedule Performance Index (SPI), SQL Server 2000

How to use partitioning in SQL Server database to avoid ‘timeout’ errors
We have over 300 stores, and with each store having 30gb+ databases, each server is being upgraded to at least 6gb+ memory which is being forced allocated to SQL Server. I want to start to partition the existing SQL Server database by date. How do I go about doing it, because I have absolutely no [...]

Answer Question   |  May 2, 2008  6:01 PM
Partitions, SQL error messages, SQL Server performance tuning, Timeout

Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005
I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any problems with stored [...]

Answer Question   |  May 2, 2008  5:51 PM
DTS, SQL Server 2000, SQL Server 2005, SQL Server upgrades