How Can I Return A Database From The DataBase Explorer Of VB 2005 Express To The Object Explorer Of SQL Server Management Studio
Hi all,
I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.
Thanks in advance,
Scott Chang
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Server Management Studio Express: Object Explorer - How To Re-attach The Content Of User-defined Database
Hi all, I just found that the content of my Database "ssmsExpressDB" is gone, but the name "ssmsExpressDB" remains in the Object Explorer of SQL Server Management Studio Express. If I delected the name "ssmsExpressDB" and executed the following .sql: exec sp_attach_db @dbname = N'ssmsExpressDB', @filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf', @filename2 = N'C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB_log.LDF' GO I got the following error message: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". And I have closed all my projects and I do not know what " The process cannot access the file because it is being used by another process" is all about!? Please help and tell me how I can re-attach the content of my "ssmsExpressDB" in the Object Explorer of SQL Server Management Studio Express. Thanks in advance, Scott Chang ==================================================================================== I found the "ssmsExpressDB" is being used by my VB 2005 Express project "Hello-SQLCLR-1": in the Database Explorer, Data Connections place. How can I put it back to the Object Explorer of SQL Server Management Studio Express? Please help and advise. =======================================================
View Replies !
SQL Server Management Studio Express: Object Explorer - How To Re-attach The Content Of User-defined Database
Hi all, I just found that the content of my Database "ssmsExpressDB" is gone, but the name "ssmsExpressDB" remains in the Object Explorer of SQL Server Management Studio Express. If I delected the name "ssmsExpressDB" and executed the following .sql: exec sp_attach_db @dbname = N'ssmsExpressDB', @filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf', @filename2 = N'C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB_log.LDF' GO I got the following error message: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". And I have closed all my projects and I do not know what " The process cannot access the file because it is being used by another process" is all about!? Please help and tell me how I can re-attach the content of my "ssmsExpressDB" in the Object Explorer of SQL Server Management Studio Express. Thanks in advance, Scott Chang ==================================================================================== I found the "ssmsExpressDB" is being used by my VB 2005 Express project "Hello-SQLCLR-1": in the Database Explorer, Data Connections place. How can I put it back to the Object Explorer of SQL Server Management Studio Express? Please help and advise. =====================================================================================
View Replies !
SQL Server Management Studio Express, Database Explorer In Visual Web Developer Express...which To Use???
When I downloaded/started using Visual Web Developer I was under the impression that I needed to install SQL Server Management Studio Express in order to create/manage databases, and to provide the engine to access the data. Since then I have found tutorials and have successfully created/used databases solely from within Visual Web Developer. I'm assuming that Visual Web Developer includes a database engine, much like the webserver that is included. (This is an awesome thing). When I tried to upload my web application with database to my production server, the database would not work, it started working after I installed SQL Server Management Studio Express on the server. Is it my understanding that you need SQL Server Management Studio Express if you do not have Visual Web Developer Express installed in order to provide the data access engine? Also, I am unable to "attach" my Visual Web Developer Express created database to SQL Server Management Studio Express. Are there any posts that provide more information about this topic? The only reason I'm asking is that I have extra whitespace on the end of my text fields, and I thought ANSI_PADDING was turned on. I do not see the option in Visual Web Developer Express, but have found it in SQL Server Management Studio Express.
View Replies !
Microsoft SQL Server 2005 Management Studio - Opening SQL-File From Explorer Does Not Connect Automaticly To Server/database
hello, I have a question about opening files in the Microsoft SQL Server 2005 Management Studio. In the old Query Analyzer from SQL 2000 I can open SQL Files via drag & drop (from explorer to QA) or open it with a double click in the explorer. Then the Files opened, if I had actual a connection to a server / database (QA is stared with one file and has a connection to Server/Datebase), with this connection. Now in Microsoft SQL Server 2005 Management Studio I'll be asked everytime for Server and have to get the database from the database list - it does not connect automaticly to server/database, that is actual connected (I have opened a file with the connection and a connected database in the object explorer). Someone do not have this problem - but we found no option to set it up. Any ideas? thanks & best regards, Christian Kiedels
View Replies !
2005 Database Will Be Shown In Management Sudio Express Or App_Data/Database Explorer?
I have installed 2 SQL Server 2005 Express sample databases from 2 books, ASPnet 2.0 and ADOnet 2.0. The ASPNETDB.MDF was shown in App_Data and Database Explorer, but not in the SQL Server Management Studio Express. The AdoStepBy Step database created by a ConfigDB.exe was displayed in the Management Studio, but not in the App_Data, or Database Explorer. Is this the way SQL Server 2005 runs the 2005 databases for SQL Server 2005 Express only? Or also in SQL Server 2005? TIA, Jeffrey
View Replies !
Sql Server 2005 Express: Can't See [DatabaseMail] Node In Manamgent Studio's Object Explorer
I use Windows Vista Home Premium Here's my Help About Info: Microsoft SQL Server Management Studio Express 9.00.3042.00 Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205) Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 7.0.6000.16546 Microsoft .NET Framework 2.0.50727.1433 Operating System 6.0.6000 I opened up the Surface Area Configuration Tool and chose the "Surface Area Configuration for Features". Choose "Database Mail" and clicked the checkbox "Enable Database Mail Stored Procedures" When I go into the Management Studio, I can't see the "Database Mail" node under "Management" I'm thinking I might need a service pack as in the about, I don't see a service pack listed. BUT, when I go to the SQL Server 2005 Express "Service Pack 2" page, there's no option to just download the Service Pack. I recently downloaded (2 weeks ago or so) this Sql Server Express Edition and I'm thinking this might have Service Pack 2 already, but I'm not sure as I don't see it in the "about". What should I do?
View Replies !
SQL Server Management Studio Express (SSMSE)=&&>Object Explorer=&&>Databases Has C:SSMSE-BookChapter12WINCH12NORTHWND.MDF?
Hi all, In my SQL Server Management Studio Express (SSMSE)=>Object Explorer=>Databases, the "NORTHWND" database was screwed up and is deleted completely. But under the same Object Explorer =>Databases, there is a database "C:SSMSE-BookChapter12WINCH12NORTHWND.MDF". I need to use this "NORTHWND" database in the SqlConnection. How can I specify the "Initial Catalog" (or "database") in the New SqlConnection code statement (in the ADO.NET 2.0-VB 2005 Express programming)? Should it be like the following: Dim sqlConnection As SqlConnection = New SqlConnction("Data Source=.SQLEXPRESS; Initial Catalog=C:SSMSE-BookChapter12WINCH12NORTHWND; Integrated Security=SSPI;") ? Or what is the right code statement for connecting to it? Please help and advise. Thanks in advance, Scott Chang
View Replies !
Server Explorer Different Than Management Studio Express
Using the starter kit, Personal Web Site, I start by adding a new user to the Administrator Role in the the the SQLExpress database by using the Graphical Web Administrator Tool . Then, using the Personal Web Site application in Visual Studio 2005 (not the Web Developer Express 2005) , I register a new account. When I examine Server Explorer, I can see 2 users in aspnet_Membership and 2 users in aspnet_User tables. However, when I use SQL Server Management Studio Express, I only see 1 user in both of those tables. Is there a reason for this?
View Replies !
Northwind Database In SQL Server Management Studio Express Is Lost Or Used/processed By VB 2005 Express:How To Locate/return It
Hi all, In the last one and half years, I used the Northwind Database in SQL Server Management Studio Express (SSMSE) to learn the programming of SqlConnections, Data sources, Database Exploere, ADO.NET 2.0, etc. via VB 2005 Express. The Northwind Database in my SSMSE got lost very often, but I was not aware of it. How can I know where the Northwind Database is used or processed by my VB 2005 Express projects that were the examples of some tutorial books or my trial projects? How can I release the Northwind Database back to my SSMSE from the VB 2005 Express projects? Please help and advise. Thanks in advance, Scott Chang
View Replies !
Right Code Statements Of SqlConnection && ConnectionString For Connecting A Database In Database Explorer Of VB 2005 Express?
Hi all, In the VB 2005 Express, I can get the SqlConnection and ConnectionString of a Database "shcDB" in the Object Explorer of SQL Server Management Studio Express (SSMSE) by the following set of code: ///--CallshcSpAdoNetVB2005.vb--//// Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Public Class Form1 Public Sub InsertNewFriend() Dim connectionString As String = "Data Source=.SQLEXPRESS;Initial Catalog=shcDB;Integrated Security=SSPI;" Dim connection As SqlConnection = New SqlConnection(connectionString) Try connection.Open() Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection) command.CommandType = CommandType.StoredProcedure ....................................... etc. /////////////////////////////////////////////////////// If the Database "shcDB" and the Stored Procedure "sp_inertNewRecord" are in the Database Explorer of VB 2005 Express, I plan to use "Data Source=local" in the following code statements to get the SqlConnection and ConnectionString: ......................... ........................ Dim connectionString As String = "Data Source=local;Initial Catalog=shcDB;Integrated Security=SSPI;" Dim connection As SqlConnection = New SqlConnection(connectionString) Try connection.Open() Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection) command.CommandType = CommandType.StoredProcedure ........................ etc. Is the "Data Source=local" statement right for this case? If not, what is the right code statement for my case? Please help and advise. Thanks, Scott Chang
View Replies !
Calling Stored Procedures From ADO.NET-VB 2005 Express:1)Compile Errors && Warnings,2)Northwind Database In Database Explorer?
Hi all, I try to learn "How to Access Stored Procedures with ADO.NET 2.0 - VB 2005 Express: (1) Handling the Input and Output Parameters and (2) Reporting their Values in VB Forms". I found a good article "Calling Stored Procedures from ADO.NET" by John Paul Cook in http://www.dbzine.com/sql/sql-artices/cook6. I downloaded the source code into my VB 2005 Express: Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Public Class Form_Cook Inherits System.Windows.Form.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox Friend WithEvents labelPAF As System.Windows.Forms.Label Friend WithEvents labelNbrPrices As System.Windows.Forms.Label Friend WithEvents UpdatePrices As System.Windows.Forms.Button Friend WithEvents textBoxPAF As System.Windows.Forms.TextBox Friend WithEvents TenMostExpensive As System.Windows.Forms.Button Friend WithEvents grdNorthwind As System.Windows.Forms.DataGrid Friend WithEvents groupBox2 As System.Windows.Forms.GroupBox <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.GroupBox1 = New System.Windows.Forms.GroupBox() Me.labelPAF = New System.Windows.Forms.Label() Me.labelNbrPrices = New System.Windows.Forms.Label() Me.textBoxPAF = New System.Windows.Forms.TextBox() Me.UpdatePrices = New System.Windows.Forms.Button() Me.groupBox2 = New System.Windows.Forms.GroupBox() Me.TenMostExpensive = New System.Windows.Forms.Button() Me.grdNorthwind = New System.Windows.Forms.DataGrid() Me.GroupBox1.SuspendLayout() Me.groupBox2.SuspendLayout() CType(Me.grdNorthwind, System.ComponentModel.ISupportInitialize).BeginInit() Me.SuspendLayout() ' 'GroupBox1 ' Me.GroupBox1.Controls.AddRange(New System.Windows.Forms.Control() {Me.labelPAF, Me.labelNbrPrices, Me.textBoxPAF, Me.UpdatePrices}) Me.GroupBox1.Location = New System.Drawing.Point(8, 8) Me.GroupBox1.Name = "GroupBox1" Me.GroupBox1.Size = New System.Drawing.Size(240, 112) Me.GroupBox1.TabIndex = 9 Me.GroupBox1.TabStop = False ' 'labelPAF ' Me.labelPAF.Location = New System.Drawing.Point(8, 16) Me.labelPAF.Name = "labelPAF" Me.labelPAF.Size = New System.Drawing.Size(112, 32) Me.labelPAF.TabIndex = 2 Me.labelPAF.Text = "Enter Price Adjustment Factor" ' 'labelNbrPrices ' Me.labelNbrPrices.Location = New System.Drawing.Point(8, 80) Me.labelNbrPrices.Name = "labelNbrPrices" Me.labelNbrPrices.Size = New System.Drawing.Size(216, 16) Me.labelNbrPrices.TabIndex = 5 ' 'textBoxPAF ' Me.textBoxPAF.Location = New System.Drawing.Point(120, 16) Me.textBoxPAF.Name = "textBoxPAF" Me.textBoxPAF.TabIndex = 0 Me.textBoxPAF.Text = "" ' 'UpdatePrices ' Me.UpdatePrices.Location = New System.Drawing.Point(8, 48) Me.UpdatePrices.Name = "UpdatePrices" Me.UpdatePrices.Size = New System.Drawing.Size(88, 23) Me.UpdatePrices.TabIndex = 6 Me.UpdatePrices.Text = "Update Prices" ' 'groupBox2 ' Me.groupBox2.Controls.AddRange(New System.Windows.Forms.Control() {Me.TenMostExpensive, Me.grdNorthwind}) <Part 1----To be continued due to the length of this post>
View Replies !
Database Explorer In VB Express:AdventureWorks.mdf-Files Do Not Match The Primary File Of The Database
Hi all, I downloaded and ran AdventureWorks.msi into my SQL Server Management Studio Express (SSMSE) one year ago.But I did not know how to attach it to my SSMSE then. Last week, I deleted it from the "Add or Remove" of Control Panel and I downloaded the new AdventureWork.msi and installed it my SSMSE. Today, I tried to use the Database Explorer of VB 2005 Express for the first Stored Procedure programming. I clicked on AdventureWorks.mdf and I got the following error: One or more files do not match the primary 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 corrupt and should be restored from a backup. Cannot open user default database. Login failed. Login failed for user 'CENADe1enxshc'. Log file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_Data_log.ldf' does not match the primary file. It may be from a different database of the log may have been rebuilt previously. Please help and advise me how to correct this problem. Thanks, Scott Chang
View Replies !
Object Explorer And Object Explorer Details
SQL server 2005: How to view or open tables under object explorer details, when i double click an object under object explorer. thats how the default settings used to be. now when i double click any object or try to open query analyzer it is open in the same left side pane on top of Object explorer window. i did something to my explorer and explorer details panes since then both are separated, they are not getting synchronized. Thanks for your help.
View Replies !
SQL Server 2005 Is Not There In Server Explorer Of Visula Studio.NET
Hi, I have installed express edition of the Visaul Studio and SQL Server 2005. But I am suprised to see that sql server is not there in server explorer of vs.net and also we create can not create the database in app_data server. It is giving error that Your default server setting does not alllow remote sql server database. What should i do to make it working. Also in ASP.NET configuration tool it it not working please help me, its very urgent regards, Jalpesh
View Replies !
Visual Studio Database File And SQL Server Management Studio Express Question
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
View Replies !
Regarding Connectivity Issues Of IBM U2 XML Database Using .net Server Explorer
Hi, Im trying to connect IBM U2 XML Database using my ms.net Server explorer.but server not itself getting detected. Prerequisites :i have installed the following things in my system 1. U2 on my machine and created databaes and tables. 2. IBM Database Add-ins for Vs.net 2005 below are the following steps im trying to connect IBM U2 Xml Database 1.Server Explorer ->Addconnection Datasource : IBM DB2,IDS and U2 servers 2.in server tab its not showing my server which created using U2 Can any one please guide me in this issue
View Replies !
2005 Database Will Be Created In Both Management Studio Express And App_Data Folder Of VS 2005?
I have not created SQL Server 2005 database before. When installing a sample SQL Server 2005 Express database using a Configure.exe file from the Microsoft Press Book 'ADOnet 2.0', I can see the database in the App_Data folder of the Solution Explorer on VS 2005, as well as Management Studio Express. But for the MS Press book 'ASPnet 2.0', the web site created from the virtual directory of sample code showed an ASPNETDB database in the App_Data folder, but no ASPNETDB database in the SQL Server Management Studio Express. Is this the way how SQL Server 2005 will work -- the database can be displayed in both the Management Studio and App_Data, as the ADONET 2.0 database showed, or just in the App_Data folder, as the ASPNET 2.0 databae showed? TIA, Jeffrey
View Replies !
Connecting SQL SERVER 2005 EXPRESS EDITION Using Server Explorer
Hi all.I use Visual Studio .NET 2002 and SQL Server 2005 Express Edition as database.I try to connect to database using server explorer.Test connection is OK. When I done with it and click OK, the message prompt that "Unable to connect to database".So, is it impossible to connect SQL Server 2005 Express Edition using the server explorer?But, the connection is ok when I connect through code cause I can retrieve and update database.
View Replies !
Dbo.Table Of A Database In The .SQLEXPRESS Object Explorer: How To Copy The Dbo.Table To The Another Blank Dbo.Table?
Hi all, The following dbo.Tables of Northwind.mdf in my .SQLEXPRESS (SQL Server Management Studio Express) are missing: dbo.Categories dbo.CustomerCustomerDemo dbo.CustomerDemographics dbo.Customers dbo.Employees dbo.EmployeeTerritories dbo.Order Details dbo.Orders dbo.Products dbo.Regions dbo.Shippers dbo.Suppliers dbo.Territories. But, I have these dbo.Tables in a different Database "xyzDatabase". How can I copy each of these dbo.Tables to the another blank dbo.Table of Northwind Database? I right clicked on the dbo.Categories and I saw the following thing: dbo.Categories New Table... Modify Open Table Script Table as |> CREATYE To |> DROP To |> SELECT To |> INSERT To |> New Query Editor Window File.... Clipboard UPDATE To |> DELETE to |> From the above observation,I think it is possible to copy the dbo.Table from the one Database to the Northwind Database that needs to be repaired. Please help and advise me how to do this task or tell me where I can find the Microsoft document that gives the details of this X-copy thing. Thanks in advance, Scott Chang P. S. I am using VB 2005 Express to create a project to learn "Calling Stored Procedures with ADO.NET" (see Paul Kimmel's article in http://www.developer.com/db/article.php/3438221) that needs the dbo.Tables of Northwind Database and my Northwind Database has been screwed up for quite a while and needs a big repair.
View Replies !
Cannot Connect To Localhost From &&"Server Explorer&&" In Visual Studio 2005.
hi , I am trying to connect to my local SQL server 2005 from "Server Explorer" but it is giving the error of "Remote Connectons" not allowed. I am using "windows authentication" login. My SQLExpress and SQLExpress browser are running from "SQL server configuration manager". If i use a "App.Config" file to connect to database, the SQl connection can open and i can run the stored procedure.... but cannot access the database on my local machine. Please help. thanks for reply. With regards, Girish.
View Replies !
Import Existing Database Into SQL SERVER EXPRESS Management Studio Express
Hi, I am a newbie so i apologies beforehand for any mistakes i make on this forum. Anyway, i created an asp.net website using the MS Visual Web developer tool. This has a couple of SQL SERVER databases within it. I then latervinstalled the SQL SERVER management studio express in order to manage the SQL SERVER DBs that i had as part of my website but they do not appear within the management studio db list. As this is the express version, is there anyway of importing the existing SQL SERVER dbs that i have to the management studio so i can manage them from there? Regards, Shuja.
View Replies !
Why Can't I See My Web Developer Express Database From SQL Server Management Studio Express?
Hi, I'm completely new to SQL Server and ASP.NET, so please bear with me on my learning curve! I've installed Visual Web Developer Express and SQL Server Express (on the same PC). I then used Web Developer Express to successfully create a new database with a couple of tables in it. So far so good. I then installed SQL Server Management Studio Express on the same PC and tried to connect to my new database. The connection to the SQL Server instance appears to work OK (using Windows Authentication) but I can't see the database I previously created. All I can see are the System Databases. Does anyone know what the solution might be?
View Replies !
How Do I Export My Database From SQL Server Management Studio Express
HiI am using SQL Server Management Studio Express to make my databases but I noticed if I make my database in Visual studios and go new Item and make a new database I see it in app_data folder and server express tab and if I make it in SQL Server Management Studio Express I only see it in the server explorer. So if I have to move my files to another computer how do I move my database easly with SQL Server Management Studio Express? Since when you make it with the visual studio the file gets stored with all the other files of your project so if you move it all to another computer you prob won't run into a problem. So how do I make it that so I can do everything in SQL Server Management Studio Express(since I like working in it) then export it into a file that I can then go into my app_data folder and add it is an exist item? Thanks
View Replies !
SQL Server Management Studio Express Export Database
Hello, I'am a student and I'am using the Express version of the SQL sever Management Studio. The question that I have is: Can I create a SQL database on my local computer and use this database on a other computer? So I create a database on a laptop and want to export/import this on a desktop. If this is possible can somebody sent met a tutorial ore something. Thanks Andre van Nijnatten
View Replies !
Database Snapshot In SQL Server Management Studio Express
How do I set up a database snapshot and backup the database for Windows Server Update Services 3.0, that uses the "desktop" version of SQL server on the same server running Widows Server 2003? There does not seem to be a "Management Plans" sub-folder under the "management" folder in the Management Studio Express console- so that's probably my first request- how do I establish a "Management Plans" subfolder, then how do I (step-by-step) set up a backup of the SUSDB?
View Replies !
Can't Attach Database Using SQL Server Management Studio Express
I am having a problem Attaching, well actually not being able to see a database when attempting to attach it. I suspect this is more of a security issue rather than a problem with Management Studio, but I can't figure out what is happening. If I copy a database to Documents and SettingsAll Users... and attempt to attach I can see the file in the selection tree. This also is the case if I copy it to Documents and SettingsDefault User... But if I copy it to Documents and SettingsADynarski... which is the account I normally log into, when I expand the folder in the selection tree, nothing is visible. And the same thing occurs if I copy the file to Documents and SettingsGuest... I've looked at the security settings and everything appears to be normal. This is on a box with XP Home and SQL Server Express. Can anyone tell me what I'm missing? Thanks, Al
View Replies !
Repair Northwind Database In SQL Server Management Studio Express
Hi all, Long time ago, I downloaded the Northwind and pubs databases from the Microsoft website (I do not remember the details of it) and installed these two databases together into the SQL Server Management Studio Express of my PC (Microsoft Windows XP Pro). I tried to learn an example of using "User Instance" (source code was from a book) on the Northwind database located in my SQL Server Management Studio Express. I just find out that my Northwind database has the title only and no tables at all. If I click on the "+" in front of the "Northwind", I got the following error message: Microsoft SQL Server Management Studio Express Failed to retrieve data for this request.(Microsoft SqlServer.Express.SmoEnum) Additional information: 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 backup. (Microsoft SQL Server, Error: 5173).. Please help and tell me how I can repair this Northwind database in my SQL Server Management Studio Express. Scott Chang P. S. I deleted the name 'Northwind' in my SQL Server Management Studio Express, executed the "SQL2005DBScriptsInstnwind" program and I got the following error message: Msg 1802, Level 16, State 4, Line 1 CREATE DATABASE failed. Some file name listed could not be created. Checked related errors. Msg 5170, Level 16, state 1, Line 1 Cannot create file 'c:Program FilesMicrosoft SQL ServerMSSQL.1DATAorthwindorthwind.ldf' because it already exist. Change the file path or the file name, and retry the operation. Msg 15100, Level 16, State 1, Procedure sp_dboption, Line 64 The database 'Northwind' does not exist. Use sp_helpdb to show available database. Msg 911, Level 16, State 1, Line 1 Could not locate entry in sysdatabases for database 'Northwind'. No entry found with that name. Make sure that name is entered correctly
View Replies !
Uploading Database To Sever With Sql Server Management Studio Express
Hello, I would like some help in uploading a database from my harddrive to a server using sql server management studio express. If I try to attach it to the server, this program only looks at the files on this server and not on my harddrive. So how can I copy a sql database to my folder on the server. I am sure it must be a simple problem, but I've been bizzy with it for about a day now. So, please advice. Rgds, Wouter.
View Replies !
How Can I Backup The AdventureWorksLT Database To SQL Server Management Studio Express?
Hi all, I just found out the name of AdventureWorksLT is in my SQL Server Server Management Studio Express, but the content of AdventureWorksLT database in my SQL Server Management Studio Express is gone. I saved the backup file of the AdventureWorksLT database in my C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLackup folder. How can I backup the AdventureWorksLT database to SQL Server Management Studio Express again? Please help and advise. Thanks in advance, Scott Chang
View Replies !
Database Connection Error In SQL Server Management Studio Express
Hello, We are trying to connect the data base in SQL Server Management Studio Express using Operating System Xp. The following error show during the connection time. " Cannot open database "Test" requested by the login. The login failed. Login failed for user 'NT AUTHORITYSYSTEM'. We have the login Id for sa and password. Connect to server it work properly. Could you please give me the steps to resolve the problem. Thanks, Mahesh
View Replies !
How Can I Attach AdventureWorks Database To SQL Server Management Studio Express?
Hi all, I just downloaded AdventureWorks_Data.mdf, AdventureWorks_Data.ldf, AdventureWorksDW_Data.mdf, and AdventureWorksDW_Data.LDF files to the C:Program FilesMicrosoft SQL ServerMSSQL.1|MSSQLData folder of my Windows XP Pro PC. I tried to attach the AdventureWorks database in my SQL Server Management Studio Express in the following way: I clicked on SQL Server 2005 Express=>SQL Server Management Studio Express=>Right clicked on Databases=> clicked on "Attach..."=> "Attach Databese" showed up. But I can not type in anything under the MDF File Location, Database Name, Attach As, Owner, Status, Message!!!??? What is wrong in my way of doing the attachment of AdventureWorks database (described above)? Please help and advise. Thanks, Scott Chang P. S. I do not have Microsoft Visual Studio 2005. Walkthrough: Install the AdventureWorks Database (http://msdn2.microsoft/en-us/library/ms31035.aspx) : To confirm your SQL Server data directory (Start=>All Programs, Microsoft Visual Studio 2005, Visual Studio Tools, Visual Studio 2005 Command Prompt) steps 1 thru 4 can not be applied to my SQL Server Management Studio Express. I read an SQL Express post dated 19 April 2006 and learned the above-mentioned way to attach the AdventureWorks database in the SQL Server Management Studio Express. But that way does not work for me.
View Replies !
Trigger Work In VS Explorer - Not In Debug App - SQL Express 2005
OK I am really going nuts here. I have a trigger that will work if I insert a row using SQL MGMT Studio or VS DB explorer, but it will not insert using the tableadapter.update() command. What is also strange is that I have to execute the query in the VS DB Explorer or SSMSE to get them to fill in the default values (trigger). No matter what they don't work in the debug application: Below is the trigger: Code Snippet ALTER TRIGGER [dbo].[weight_train_log_InsertTrigger] ON [dbo].[weight_train_log] AFTER INSERT AS BEGIN SET NOCOUNT ON UPDATE [weight_train_log] SET [CreationDate] = GETDATE() FROM inserted WHERE inserted.[GUID] = [weight_train_log].[GUID] END
View Replies !
How To Use Xcopy && User Instance To Copy 3 Dbo Tables From The Database Of SQL Server Management Studio Express To The App_Data Folder Of Website Of VWD Express Project?
Hi all, I have read/studied (i) Working with Databases in Visual Web Developer 2005 Express in http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/vwd.aspx, (ii) Xcopy Deployment (SQL Server Express) in http://msdn2.microsoft.com/en-us/library/ms165716.aspx, (iii) User Instances for Non-Administrators in http://msdn2.microsoft.com/en-us/library/ms143684.aspx, and (iv) Embedding SQL Server Server Express in Applications in http://msdn2.microsoft.com/en-us/library/ms165660.aspx. I do not understand the concepts and procedures to do Xcopy and User Instances for non-administrators completely-I do not know how to connect to databases and create database diagrams or schemas using the Database Explorer. I have a stand-alone Windows XP Pro PC. I have created a ChemDatabase with 3 dbo tables in the SQL Server Management Studio of my SQL Server Express and a website of my VWD Express application with an App_Data folder. I am not able to proceed to use Xcopy and user instance to bring the 3 dbo tables of ChemDatabase to my App_Data folder. Please help and give me some detailed procedures/instructions to bring the 3 dbo tables of ChemDatabase (or ChemDatabase itself) from the SQL Server Management Studio Express to the App_Data folder of the website of my VWD Express project? Thanks in advance, Scott Chang
View Replies !
How To Import A Text Database File Into SQL Server Management Studio Express
I have a text file with a bunch of zip codes: 99546,"AK","Adak",162.70,55.20,.0099551,"AK","Akiachak",161.39,60.89,.0099552,"AK","Akiak",161.19,60.89,.0099553,"AK","Akutan",165.78,54.14,.00................... I want to import this in Sql Server Express. Is it possible to do this using Management Studio Express? If not, does anyone know a script that would import the data?
View Replies !
Using Microsoft SQL Server Management Studio Express To Export/copy Database?
How does one export/copy a database using Microsoft SQL Server Management Studio Express? At this time, I have an existing database that I can access and run queries against. However, I cannot connect to it via Visual Wed Developer 2005 Express. At this time, I'm getting the following error message with the existing database: Login failed for user 'bigide2_gims2'. The user is not associated with a trusted SQL Server Connection. Next, I'm running everything locally. If anyone can assist, it would be greatly appreciated and thanks in advance. -Conrad
View Replies !
Built Database With SQL Server Management Studio Express, How Can I Quikly Add Test Data?
I've built my SQL Server Express database with SQL Serevr Management Studio Express, and now I want to enter some seed data to assist in building tha app around it. I cannot find an option to manage the data in SQL SMSX, like I used to with Enterprise Manager. I don't want to have to write an app just to get test data in. Seems like this should be a common need. Am I missing something obvious here? Can't find any reference to this in a search of the forums. Please help.
View Replies !
Not Available In Object Explorer
Im new to Sql Server CE and I am following the procedure in books online to create a new database. Through Sql Server Management Studio, I have version 9.00.2047, books online says to click connect through Object Explorer and then select Sql Server Compact Edition. I dont see this option. I see Sql Server Mobile. Is it the same thing or am I missing something? Thanks, Jesse
View Replies !
Object Explorer
Hello All; I downloaded the VWD2005 recentrly, it was really agiant achievement , i appreciate the people who developed such an easy-to-learn web development package. I noticed the difference between VS2002 and VWD2005. I really liked it. (i am sorry if this speech isn't in its right place). Here i have an enquiry, I downloaded the the VWD2005, but i haven't seen the Object Explorer(SQLExpress), although it was included in the downloades? Thanks alot
View Replies !
Object Explorer
I am using vs 2005 to connect to a remote database. I dont have remote access or any other type of access. I need to setup some constraints on the database, but the object explorer is missing. How can Iincorporate this tab into vs
View Replies !
Cannot Log Into SQL Server Database In Visual C# Express After Using SQL Server Management Studio Express
Is anyone else having the same annoying problem as me? ... I have a SQL Server Express edition database using Windows login authentication. Normally I can access it fine in C# Express, but If I have used SQL Server management Studio express in the same windows login session, i get: Cannot open user default database. Login failed. Login failed for user 'mydomainmyuserid' If I restart my PC, I can then access the database in Visual C# express. I'm running Windows XP. Thanks!
View Replies !
DATABASE EXPLORER, LOADER, REPORTS
We are making available softwarefor exploring / loading / Reporting from database,expert suggestions are *very* welcome.http://cam70.sta.uniroma1.it/TechnicalPreview/free lifetime licence for experts.thank you for your help.the Datatime team
View Replies !
Don't Display Dbo. In Object Explorer
Is there a way to stop SQL Server Management Studio (2005) from showing "dbo." on everything in the object explorer. I'd love to turn that off on a database I'm working on as, for example, if you have to find tblMember, you'd have to type d-b-o-.-t-b-l-m before you can actually start jumping to the table you're interested in - whereas in Enterprise Manager (2000) you'd only have to type t-b-l-m if you get my meaning.
View Replies !
How Can I Re-install The Northwind Database In SQL Server Management Studio Express?Use SqlDataSet && The .Fill Method Properly?
Hi all, In my VB 2005 Express, I created a Windowds Form application "shcDataSet" that used 1 SqlConnection, 1 SqlDataSet and 3 SqlDataAdapters associated with the Northwind Database in my SQL Server Management Studio Express. The SqlConnection had "User Instance" in the following ConnectionString: Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataorthwnd.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True. The 3 SqlDataAdapters were for the Northwind files "Customers", "Orders" and "Order Details" used in the SQLDataSet "AllOrders" with a AllOrders.xsd file. I ran the "shcDataSet" applicatyion and it worked fine. After the execution of "shcDataSet", I checked the Northwind database in my SQL Server Management Studio Express and clicked on "+" in front of Northwind database-I did not see any file showed up and I got the following error message: Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) Additional information: 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). If I executed the "shcDataSet" application again, I got a new error: SqlException was unhandled - Cannot open user default database. Login failed. Login failed for user 'myPC##myName' ------->daCustomers.Fill(AllOrders11, "Customers"). I have 3 questions to ask: (1) How can I re-install the Northwind database in SQL Server Management Studio Express? (2) When I use the .Fill Method, do I have to tell the SQL Server Management Studio Express to load and/or unload the Northwind files "Customers", "Orders" and "Order Details"? (3) After I executed the "shcDataSet", should I Upload the 3 Northwind files back to the SQL Server Management Studio Express? Please help and advise. Thanks, Scott Chang
View Replies !
|
TRACKER
