cannot view existing database in management studio !!!

Hi

? have sharepoint 2007 server and everthing is ok

it is working

? can view database name in sharepoint central administration

but ? cannot view same database in sql management studio

what is the problem

how can i view it

Thanks

Are you connecting to the correct server instance? It should be <computername>\SharePoint. If you are connecting to another instance, this might explain your problem.|||

no no

? m sure it is correct instance computername\sharepoint

|||SQL Server 2005 is security sensitive which means that you will only able to see those database which you have access to.
Jens K. Suessmeyer.

http://www.sqlserver2005.de
--

.SQL file type not recognized by SSMS

Good morning,

For some reason, I can no longer open .sql files in SQL Server Management Studio. I have checked the Windows file association, which still associates these files with SSMS. I also tried adding a static extension under Tools -> Options -> Text Editor -> File Extension, but still no luck.

Each time I try to open a .sql file, I receive the following error:

There is no editor available for <my file>. Make sure the application for the file type (.sql) is installed.

There have been no major changes on my system recently. Any help would be appreciated.

Thanks
Tim

It happened to me once whatI did is, re-associated those .SQL files to open in NOTEPAD and then again associated to SSMS to open, that worked.

HTH

.sql control string

My development environment includes Visual Web Developer, SQL Server 2005 Express and SQL Server Management Studio Express. I have a .sql control string that creates a database. The control string is in my App_Data folder within my web site. When I use SQL Server Managment Studio Express to run the .sql control string and create the tables etc. it does it in my SQLEXPRESS folder and not in the web.

How do I run the .sql file so it will create the database in my App_Data folder within the web site?

Thanks,

Kyleq

Hi Kyleq,

Please make sure that your SQL Server Management Studio Express has connected to the correct database.

A simple .mdf file cannot be working properly, we must

1. Attach it to a SQL Server instance.
2. Connection the SQL Server Management Studio Express to that instance and to that database.
3. Run the .sql scripts.
4. Detach the database.

Please read the following for more information:

http://msdn2.microsoft.com/en-us/library/ms228037.aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

.Net Framework error message when starting SQL 2005 Management Studio

Has anyone ever recieved an error when starting the Management Studio?

"Unhandled excpetion has occurred in a component in your application.

"Input String was not in a correct format"

I click continue and I can still use the manager;however, it gets annoying. The details of the error are very long and too much to add to this thread.

Any ideas?

never had that but I would probably start by repairing the .NET Framework and see how that goes?

would be nice if you could post the error message, even if it is long

|||

I did repair the .NET Framework and same issue. I also reinstalled the SQL 05 components. Here is the error message.

Thank you for your help.

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.FormatException: Input string was not in a correct format.

at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)

at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()

at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()

at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs e)

at Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs e)

at System.Windows.Forms.Control.WmShowWindow(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WmShowWindow(Message& m)

at System.Windows.Forms.Form.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************

mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

-

AppIDPackage

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL

-

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

-

Microsoft.SqlServer.SqlTools.VSIntegration

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL

-

Microsoft.VisualStudio.Shell.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll

-

Microsoft.VisualStudio.OLE.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll

-

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

-

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

-

Microsoft.SqlServer.SqlTDiagM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll

-

Microsoft.DataWarehouse.SQM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL

-

Microsoft.SqlServer.Instapi

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll

-

ObjectExplorer

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL

-

ConnectionDlg

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL

-

Microsoft.SqlServer.CustomControls

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll

-

SqlWorkbench.Interfaces

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL

-

Accessibility

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

-

SqlMgmt

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL

-

Microsoft.SqlServer.RegSvrEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll

-

EnvDTE

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll

-

Microsoft.NetEnterpriseServers.ExceptionMessageBox

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll

-

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

-

Microsoft.SqlServer.ConnectionInfo

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll

-

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

For example:

<configuration>

<system.windows.forms jitDebugging="true" />

</configuration>

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.