Manage MSDE databases with SSMS?

We have an XP workstation containing a very important MSDE-based
application. Its MSDE database isn't likely to change for quite a
while.
The app contains an internal backup method (File, Backup, Backup) and
an auxiliary app/script for shrinking the database and logs. I would
like to automate the backup and shrinking so end users don't have to
remember to do them.
The workstation has a static IP so it can go out to the Internet when
necessary. The workstation is presently not joined to the domain.
1. Can I install SSMS Express *only* as a local app (without SQL
Express 2005) and thus use SSMS to set up nightly backups and periodic
shrink database/logs jobs?
2. We have SSMS running on SQL 2005 server box in the domain. If I
join the workstation only to the domain (local account logon is not
changed, still used), could I use SSMS from the SQL 2005 box? Would I
need a domain login on the XP box to make this work?
Thank you, Tom
I stand corrected...I know one is not supposed to double-post.
I found this NG after I had posted to the other groups, and I could
not figure out how active the other two groups are, and this NG had
more past posts about SSMS/MSDE than the other groups, so it seemed
appropriate to also inquire here.
Thank you, Tom
|||FYI, you can add as many newsgroups as you like to the Newsgroups header and
the post appears in all of them as does the replies. He wasn't suggesting
you shouldn't post in more than one group, just don't do it individually.
Andrew J. Kelly SQL MVP
"tlyczko" <tlyczko@.gmail.com> wrote in message
news:1185491191.280988.292210@.19g2000hsx.googlegro ups.com...
>I stand corrected...I know one is not supposed to double-post.
> I found this NG after I had posted to the other groups, and I could
> not figure out how active the other two groups are, and this NG had
> more past posts about SSMS/MSDE than the other groups, so it seemed
> appropriate to also inquire here.
> Thank you, Tom
>
|||Andrew J. Kelly (sqlmvpnooospam@.shadhawk.com) writes:
> FYI, you can add as many newsgroups as you like to the Newsgroups header
> and the post appears in all of them as does the replies. He wasn't
> suggesting you shouldn't post in more than one group, just don't do it
> individually .
Since tlyczko seems to have found this group after his first post, that
appears a little difficult to do. But he could have had some patience
before he tried this forum.
I saw that tlyczko had another question about activity in
comp.databases.ms-sqlserver this morning. It seems to me that while
comp.databases.ms-sqlserver has a fairly low traffic, it still more active
than the .tools newsgroup, which is kind of funny. But many tools questions
are asked in the "big" groups .programming and .server. It appears that
Microsoft has been a bit over-zealous when set up the various sets of
groups.
And I should explain the reason double-posting is bad, is that it could
lead to people wasting time on answering a question that already has a good
answer elsewhere.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Yeah...I really don't think people understand this. To them,
they are getting feedback from several different sources so
they think it's good.
An indirect bad effect - I encourage customers to search
newsgroups to find answers. I just got an email from
someone who said most of the answers to the question they
searched on were "already answered in another
newsgroup...please don't multipost" and they couldn't find
where it was actually answered.
-Sue
On Fri, 27 Jul 2007 09:36:29 +0000 (UTC), Erland Sommarskog
<esquel@.sommarskog.se> wrote:

>And I should explain the reason double-posting is bad, is that it could
>lead to people wasting time on answering a question that already has a good
>answer elsewhere.

Making Inegration Services visible/available in SSMS 2005

I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..

How can I make it visible in the New Project window?

I have successfully used the import function so I think this means
that Inegration Services is there somewhere.

I would appreciate some advice,

Best wishes, John MorganJohn Morgan wrote:

Quote:

Originally Posted by

I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..
>
How can I make it visible in the New Project window?
>
I have successfully used the import function so I think this means
that Inegration Services is there somewhere.
>
I would appreciate some advice,
>
Best wishes, John Morgan

What version of 2005 are you using?|||John Morgan (jfm@.XXwoodlander.co.uk) writes:

Quote:

Originally Posted by

I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..
>
How can I make it visible in the New Project window?
>
I have successfully used the import function so I think this means
that Inegration Services is there somewhere.

I believe the place to work with Integrations Services is the
Business Intelligence Development Studio.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks both of you. Using your info and investigating the matter
further to make sure I don't hask silly questions has got me the
answer.

I checked the configuration manager and found that integrated services
was listed as running, I looked again and, yes, I did see SQL
Buisiness iIntelligence Studio was part of the programme group.

Opened it up and the VStudio installed templates for Integration
Services Project were visible.

Thanks
John Morgan

On Sun, 28 Jan 2007 08:24:28 -0600, Jonathan Roberts
<gremln007@.diynics.comwrote:

Quote:

Originally Posted by

>John Morgan wrote:

Quote:

Originally Posted by

>I have installed SQL Server Management Studio 2005 and have been
>finding the equivalent of the Data Transfer Services in SQLServer
>2000. I think I have worked out that it is in SQL Server Integration
>Services but when I open File-New-Project I do not see the SQL Server
>Integration Services there, though Help assumes that it is available
>for selection when starting a new project..
>>
> How can I make it visible in the New Project window?
>>
>I have successfully used the import function so I think this means
>that Inegration Services is there somewhere.
>>
>I would appreciate some advice,
>>
>Best wishes, John Morgan

>
>What version of 2005 are you using?

sql

Make Changes to Published Database

Vince,
are you making changes through the GUI (SSMS)? It sounds like you are, but
you'll need to use ALTER TABLE instead (see
http://www.replicationanswers.com/AlterSchema2005.asp).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Yes, I am using the SSMS gui. It is really the only thing I feel safe
working with.
I read your post and that is the exact error I get when trying to make
changes to my published tables. I may have bitten off more than I can chew
with this. I guess my real question/problem/concern is this:
Let's say I have 500+ subscribers and they all have between 25 and 50 MB of
data in their local store (SQLce). At some point I will want to make
changes to my program which require new fields, field name changes, new
tables, etc. From what I am encountering I have to go into the SSMS gui,
delete the publication and all subscriptions and then make changes to my
tables. At this point all the users still have their data in their local
SQLce file; this is what I want so far. However, when I recreate my
publication on the central server and the subscribers go to synchronize what
will happen? I assume it will not find the subscription on the server. So,
will the user be required to delete the file and start over with a new
initialization or can I just add that subscription back to the central
server and just propogate only the changes to the subscribers? What about
changes that the subscriber makes to their local SQLce file during the time
that I removed the publication and then recreated it?
I understand I can do this stuff using scripts and stored procedures, etc.,
but I have zero experience with that and I am kind of afraid to mess with
anything other than the SSMS gui when I have this in production.
I am only a programmer not a dba. I understand
indexing/relationships/tables/field types and so on, but TSQL is foreign to
me. Thanks in advance for your patience.
Vince
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eGC7XcgKHHA.4460@.TK2MSFTNGP03.phx.gbl...
> Vince,
> are you making changes through the GUI (SSMS)? It sounds like you are, but
> you'll need to use ALTER TABLE instead (see
> http://www.replicationanswers.com/AlterSchema2005.asp).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
|||Vincent,
you really don't want to reinitialize for all schema changes. If you are
confortable with the SSMS gui, then by all means use that to add articles.
To chnage an existing article, just study ALTER TABLE in BOL - as you're a
programmer, this will be easy to pick up.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .