I wrote my own configuration tool to maintain the connection strings in a SQL table

I wrote my own VB app to maintain all of my connection strings and link them to packages. I then grab them at run time and set them as variables in memory.Sorry this was suppose to be a reply not a new post.

I need SQL Server Management Studio!

Hi,

I have just completely installed MS SQL Server 2005 Express Edition in MS Server 2003.
After installation, I only have the Configuration Manager, Error and Usage Reporting and Surface Area Configuration, listed under Configuration Details.

SQL Server Management Studio is not accessible anywhere.
I also do not have the folder C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell in which the SQL Server Management Studio is installed.
What must I do to get this component installed?

In this article http://msdn2.microsoft.com/en-us/library/ms143219.aspx, it is also written in step 8 that there should be a "Components to Install" page. I have done the installations and uninstallations a few times, but I still do not have "Components to Install" page. In fact, after step 7, I am brought to the "Features Selection" page.

What can I do to solve this problem? Please help.

Thanks.

You'll need to download the SQL Server Express Edition Toolkit. Get it at the following page:

http://msdn2.microsoft.com/en-gb/express/bb410792.aspx

HTH!

|||Thanks, it has helped a lot!

I need help about two server configuration

Hello I have one sql server 2000 and one MSDE , I need a database replicated
in two servers, but I can't modify table structures.
I need to make data modifications in SQL Server and in MSDE, what type of
replication can I use ?
Thank you .
Guillermo
Guillermo,
there are several choices, depending on your setup:
If you are expecting conflicts then the (out of the box) choice is between
queued updating and merge replication. Queued updating won't work if you are
replicating BLOBs but it is generally much faster than merge, especially as
you only have one subscriber.
If the data is completely partitioned, you could use bidirectional
transactional replication (not out of the box though).
If there is continual connectivity (unlikely as you are using MSDE as the
subscriber) then immediate updating subscribers could be relevant.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thank you Paul, but I can not use Merge because that type of replication
make changes in my table structures.
And transactional replication from sql server to MSDE is ok but what can I
do for MSDE to Sql Server?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> escribi en el mensaje
news:%23ynvRF95GHA.3592@.TK2MSFTNGP05.phx.gbl...
> Guillermo,
> there are several choices, depending on your setup:
> If you are expecting conflicts then the (out of the box) choice is between
> queued updating and merge replication. Queued updating won't work if you
are
> replicating BLOBs but it is generally much faster than merge, especially
as
> you only have one subscriber.
> If the data is completely partitioned, you could use bidirectional
> transactional replication (not out of the box though).
> If there is continual connectivity (unlikely as you are using MSDE as the
> subscriber) then immediate updating subscribers could be relevant.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
|||Guillermo,
if you go down the transactional route, you'll still have schema changes for
updating subscribers. You're quite right that bidirectional transactional
replication isn't an option as you have MSDE and hence can't publish from
it. So, for merge or transactional you'll have another column added. If you
want a solution that doesn't alter the schema at all, then for your
requirements you could consider Redgate DataCompare which just uses Primary
Keys as identifiers. BTW, what is the problem with the schema being altered
to add the extra column?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||"what is the problem with the schema being altered to add the extra
column?"
I fear that it causes errors in my applications
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> escribi en el mensaje
news:uFjTFnF6GHA.1256@.TK2MSFTNGP04.phx.gbl...
> Guillermo,
> if you go down the transactional route, you'll still have schema changes
for
> updating subscribers. You're quite right that bidirectional transactional
> replication isn't an option as you have MSDE and hence can't publish from
> it. So, for merge or transactional you'll have another column added. If
you
> want a solution that doesn't alter the schema at all, then for your
> requirements you could consider Redgate DataCompare which just uses
Primary
> Keys as identifiers. BTW, what is the problem with the schema being
altered
> to add the extra column?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||I would only think so if these applications use "select * from ...", which
is pretty unusual. In other cases you'll be OK.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .