i was attaching northwind database with sql server 2005 so while attaching it gives me an error an exception occured while executing a transct -sql statemnet or batch ,unable to eon physical file "C:sql server 2000 sample database orthwnd.mdf"
View 6 Replies
Where can you download Northwind for SQLServer 2005? I tried this but there is no Northwind after the install... [URL]
View 1 RepliesFor 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 14, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'BILL'. 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
i have both sql2000 & 2005 on my system
i want attach tha database in sql2005.
if in case the database was mad ein sql2000 how do i attach in sql2005
or wht can be done??
When i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
im creating a database that needs a unique constraint on columns. does anyone know how to add this within the northwind database?
View 4 Repliesi need the northwind databse. i dont have it in the database where i can find it and who to add it to my database in sql server so can i c it in the combo box off the database
View 1 RepliesI have downloaded Northwind database here [URL]and at SSMS Express Edition, I attach the database but I'm getting this error User 'guest' does not have permission to run DBCC checkprimaryfile. (Microsoft SQL Server, Error: 2571)
View 2 RepliesI have created sample database in my SQL server 2005 database.Now i want that database should be password protect when i click on SQL SERVER DATABASE FILE. how to set password when anyone click on my sample database file it will show enter password field to enter into the database.
View 4 RepliesHow could one set a password on a database in Sql server 2005 & 2008
View 3 RepliesI am a new-bie in Asp.Net.I am working in a project where I need to store an attachment which will be uploaded by the user in radGrid into Sql server 2005 database.After storing this attachment, I have to retrieve this attcahment and show the same to the other users in radGrid so that they will be able to download the attachment and see that.How should I do that?what kind of datatype would it be?
View 2 RepliesI am a .net developer.I am not that strong in SQL.I need a simple query.This is from Northwind Database.
select 'Select All' as CustomerID,'Select All' as City union(select CustomerID, City from Customers
order by City)
i need to get output like 1st row should be Select ALl Select All and next rows should be output of this stat..(select CustomerID, City from Customers order by City)
i am not getting this...i can do by keeping the second query result in temp table and then using union... but i am looking without temp tables or simple query.
i m looking for northwind 2008 sample database. But i m unable to get the link. All links are for 2000 samples.
View 1 Repliesi had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
View 2 RepliesI want to attach the sql server database to my asp.net web application. How can i do it ?
View 1 RepliesI'm a newbie in development, and i'm facing a grave concern here. Sql Server Management Studio (2008) does not seem to be able to attach a database that i've already created in Sql Server 2005 express within my ASP.NET application. When I try to attach the database, by clicking "Attach" after right clicking the Database note in object explorer, I get to see a dialog box with an Add button. I then click that button, and try to navigate to the database, and I'm simply not able to reach that folder!!! The folder containing the databse physically exists, but i can't see it when i'm trying to browse to it.This is a Windows 7 (home edition) laptop, with VS 2008.
View 6 Repliesi m having an Hosting with Godaddy server , now my problem is i want to upload(attach) my machine database to godaddy sql server . i have also check all the function and configration on godaddy but i m not getting how i can do that. if i try to take remote connection , this also not possbile in godaddy ( due to security they are disable this function )wht is the other way i can attach my database (.bkp) file to live godaddy server.
View 7 RepliesI am having problem when i was trying to attach .mdf file while create a new connection of SQL server, create a new connection of SQL database file and open the database in Server Explorer. I am using VS 2010 Ultimate and SQL Express 2008 R2.
Here are the error message.
1. Attach .mdf in SQL database file and open the database in Server Explorer
2. Create a new SQL server and attach .mdf
I used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 RepliesI wan to retrieve spesific data from northwind and list in my compare page.
in the first page i used gridview with checkboxes. all selected values get with session and then
send to my second page. I can display this values in the page but how can i retrieve all product details from my northwind db i dont know.
here is my second page code behind.
[Code]....
and aspx page
[Code]....
I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesMigrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 RepliesPrevious developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
How can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesDoes anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 RepliesI have created my database in SQL Server 2005 Enterprise Edition and now planning to tranfer this databse to another server, But this other server is SQL Server Standard Edition, So if i try to attach my database which is created in Enterprise Edition will get sucesully connected to Standard Version ? or i will get any error message or i am doing something wrong ? This situation is fine or Version should be kept same ?
View 2 Replies
