Problems While Attaching A Database In SQLServer 2000
Dear all,
I recive a error when i attaching a database in sqlserver 2000. The error is :-
An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Attaching SQL 2000 Database (.mdf) With Missing (.ldf) File
Hello Please can anyone help me I've been given a .mdf file from sql server 2000 which i need to attach but we do not have the .ldf file I am unable to recover the old .ldf file I have tried the attach single file command but obvioulsy this still looks for the old .ldf file path which no longer exists any help would be mostly appriciated many thanks Martin
View Replies !
View Related
Attaching Database To Sql 2000 Personel Eddition
Hi, I m going to attach my databse file to newly installed sqlserver 2000 personel eddition. But when I click the ok button (right click on the database> alltasks> attachdatabase> ). I found the error like Error 602: Could not find row in sysindexes for database ID 7, Object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Can anyone tell me how can I do this to attach database. Navi
View Replies !
View Related
Trying To 'load' A Copy Of A SQLServer 2000 Database To SQLServer 2005 Express
I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file. I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that? The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express. Thanks!!
View Replies !
View Related
Spin Loop Attaching Database In 2000 =&&> 2005 Upgrade
I just upgraded a large SQL 2000 database server to SQL 2005, and I have 2 databases that won't attach to the 2005 Server. They are both very small, about 90MB in size, and when I attach them to 2005, the process alternates between running and spinloop status. It can sit forever, and will never complete. I restored backups before the upgrade to a SQL 2000 Server, and reran DBCC CheckDB on both, and got no consistency errors, Updated Stats and indexes, then detached and moved the data files to 2005, and same thing.
View Replies !
View Related
Problem With Showing Diagrams When Attaching A Sql Server 2000 Database In Sql Server 2005
I have a database created in MS SQL Server 2000 with some tables and diagrams.I have attached that database in SQL Server 2005 but when i want to access and showthe diagrams i face the following error message :Database diagram support object can not be installed because this database does not havevalid owner,to continue first use the files page of database dialog box or alter the authorizationstatement to set the database owner to valid login then add the database diagram support object.I have created a role with required permissions but i still have the problem(I still can't show the diagrams withthe new user(role) )Has anyone faced this problem too?Can anyone help ?
View Replies !
View Related
Remote Hosted Database - SQLServer 2000
Hi allWe have a small database that we host on our own local server. In order toget the information into the database I have a VB program that collates theinformation from a variety of sources and then over our local internalnetwork writes it to the database tables.This information is then made available over the internet using thecompanies broadband connection. In order to alleviate bandwidth issues weare looking at paying for someone else to host the database.What I am hoping to achieve is to keep the VB software, but during the nightupload the data to the remotely hosted SQL server using say a series ofupdate statements. Does anyone know if this is possible, and will SQL Serverlook after the integratory of the data. Is there any issues with therelatively low speed of then Internet as compared with a local networkenvironment. The amount of data we are looking at moving is very little,some where in the region of a few hundred records per night split over about10 tables.many thanksAndy
View Replies !
View Related
Attaching Sql 2000 Db To 2005
Hi, I have made a backup of a sql 2000 database that was on the server at work and and I would like to use it in sql 2005 express on my home laptop. Can anyone help? I can't seem to work out how to do it. Do I restore it or re-attach it? Is it possible? Sorry if these are basic questions. Mark
View Replies !
View Related
Problem Unicode Data 0x2300 In SQLServer 2000 SQLServer 2005 Express
Hi experts; I have a problem with unicode character 0x2300 I created this table create table testunicode (Bez nchar(128)) Insert Data insert into testunicode (Bez)values('Ś€„˘') with 2 Unicode characters Ś€ = 0x2300 „˘ = 0x2122 Selecting the data select Bez from testunicode I see "?„˘" „˘ = 0x2122 is ok but instead of 0x2300 there is 0x3f When I modify the insert statement like that ( 8960 = 0x2300 ) insert into testunicode (Bez)values(NCHAR(8960)+'„˘') and select again voila i see "Ś€„˘" Does anyone have an idea? Thanks
View Replies !
View Related
SQLServer Express And SQLServer 2000/2005 Coexist Problem
Hi SQLServer expert, I have SQLServer 2000 and SQLServer 2005 Express installed in the same PC. I tried to install SQLServer 2005 Dev Ed in the same box with a named instance. The installation is successfully. After rebooting the PC, the SQL2005 service can't startup, while both SQLServer 2000 and Express can startup successfully. The error msg is "Could not start the SQLServer (SQL2005) service on Local Computer. Error 1053 : The service did not respond to the start or control request in a timely fashion" I also noticed that the MS SQL management Studio is not in the problem folder. Current config =========== SQLServer2000 : default instance SQLServer Express : SQLEXPRESS SQLServer 2005 Dev : SQL2005 Any one can help ? AU SQLguy
View Replies !
View Related
Attaching A SQL Server 2000 DB W/out The Log File
How do I reattached a SQL server database if the log file was not backed up and none is available. Our server went belly up and the backups were only copying the *.MDF files. The log files were not being included in the backup for some reason. I know in version 7.0 you could reattach with out the log file but I am having a more difficult time figuring out how to get around thin in SQL 2000. Anybody got any ideas??? Thanks!!!
View Replies !
View Related
Replacing Sqlserver 2000 With Sqlserver 2005 Express
I have an app that uses a sqlserver 2000 jdbc driver to connect to a sqlserver 2000. Is it possible to do a direct replacement of sqlserver 2000 with sqlserver 2005 express just by reconfiguring the app to point to the express? The app would still be using the sqlserver 2000 jdbc driver to try and make the connection. If that is a possibility, what can be some differences in the configuration? Previously with 2000 the config information I entered is: server name: "machinename"( or ip). I've also tried "machiname/SQLEXPRESS" DB name: name of db instance port: 1433(default) user and pass. My attempts so far results in "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket." and "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL."
View Replies !
View Related
Attaching A .mdf File To The MSSQL 2000 Using Commandline
Hi , we have a requirement to create a database of our application in client's system. and we assume that already MS Sql server is installed. we have a .mdf file of our database. Is there any way I can attach .mdf file to the database using command line. so that I can write a batch file and run that batch to create the database in our client's system. -regards GRK
View Replies !
View Related
Attaching Northwind (2000) Into SQL Server 2005
I am trying to attach to the SQL Server 2000 sample Northwind database using SQL Server 2005. When I do the Database-->Attach using the GUI everything seems alright. I can open the Northwind database and see the usual listing of stuff. However, when I click on the Database Diagrams, I get an error message stating "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database support objects." I have tried repeatedly to get the ALTER AUTHORIZATION statement to work, all to no avail. I have restarted my machine, and the properties of the database is now saying that the owner is the same as the other databases I have, but I keep getting the error message.What am I doing wrong here? How can I fix this? Any help would be greatly appreciated. Thank you.
View Replies !
View Related
Error Attaching Adventureworks Database And SSIS Training Database
Hi there, I got this error when i tried to attach the adventureworks database and SSIS training database. an exception occurred while executing a transact-sql statement or batch (microsoft.sqlserver.connectioninfo) could not find row in sysindexes for database ID 17, object ID 1, index ID 1. Run DBCC checktable on sysindexes. I join join a network domain for my computer. Previously it doesnt have this problem.
View Replies !
View Related
Attaching A Database
The situation : I am making mass changes to my program and database. The goal is to not make changes to the database at the customer sites, but to clone their current database, and work with that one. The solution: I wrote code and queries to detach the database, copy it to another directory on the same computer with a different name, then attach it with the new name. The process is: run : sp_detach_db "' + aDatabase + '", ''false'';' (aDatabase is the original database name) Then, in code, delete the original .ldf file, and copy the database.mdf file to new directory with new name. then run (for both the new and the original databases): Create Database "' + aDatabase + '" on (NAME = ''' + aDatabase + ''', FILENAME = ''' + FormatFilePath(aPath) + aDatabase + '.mdf'' For Attach This works, up to a point. The problem : When I inspect the properties of the newly attached database, with the new name and new directory, the logical name of the database is still the original name. I TRIED running this query : sp_attach_single_file_db @dbName= "' + aDatabase + '",' @physname= ''' + FormatFilePath(aPath) + aDatabase + '.mdf' but it returns(even though I have deleted the .ldf files for the original dataset) : Could not open new database 'Test62'. CREATE DATABASE is aborted. Cannot create file 'E:Data6Test62Test62_log.LDF' because it already exists. Change the file path or the file name, and retry the operation. File activation failure. The physical file name "E:Data6TestTest_log.LDF" may be incorrect. (original database name = data6 est est, new database name is data6 est62 est62) Is there a way to do this? Or do I just need to give it up?
View Replies !
View Related
Help Attaching The Database
hello i am having a problem attaching database. The Problem : I have created a database using sqlserver express edition.now i have installed enterprise edition ,so i am attaching the database which is created in sqlserver express edition into the enterprise edition.it is showing error TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'SRINIVAS'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Could not find row in sysindexes for database ID 13, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'FMS'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Can anyone Help me thanks
View Replies !
View Related
Help - Error In Attaching Database
i try to attach sqlserver db but i get this error TITLE: Microsoft SQL Server Management Studio Express------------------------------ Attach database failed for Server 'srvsqlsrv'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. (Microsoft SQL Server, Error: 5173) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=5173&LinkId=20476 ------------------------------BUTTONS: OK------------------------------ what i will do to solve this error
View Replies !
View Related
SQl 7.0 Issue While Attaching A Database
Hi,I am tring to attached a database in SQL using the following command.Can any one please help. Basically I have a MDF and LDF files which Ineed to open in SQL 7.0, these files are from a diff SQL7.0 machinewhich is crashed.PLEASE HELP. There are many valuable info in the database.Command :EXEC sp_attach_db @dbname = N'Digitalindia',@filename1= N'C:SqlMaster.MDF',@filename2= N'C:SqlMaster.LDF'Error :Server: Msg 5172, Level 16, State 15, Line 1The header for file 'C:SqlMaster.MDF' is not a valid database fileheader. The PageAudit property is incorrect.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View Replies !
View Related
Attaching And Detaching A Database
Q1.)In SQL Server 2000, is it always possible to use copies of thedata and transaction log files of a database from one server toreattach to a new database on another server, or even to the sameserver, without first detaching from the existing database?Books Online says that detaching a database closes the data and logfiles cleanly. I read some where that some times, it is possible toattach without detaching, if the data and log file are in stablestate.This is what I tried - Tried to copy Northwind.mdf and ldf files usingwindows explorer and it gave an error message that the files are inuse. I shutdown the server and now I could easily copy them. Afterthat I renamed these files and successfully attached them as a newdatabase.Q2.)Is it possible to do the same with large production databases?Q3.) Please explain what goes on during detaching /attaching process.Thanks in advanceRavi
View Replies !
View Related
Problem In Attaching Database
Hi all, I am facing a problem during attaching a database (.mdf and .ldf files are copied fro another server). the message I am getting as follows: messages was from 'Microsoft SQL Server Management Studio Express': =================================== Attach database failed for Server 'CTPL-1'. (Microsoft.SqlServer.Express.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.Exceptio nTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabase(String name, StringCollection files, String owner) at Microsoft.SqlServer.Management.SqlManagerUI.Attach DatabaseData.PrimaryFile.Attach() at Microsoft.SqlServer.Management.SqlManagerUI.Attach Database.SendDataToServer() =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Program Location: at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection queries) at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions) at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabase(String name, StringCollection files, String owner) =================================== Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'mci'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476 ------------------------------ Server Name: (local) Error Number: 602 Severity: 21 State: 50 Line Number: 1 ------------------------------ Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) =============================================== ******************************** the followings are the command and mesage from Query Analyzer: ***************************************** command: -- ============================================= -- Attach database via sp_attach_db -- ============================================= EXECUTE sp_attach_db @dbname = N'mci', @filename1 = N'd:ifgldatabasemci.mdf', @filename2 = N'd:ifgldatabasemci_log.ldf' GO ***************************************** message: Server: Msg 602, Level 21, State 50, Line 1 Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Connection Broken ******************************************* I am new to MS SQL Server and unable to solve the problem. Can anyone help me in this metter. Thanks in advance.
View Replies !
View Related
Attaching Database On Create
Hi, My current server going nuts it restaring every one hour, I have 200+GB (80+ files) database size. The network guyes don't have backup. This is what I am trying to do. I have detach my database. I have copied all the file to new server. Now i am trying to attach using create, I can't just use attach because 16+ files. When I run following on my server it gives me an error. Any help will be highly appreciated. please email me the answer if you have. Thanks. Samir CREATE DATABASE KEYFILE ON PRIMARY (NAME= 'KEYFILE001' FILENAME='F:KEYFILEDBKEYFILE001.MDF') ON SECONDARY (NAME='KEYFILE002' FILENAME='F:KEYFILEDBKEYFILE002.NDF') ON SECONDARY (NAME='KEYFILE003' FILENAME='F:KEYFILEDBKEYFILE003.NDF') ON SECONDARY (NAME='KEYFILE004' FILENAME='F:KEYFILEDBKEYFILE004.NDF') ON SECONDARY (NAME='KEYFILE005' FILENAME='F:KEYFILEDBKEYFILE005.NDF') ON SECONDARY (NAME='KEYFILE006' FILENAME='F:KEYFILEDBKEYFILE006.NDF') ON SECONDARY (NAME='KEYFILE007' FILENAME='F:KEYFILEDBKEYFILE007.NDF') ON SECONDARY (NAME='KEYFILE008' FILENAME='F:KEYFILEDBKEYFILE008.NDF') LOG ON SECONDARY (NAME= 'KEYFILE_LOG' FILENAME='F:KEYFILEDBKEYFILE_LOG.LDF') FOR ATTACH
View Replies !
View Related
Attaching A Removable Database
Hi, I wanted to create a removable SQL Server 7.0 database. So I created the database using the sp_create_removable system stored procedure, imported objects and data, ensured that the database is configured properly for distribution on removable media (using sp_certify_removable system stored procedure), and detached it from original SQL Server. So far, so good. The database consists of 3 files: MYDB_SYS, MYDB_DATA and MYDB_LOG. I copied MYDB_DATA on a CD, and MYDB_SYS and MYDB_LOG on hard disk of a different server. If I execute the following statement: Execute sp_attach_db @dbname = 'MYDB' , @filename1 = 'C:MYDB_SYS.MDF' , @filename2 = 'E:MYDB_DATA.NDF' , @filename3 = 'C:MYDB_LOG.LDF' I get the following messages: Server: Msg 5105, Level 16, State 4, Line 1 Device activation error. The physical file name 'E:MYDB_DATA.NDF' may be incorrect. Server: Msg 945, Level 14, State 1, Line 1 Database 'MYDB' cannot be opened because some of the files could not be activated. Server: Msg 1813, Level 16, State 1, Line 1 Could not open new database 'MYDB'. CREATE DATABASE is aborted. I can successfully execute the above statement if I make MYDB_SYS.MDF file read only, but then MYDB is created as read only, and this option can not be changed. Please, help. Maja
View Replies !
View Related
Attaching A Database With Only An Mdf File
I am trying to attach a database and only have a valid mdf file. Is this possible? I tried sp_attach_single_file_db but it fails with a device activation error. It seems to be trying to load the LDF file which is on a drive that exists on the old server but not on the new server. Any advice would be appreciated.
View Replies !
View Related
Attaching AdventureWorks Database
Today I installed SQLEXPR.EXE that I found here: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476 I made sure that I downloaded the 64-bit version. I then wanted to download and install the Adventure Works database located here: http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en Since I am running Vista 64-bit, I downloaded and installed AdventureWorksDB_x64. It wouldn't install. I got "Access is denied" and CREATE FILE error plus several others. I then uninstalled it and downloaded AdventureWorksDB - this is the X86 version. It installed fine. Can anyone explain what am I missing? Thanks!
View Replies !
View Related
More Problems Attaching A Database
Hi Mike, I've had a look at the white paper on use instances and also stopped using Management Studio, as you suggested. The problem is that I can run my application from VWD quite happily, until for no reason the application can't connect to the database. This happens ramdomly and is very frustrating. I have worked out a way to correct this problem with the following method (I don't know if this is correct but it's the only work around I know. 1) I close down VWD and open Management Studio, 2) I right click to attach a database, and then navigate to the .mdf file for the database, and click to attach it. I then delete the existing icon for that database (which I can't acess anyway, it only shows me the main icon but not the tables) 3) I rename the new instance of the database to the correct name (minus path info etc) 4) I create an SQL script as follows: EXEC sp_grantlogin 'jonASPNET' (This line executes correctly), Then I enter these lines: USE BalloonShop *name of database * EXEC sp_grantdbaccess 'jonASPNET' (At this stage when I execute the query, Management Studio informs me that this name already exists in the database and so doesn't execute) 5) I now close out of Management Studio and re-open VWD, and I can now run my application correctly. I know I've got some configuration settings wrong somewhere but I find the whole user instance thing confusing. For the record I'm running the appllication through VWD's built in web server, I did originally have it through IIS but I moved it (this will explain the confusion of locations from my first post, I gave you the original location, sorry about that). Any advice you can give would be gratefully recieved, ie is there an easy way to reconfigure my settings to make everything work as expected or have I got to start the database again from scratch (not a pleasent thought). Also is there an idiots guide to SQL Server Express anywhere that I can read. Jon ps I've just realised that I get the 'can't connect to database problem when running the application after I've made a change to the database from VWD ie adding a new stored proceedure, Don't know if this helps, but better you get the full picture.
View Replies !
View Related
Problems Attaching To Database From VWD
Hi Mike, I hope you can help me with my SQL Server Express problem. I have a database that was created in VWD Express 2005, that is currently in C:web projectsproject nameApp data...etc. I have been able to connect to and use the database with an application that I am building as a learning exercise, ( I'm a complete newbie to .NET and SQL Server) but now I can't connect to the database from SQL Server manager. I have tried attaching the file which has worked a few times, but now that won't work either. I keep getting a message that the file can't be found or I do not have sufficient permissions to access it. I can connnect to the file fine from within VWD, but because of the above problem I can't now run the application (it throws an exception). I suspect that I've got some of the basic configuration settings wrong, but I really don't know where to start looking. Below is an example of one of the messages I've been getting Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) CREATE FILE encountered operating system error 32(error not found) while attempting to open or create the physical file 'C:InetpubwwwrootBalloonShopApp_DataBalloonShop.mdf'. (.Net SqlClient Data Provider) Any help would be very gratefully recieved regards jon
View Replies !
View Related
Error On Attaching A Database
When attaching a database that was detached from another SQL Server instance(copied raw .mdf and ldf files).. I got the error message below: Error 602: Could not find row in sysindexes for database ID 25, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. how can i solve this problem. i am using SQL Server 2000 Thanks and Regards
View Replies !
View Related
Attaching A Database To Sql Express
I'm trying to attach a database to sql express with the following code from the management tool. I keep getting an error message. An someone explain what I'm doing wrong. Msg 102, Level 15, State 1, Line 9 Incorrect syntax near '<'. IF NOT EXISTS( SELECT * FROM sys.databases WHERE name = N'<northwind.mdb, I4V0Y6SQLEXPRESS, northwind>' ) CREATE DATABASE <database_name, sysname, your_database_name> ON PRIMARY (FILENAME = '<c:my documentsmy websmyweb3,,C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDataorthwind.MDF>') FOR ATTACH GO Ira
View Replies !
View Related
Problem Attaching A Database
I've created a simple database using Visual Web Developer Express. I is located in "C:Documents and SettingsRomanMy DocumentsVisual Studio 2005WebSitesNewSiteApp_Data" Folder. When I try to attach this database using SQL SERVER Management Studio Express: it doesn't allow me to view the contents of "C:Documents and SettingsRoman" Folder - it just won't expand any further!!!!! Anyone had a similar problem. I think it is some sort of a bug, maybe Please help! Thanx Michael
View Replies !
View Related
Error While Attaching Database
hi all i am working on sql server 2005 When i am trying to attach database in my server i am getting following error. Plz help me to fix this error. the error as as follows : Attach database failed for Server 'myserver'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'ReportServer'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
View Replies !
View Related
Error While Attaching Database
hi all i am working on sql server 2005 When i am trying to attach database in my server i am getting following error. Plz help me to fix this error. the error as as follows : Attach database failed for Server 'myserver'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'ReportServer'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
View Replies !
View Related
|
TRACKER
