.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Hide system database in SQL Management Studio

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :ASP.Net
 
I am using SQL server 2008 . What i all want is to create a uses that can only see the ABCDatabase in Management studio onced login. And to achieve that:1- I have created a new user.2- Deny View all database right to that user.3-Set that user as Owner of ABCDatabaseNow on login that user cannot see other databases but still able to see the system databases. How can i hide those system databases from that user?


View Complete Post


More Related Resource Links

Create table in the database using management studio

  

 I have database already on the server. However, when I created new table, the new created table Schema is not dbo. it is my user name. How to solve this?

It shows the new created table Schema is my username but not dbo.

Even though I rename it, it couldn't change. I can see this in table property.

 

Xinguo


Cannot Create Database Diagrams - SQL Server 2008 Management Studio

  
I cannot create a database diagram with my client-side SQL Server Management Studio.  I can do this if I am on the actual db server itself.  Please help.

SQL Server Management Studio is not attaching a database.

  
Hi folks,I'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.Can someone please help me here???Thanks!

SQL Server Management Studio cannot locate my database

  
I had to uninstall SQL Server 08 when I left my last project, I have reinstalled the management studio but it no longer recognizes the databases that are on my local machine.  How can I reconcile the connection to the preexisting databases?  When I choose connect, nothing comes up in the options and when i type in the database name it errors out.  I thought it was just that the old files were corrupt but I installed a brand new database and while i can verify that it exists on my machine, I cannot connect through Management Studio.

Problem trying to attach database file to Microsoft SQL Server Management Studio

  
I was trying to attach a database to SQL Server MGT Studio and got an exception error.  The message stated that the database file I was trying to attach could not be opened because it was version 661.  The SQL Server shows to support version 655 and earlier.  It states that a downgrade path is not supported. Question:  Is there some download ; fix; I can make to SQL Server 2008 that will allow me to attach the version 661????  I am not technical at all.  Please speak slowly.  :)  Thanks

C# Database created but does not show up in Server Management Studio unless I manually attach it.

  

I used C# Linq to Sql to create a database. I look on the hard drive and the database .mdf and .ldf files are there. I open Server Management Studio 2008, attach to SQL express and the database is not there unless I actually attach the database.

 

First, is this correct behavior?

Second, is it possible to create a Sql Express database that is automatically registered(?) in Management Studio? If so, please give pointer.

 

Thanks very much.

 

 


how to connect my hosting database from my pc using sql server management studio 2005

  

Hi..

I have one asp.net hosting account with some service provider.. 

They have given me some xxx.xxxxxx.com to access sql server from my desktop... 

I enter xxx.xxxxx.com in server name and username and password but it will not connect.. 

so please let me know what are the steps i have to do to access my hosting database...

they have given sql server 2008 im using in local sql server 2005 management studio so let me know how to connect

thanks in advance


Microsoft SQL Server Management Studio 2008 does not list all tables in database

  
When logging into SSMS 2008 to a SQL2008 database when I expand the tables in a database I only see a few tables listed.  I can login to the same instance with SSMS 2005 and all of the tables are there.  Is there a reason why this is this way?

I can do a select * from in a query window for any of the tables in the database via SSMS 2008 as well and it work fine.  It just does not display the tables.

set up database with .bak files in SAL server management studio

  

Hi,

I need to connect to 3 remote databases from my local machine and  restore 3 .bak files, one for each database.

I am new to asp and sql server and am finding SQL Server Management studio quite confusing.  I cannot find any options to connect remotely or restore a database from .bak.

Many thanks


SQL Server 2005 Management Studio error and cannot re-install client tools too system.serviceModel e

  

Hi,

got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Success
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
eLocal)
   at System.Configuration.BaseC

SQL Server 2005 Management Studio error and cannot re-install client tools too system.serviceModel e

  

Hi,

got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Success
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
eLocal)
   at System.Configuration.BaseC

Unable to attach database using Management Studio

  

 

Hi,  I have installed SQL Express 2008 on a Windows XP SP2 box. SQL Server 2005 is also on this box (installed as part of another program).

 

When I try to attach a database using Management Studio I get the following error:

 

===================================

Cannot show requested dialog.

===================================


Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidthInternal(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidthInternalForPublic(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidth(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SetGridColumnWidth(SqlManagerUIDlgGrid grid, Double[] columnWidthRatio,

Can't attach my project database (.mdf file) using SQL Server Management Studio R2

  
Hi.  I've encountered a strange issue in SQL Server Management Studio (not the express version).  I had to uninstall SQL Server 2008 Developer in order to install SQL Server 2008 R2 Developer.  As a result of doing this, the database from one of my ASP.NET MVC projects is not attached to the database server.  I see the ".mdf" file in my project's AppData folder in Windows Explorer, but I can't navigate to it in SQL Server Management Studio.  I go to "C:\Users\<my name>" and the attach database interface will not let me go any further.  The folder that I need to access is "C:\Users\<my name>\Documents\Visual Studio 2010\NerdDinner\NerdDinner\App_Data".  How can I access this directory from SQL Server Management Studio?  Is there some sort of strange permission issue?  Thanks in advance for any help.

Failed to create new database in SQL Server Management Studio Express

  

 

I don't know why I can't create a new database in SQL Server Management Studio Express.

 

 

This is the reason:

===================================

CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

------------------------------
Server Name: Ning-PC\SQLEXPRESS
Error Number: 262
Severity: 14
State: 1
Line Number: 1


------------------------------
Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndW

Multilevel Approval Workflow Management System - ASP.NET / C# (Visual Studio)

  
Hey guys, 
So this is a project I have been given to work on, a multilevel approval workflow management system. The process will begin with a user filling request forms and the request will be sent to the next in line using a service already built (just need to plug it in) and so on and have options to escalate too. The rest is pretty much like any approval management system. I have to automate a business process.
Now the main thing is I was told to develop a standard web application in Visual Studio and NOT use SharePoint since they don't have the facility. 
How do I go about it? Any already implemented solutions I can use to build upon? Or perhaps tutorials / guides that show how to develop a full fledged workflow management system? 
Thanks! 

Team System: Building a Visual Studio Team Explorer Extension

  

There's no magic behind how the TFS Power Tools were integrated with Team Explorer, and we'll show you how to expose your own custom features inside the Team Explorer window.

Brian A. Randell, Marcel de Vries

MSDN Magazine December 2009


Toolbox: Database and OR/M Tools, Oren Eini and Custom Visual Studio Tabs

  

This month we look at tools for enhancing the LINQ to SQL and Entity Framework designers, Oren Eini's .NET development blog, Visual Studio tab customization, and more.

Scott Mitchell

MSDN Magazine December 2009


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend