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 |
|
sqlprogrammer123
Starting Member
1 Post |
 Posted - 2008-04-03 : 04:34:56
|
| Hi,I'm very new in SQL Server. Please help me to combine the connection string to the server.62.33.197.7login: sapwd: S#15trLdatabaseWhat would be the connection string then? And can I get the tables names if I have the connection string? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-03 : 04:46:14
|
| Connection string has nothing to do with listing tables. If you have valid connection string and appropriate permissions on the given database, you can list the tables.BTW, for listing tables you have to query INFORMATION_SCHEMA.TABLES view.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-04-03 : 04:49:10
|
| Wow, Can you let me know where in the world this server is as well?Do NOT post your passwords, especially the sa password, else I do not think your server will be there for long. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-03 : 13:54:35
|
| Also, posting it may be a violation of your employment agreement or put the company in voilation of their SLA with their clients. Depending on your company, they might show you the door pretty quickly. I know mine would.Terry |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-04-03 : 14:30:45
|
Darn, I was unable to ping your server, and couldn't connect with Query Analyzer.  CODO ERGO SUM |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 14:48:11
|
| OMG!! you put password for Sa. Your boss will fire you if he is watching this forum.I am trying to ping your server but not able to(Just kidding). |
|
|
|
|
|
|
How can I list the tables if I have SA access?