Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sdumarali
Starting Member
7 Posts |
 Posted - 2007-08-18 : 02:38:31
|
Hello To every one here.I am getting problem to view the table definition which is in Schema.So can anybody help me quote:
How do i view the table definition
thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-18 : 04:08:03
|
| 1 sp_help 'your table'2 Select * from information_schema.columns where table_name='your table'..MadhivananFailing to plan is Planning to fail |
 |
|
|
sdumarali
Starting Member
7 Posts |
Posted - 2007-08-19 : 12:56:36
|
| Thanks madhivanan |
|
|
|
sdumarali
Starting Member
7 Posts |
Posted - 2007-08-19 : 13:03:56
|
| And one more help i seek from u is that i have installed sql server2005 on my machine i have created new instance when i connect this to object explorer the problem i get is "TITLE: Microsoft SQL Server Management Studio------------------------------An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476------------------------------BUTTONS:OK------------------------------ So what is the remedy for this if u guide me step wise i am very much thankful to u |
|
|
|
abhwhiz
Starting Member
37 Posts |
Posted - 2007-08-20 : 00:40:19
|
| You've got to enable the remote desktop connections service using Surface Area Configuration available under Configuration Tools. Expand the Database Engine option to see the service. Also enable the SQL Server Browser service. |
|
|
|
sdumarali
Starting Member
7 Posts |
Posted - 2007-08-21 : 10:39:20
|
| plz guide me detail b'coz i am fresher to sql server |
|
|
|
abhwhiz
Starting Member
37 Posts |
Posted - 2007-08-21 : 10:59:17
|
| read thishttp://msdn2.microsoft.com/en-us/library/ms173748.aspx |
|
|
|
sdumarali
Starting Member
7 Posts |
Posted - 2007-08-22 : 12:26:52
|
| it'z all right.i gone through this path "On the Start menu, point to All Programs, Microsoft SQL Server 2005, Configuration Tools, and then click SQL Server Surface Area Configuration"but the window is not opened the error i get is *** Unable to find a version of runtime to this application**** |
|
|
|
|
|
|
Table Definition