attach db with a deleted log

Hello,
How can i attach a db where there is a log deleted.
When i want to attach the db, i cannot click the ok button because a
second log-file is missing.
Anyway to work around this?Don't use Enterprise Manager. Use sp_attach_db or
sp_attach_single_file_db. See Books Online for details and examples of
those commands.
Make sure you have a good backup of your MDF/LDF files before you try
to attach them.
David Portas
SQL Server MVP
--sql

Assisted Editor

I have a book that refers to the "SQL Server Assisted Editor" in management
Studio. but when I right click on the Stored Procedure node or anything
else I can't get the Assisted Editor. Where is it?
Regards,
Gary Blakely
GaryDean (GaryDean@.newsgroups.nospam) writes:
> I have a book that refers to the "SQL Server Assisted Editor" in
> management Studio. but when I right click on the Stored Procedure node
> or anything else I can't get the Assisted Editor. Where is it?
It was in the betas of Mgmt Studio, but it was dropped along the way. In
my opinion, it was just as well, since it did really add that much. One
shortcoming as I recall was that you could only add a new parameter at
the end of the parameter lsit.
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
|||Often, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:
Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).
If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"GaryDean" <GaryDean@.newsgroups.nospam> wrote in message
news:eEoY8jMFHHA.3776@.TK2MSFTNGP02.phx.gbl...
>I have a book that refers to the "SQL Server Assisted Editor" in management
>Studio. but when I right click on the Stored Procedure node or anything
>else I can't get the Assisted Editor. Where is it?
> --
> Regards,
> Gary Blakely
>
|||Hi Gary,
Please notice that I'v replied to the same issue in
microsoft.public.sqlserver.server newsgroup. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

asp.net report (rdlc) file cannot create dataSource

With asp.net 2005 - after I create a report (rdlc) file, I try to create a
Data Source (Report menu, then click "Data Sources", I get error:
The root element of a WC3 XML Schema should be <schema> and its namespace
should be 'http://www.w3.org/2001/XMLSchema'.
Can I fix this?
Thanks
--
JayYou can create the data source later in the ReportingServe Manager.
Dont use shared data sources in this case..
I dont know why you are getting that error but that is an alternative.

Asp.net 2.0 Vista Sql Express Error

I am developing a web site in asp.net 2.0 using visual studio 2005 and SQL express.

I tried to add a new Sql database using right click on the App_Data folder and adding the DB.

I get an error that the VS could not find a sql Express installed.

I want to clarify that I have installed the SQL express SP2 for vista version and that I can connect to SQL express db using management studio.

I think it is a vista issue probably that UA.

What can I do?

pls do not recommend the next step I already tried itL

If I create the DB on XP and transfer the project to my vista machine the db is there but I cannot connect to it.

Hi,

There are many side-effects with Vista. SQL Server Express will be supported with SP2 (which is not RTM yet) for Vista and Visual Studio won′t be supported after applying SP1 and additional hotfixes, So I guess its hard to help you here, sorry. Using Vista in that case for testing purposes would be ok as of my opinion but using it for productional developing would be too early for me.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi Itzik,

FYI - VS 2005 is not certified on Vista yet, so this may well be a VS issue.

When you installed SQL Express SP2 did you check the option to create yourself as an administrator? If you did not, you would not have permission to create a database from anywhere. Any user on the computer has the ability to connect to SQL Express, but not necesarily create objects. Have you confirmed if you can create database using Management Studio? If you can't, you don't have the right permissions set.

Information on getting Express SP2 working on Vista is avaliable here.

Mike

|||

OK GUYS

First of all thanks for trying to help.

I decided to fought with it until I solve it.

Yes I did check the administrator button (but even if I am not I could always add myself to the sysadmin group manually, but it is a blessing change in SP2).

This is what went wrong if anybody else asks:

1. I installed the Sql express SP2 as default. The visual studio when adding a file db using SQL express is looking for the instance SQLEXPRESS ([computer name]\Sqlexpress is the full name).

2. I went to Tools and changed the instance name to blank as they ask me to in case of default installation. But that did not work fully (I could create the DB file but couldn't access it through the asp .net configuration pages).

3. So on that point I uninstalled the SQL express and installed it again under the required Sqlexpress (Shooting in the dark assuming the default is not supported under vista or something like that).

Amazingly it worked great. (I also installed it under local system rather than Network service so maybe this helps too).

Hope I saved some lost souls

Itzik Katzav