Interfacing with SQL Server 2005 EXPRESS

hey howzit guys!

I am very new to SQL Server 2005 Express, my question is simple, can I only view and add database tables etc through VS 2005 when using SQL Server 2005 EXPRESS, since it does not seem to have any facilities in the Config. Manager to do this directly in SQL Server?

Did you try the managment studio express which is downloadable for SQL Server Express ?

http://www.microsoft.com/downloads/details.aspx?FamilyID=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Interfacing with SQL

What is the best and quickest way to develop, or download, an interface that
clients can use to query sql?
Thanks,
CJ
"Illicom Newsgroups" <chrisj@.illicom.net> wrote in message
news:hRHzc.3428$Hf.1942321@.newshog.newsread.com...
> What is the best and quickest way to develop, or download, an interface
that
> clients can use to query sql?
>
Would the SQL Server client utilities like Query Analyzer be of value to
you?
Steve
|||Hi
You may want to check out the some of these:
http://www.aspfaq.com/show.asp?id=2442
John
"Illicom Newsgroups" <chrisj@.illicom.net> wrote in message
news:hRHzc.3428$Hf.1942321@.newshog.newsread.com...
> What is the best and quickest way to develop, or download, an interface
that
> clients can use to query sql?
> Thanks,
> CJ
>
|||> What is the best and quickest way to develop, or download, an
> interface that clients can use to query sql?
a web based interface like myLittleAdmin could be a good solution
more info on http://www.myLittleTools.net/mla_sql
best regards
elian chrebor
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin : online MS SQL manager
// http://www.mylittletools.net
// webmaster@.mylittletools.net
|||Chris,
One option...
'SQL Server Web Data Administrator'
http://www.microsoft.com/downloads/d...displaylang=en
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Illicom Newsgroups" <chrisj@.illicom.net> wrote in message
news:hRHzc.3428$Hf.1942321@.newshog.newsread.com...
> What is the best and quickest way to develop, or download, an interface
that
> clients can use to query sql?
> Thanks,
> CJ
>

Interfacing SSRS Deep Integration to Sharepoint - 3rd time lucky?!

I am looking for the actual interface that will allow me to interface with
the SSRS Web Part from the Sharepoint Deep Integration suite. It appears that
it needs a doclib interface, I guessed it was the IListProvder but now find
it is not and not even IRowProvider. Can you / they tell me what it needs to
be to properly interface with it both from the
'Get Report Definitions From' connection
but also
'Get Report Parameters From' connection
For The latter I also need to know how to marry up the Parameters in say a
Filter Web Part with the SSRS Web Part Deep Integration.
Now have finally configured no spam alias and set up profile - will this
make a difference to the response time! Come on Microsoft you can do this,
not rocket science surely?
--
Steve G16 days and counting still no response - what happened to 48 hours response
promise?
--
Steve G
"ezeget.com" wrote:
> I am looking for the actual interface that will allow me to interface with
> the SSRS Web Part from the Sharepoint Deep Integration suite. It appears that
> it needs a doclib interface, I guessed it was the IListProvder but now find
> it is not and not even IRowProvider. Can you / they tell me what it needs to
> be to properly interface with it both from the
> 'Get Report Definitions From' connection
> but also
> 'Get Report Parameters From' connection
> For The latter I also need to know how to marry up the Parameters in say a
> Filter Web Part with the SSRS Web Part Deep Integration.
> Now have finally configured no spam alias and set up profile - will this
> make a difference to the response time! Come on Microsoft you can do this,
> not rocket science surely?
> --
> Steve G
>

Interfacing SQL Server with Access...

I have a web based SQL Server application that I need to modify to include data that is currently stored in an Access mdb. The mdb file and SQL Server are running on the same box. The data that is on the Access system cannot be migrated to SQL Server since it is a commercial package. But in our web application we want to query this data (and that in the SQL Server database) and present both current information to the users. We don't need to edit the Access data. Just view it and combine it with data we now have in SQL Server.

I was thinking I would build views or stored procedures that would pull info from both the SQL Server tables and the Access tables. But I'm not sure how efficient this is. One issue is that the users are remote, meaning many will not be in the same building that the SQL Server box is located at.

What is the best way to accomplish this? Any ideas? I've thought about using DTS but maybe it is overkill.

Thanks for the help.I would not query the access data from a web app. It will choke and die once you get about 20 connectins to it at a time. If you can live with the access data not being real time I would setup a job that fires daily or hourly that pulls the data into sql server daily or hourly or every 15 minutes. Or if you have the development manpower, redevelop the Access app to use sql as the datasource with an Access Data Project. Access as a backend to a web app is a recipe for disaster. Seen it before.|||Thanks for the advice Sean. Seeing as we cannot redevelop the backend for SQL Server, our only option appears to be batch updating of data into our system from Access on a scheduled basis. Would we use something like DTS for this? What can we do in SQL Server to facilitate the transfer of data from Access to SQL Server?

Thanks Sean.|||Use a SQL Server Agent job that fires a DTS job.|||Use a SQL Server Agent job that fires a DTS job.

Thanks. Will do.sql