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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Any thoughts?

Author  Topic 

notmyrealname

98 Posts

Posted - 2009-01-21 : 10:32:34
<>//Error

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2009-01-21 : 11:16:35
You can install SQL Server Express edition on your desktop. It is a free download from Microsoft. It comes with SQL Management Studio which will allow you to connect to other editions of SQL server from your desk if you have the credentials. And, it looks like you do have the credentials, because you are able to access the server, create databases etc. from VB.Net. There is more info about SQL Express here:
http://msdn.microsoft.com/en-us/library/ms345154.aspx#sseover_topic5

I don't have much experience with SQL Express, so I don't know a lot about its limitations and capabilities. But you should be able to create databases on your local machine, do tests etc with it as well.
Go to Top of Page

notmyrealname

98 Posts

Posted - 2009-01-21 : 11:51:58
Hi. Thanks for the reply.

Installing Express is a good idea.

I will not be able to view the server in question however because i do all of my programming on a remote server from my home office. But at least i can create a database on my machine and familiarize myself with SQL's database options.

Unfortunately it seems like i will not be able to fully analyze and diagnose problems with my program and its database without some additional tools.

Thanks.
Go to Top of Page
   

- Advertisement -