View Complete Post
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.
Am sorry if this mght be abit silly question am a Novice Developer.
If am using Visual Studio 2008 Pro, Do I need SQL Server Management Studio? or is it included in the VS 2008 Pro Suite? Am learning C# and SQL Server.
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------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
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