Showing posts with label book. Show all posts
Showing posts with label book. Show all posts

Monday, March 19, 2012

Installation Adventure Works after update to sp1

Hello,
i wonder if it is possible to install the adventure works sample db
after updating to ms sql reporting svcs sp1. I got a new book and want
to do the trainings on it and would like to know if there are problems
or issues that have to be cared about.
Thanks a lot in advance.
Kind regards
JensNo problems adding the database for use with RS.
--
| From: hickmann@.strama.info (Jens Hickmann)
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Installation Adventure Works after update to sp1
| Date: 29 Apr 2005 05:17:39 -0700
| Organization: http://groups.google.com
| Lines: 12
| Message-ID: <e262d5b5.0504290417.3e0127c3@.posting.google.com>
| NNTP-Posting-Host: 136.199.62.179
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1114777060 10883 127.0.0.1 (29 Apr 2005
12:17:40 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Fri, 29 Apr 2005 12:17:40 +0000 (UTC)
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!no
t-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42291
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello,
|
| i wonder if it is possible to install the adventure works sample db
| after updating to ms sql reporting svcs sp1. I got a new book and want
| to do the trainings on it and would like to know if there are problems
| or issues that have to be cared about.
|
| Thanks a lot in advance.
|
| Kind regards
|
| Jens
|

Monday, March 12, 2012

Install an mdf file

Can anyone give me the command line text to install an mdf file? I have a file called contacts.mdf from a Microsoft book and need to install it to MSDE in order to complete the examples in the book.

Thanks in advance.NOt sure if this will work in MSDE, but try sp_attach_db

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp

Actually, it looks like it will work. Look at step 2 here:

http://support.microsoft.com/kb/q231923/|||Thanks, Chrisrock. I finally got it to work using sp_attach_db.