Functions within Management Studio not working

Various functons within SQL Server Management studio have stopped working on my dev machine (which has both 'Full' MSSQL, and SQL Express installed). On any instance of SQL, if I try for instance to add a new table from the right click/new table menu option,
then I get the error message:

-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)----------------------------

Have used Visual Web Developer 2008 to make ASP application, with SQL server 2008 R2 Express for database. Works very nicely.

However, when I come to use Management Studio Express 2008 R2, I cannot see all my tables.

The ones I CAN see were created by the MS script that creates membership tables (and are called dbo.aspnet_membership etc), presumably because the owner of the tables was specified as 'dbo'.

The ones I can't see from Management Studio are the ones I created. I never specified an owner.

I think this is a permissions issue, but I can't fathom it. There's only ever been me on my development machine (laptop) doing it all, hence always the same log ins.

Running Management Studio as Adminstrator doesn't help.

I can't even ask Management Studio who own's the tables that I can't see because Management Studio can't see them so rejects the script.

Any ideas/links very (very) welcome !

**** Actually, it is even wierder. The tables in Management Studio have full structure, but are empty. But if I look at them in Visual Basic 2008 they are full !!! And...if I create a table in Management Studio it does not appear at all in Visual Basic, and likewise, a table created in Visual Basic does not appear at all in Management

Hi,
If I want to provide a way to INSERT rows to a table without having to use SMS, what is the way to go? Is there such a thing as a sql script? so that you can just change the data in the file and double click to write it to db?
Thanks.

I've istalled SQL2005/SSMS on my development machine and connecting to a local SQL Server 2005. Executing queries is fast but the results grid populating is slow and so is the refresh of the same data. This is not a slow query, its the gridview draw/redraw. I've other PC's with slower processors and less ram with the same software run circles around the SMSSÃÂ Performance on this Laptop
ÃÂ
I've read posts about nvidia graphics drivers and mouse drivers causing issues similar to this. I do have an nvidia quadro x1600M (this isÃÂ a laptop Compaq 8710w) and switching off the accelerator using Displays/Advanced/TroubleshootingÃÂ by moving the slider to the middle/center position causes the gird refresh to dramatically increase.ÃÂ It's funny how turning oof the accelerator increases performance.
ÃÂ
I have the latest HP nvidia drivers and SSMS is useable without hardware acceleration ÃÂ but I also develop software that uses directx and its getting really troublesome to work this way.
ÃÂ
I am running:
ÃÂ
Operating System: Windows XP Professional (5.1, Build 2600) Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300)Language: English (Regional Setting: English)System Manufacturer: Hewlett-PackardSystem Model: HP Compaq 8710wBIOS: EPP runtime BIOS - Version 1.1ÃÂ Processor: Intel(R) Core(TM)2 Duo CPUÃÂ ÃÂ ÃÂ ÃÂ T7300ÃÂ @ 2.00GHz (2 CPUs)Memory: 3072MB RAMPage File: 515MB used, 4439MB availableWindows Dir: C:\WIN

After opening Management Studio and doing some editing it is possible to copy/paste things in the query editor. After a while (working in another app) I come back to Management Studio and I can't copy/paste anything anymore. If I try to copy from the results window I get an error message that the clipboard operation did not succeed. If I try to copy from the query editor window it just doesn't copy. I can copy/paste in other apps without a problem.
ÃÂ
I have seen this problem described in other forums so I'm not alone but I have 3 other computers where this problem does not occur. The one machine with the problem is hyper-threading. I wonder ....
Any other ideas? It is not the clipboard getting full but I can't rule out much else.

Hello,
My DBA was using Windows XP + MSSQL Management studio 2005 (no SP applied). Everything was fine. Now we upgraded his machine to Windows 7 Pro and MSSQL Management stuio is crazy. We are unable to open 6000 row tables. The program freez and burn 2gigs of
memory.
Do I miss something ? SP3 is applied and its still doing nasty things.
MSSQL Stuio Management version : 9.00.4035.00
Thanks !

I have a query that looks something like this:
SELECT TOP 1 * FROM Customers c (NOLOCK) WHERE Key = (mykey)
AND NOT EXISTS (SELECT 0 FROM Invoices i (NOLOCK) WHERE i.key = c.key AND i.Date > GETDATE() )
When I run this inside an (ODBC) application, it times out. When I run it within SSMS, it works fine. That might make you think its an application problem, but the timeout only occurs for one specific customer ... even in the application, it
works fine for all other key values.
Any idea where I can even start looking for a solution to this? Thanks.

I have recently formatted my hard drive and over the past few days I've been reloading my software. I have installed on my machine SQL Server Express 2005 SP3. I prefer to have SQL Express running on my development machine because that is what
my customers primarily use. I also have a full MSDN license, and I would need to install SQL Management Studio 2005. However, when I download the SQL Server 2005 Developer ISO from MSDN, and run the setup file I get an error message that states:
Installation of Microsoft SQL Server Native Client failed because a higher version already exists on the machine. To proceed, uninstall the higher version and then run Microsoft SQL Server Native Client Setup.
I would assume the problem is that the copy of SQL Server - Dev Edition that is available through my MSDN subscription is using an earlier version of SQL Server 2005 (most likely the version prior to SP1.) I would just unistall SQL Server Express 2005
SP3 and reinstall it with out any service pack updates. The problem is that I also see within my Add or Remove Programs list four SQL Server 2008 R2 entries, that I believe were installed when I installed Visual Studio Pro 2010 (they are, Microsoft
SQL Server 2008 R2 Data-Tier Application Framework, Microsoft SQL Server 2008 R2 Data-Tier Application Project, Microsoft SQL Server 20

Hello,I am trying to connect to sql server CE trough SQL Management studio express. But it seems like it only wants to connect to an SQL server express instance. Does SQL server CE needs to run as a server? because I can't seem to be able to just connect to a file. Does Anyone know how to connect to SQL CE?Thanks!Greetings,Mark

This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change
the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both 127.0.0.1
& external IP) in my hosts file pointing to the server name. Does SQL require a DNS server?
This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't
authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!

Been around SQL Server since 7.0 days.
In SQL Server 2008 Management Studio I don't seem to be able to display Created Date for Views. I can't really believe MS have taken this away so hence my Q.
I find it useful to see Created Data to script my recently developed View and other objects.
Robert, Edinburgh
Bob as MCSD.NET 2003

Can anyone point me to where I can download the management studio for SQL 2008 Express.
ÃÂ
I've downloaded and installed SQL 2008 Express without problem but can't find the management studio.
ÃÂ
Help.

In SQL Server Management Studio (for SQL Server 2008), when I try to open a new query window, or create a new database, I get a popup error box saying the following:
"Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (mscorlib)"
This just started happening in the last few days, and I have no idea why. I even uninstalled SQL Server 2008, and then installed SQL Server 2008 R2, and continued to get the exact same error, in the exact same scenarios.
Please let me know if you have seen this before, and what I might try to correct it.
Thanks,
Robert