attach database option disabled

Hi,
I am trying to attach a database via enterprise manager
but the option to this is disabled. Is there anyway I can
enable this option?
Thanks in advance
JenCIs the server you're connected to using SQL Server 7? If so, then no, you
cannot enable it. However, you can do the attach via Query Analyzer using
sp_attach_db (look up syntax in BOL).
"JenC" <anonymous@.discussions.microsoft.com> wrote in message
news:1b4401c4999a$277726f0$3a01280a@.phx.gbl...
> Hi,
> I am trying to attach a database via enterprise manager
> but the option to this is disabled. Is there anyway I can
> enable this option?
> Thanks in advance
> JenC|||Hi,
I am using SQL 2000 and I have tried using sp_attach_db
but with no joy.
Thanks.
>--Original Message--
>Is the server you're connected to using SQL Server 7? If
so, then no, you
>cannot enable it. However, you can do the attach via
Query Analyzer using
>sp_attach_db (look up syntax in BOL).
>
>"JenC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1b4401c4999a$277726f0$3a01280a@.phx.gbl...
>> Hi,
>> I am trying to attach a database via enterprise manager
>> but the option to this is disabled. Is there anyway I
can
>> enable this option?
>> Thanks in advance
>> JenC
>
>.
>|||"JenC" <anonymous@.discussions.microsoft.com> wrote in message
news:124b01c4999d$6ca7ada0$a301280a@.phx.gbl...
> I am using SQL 2000 and I have tried using sp_attach_db
> but with no joy.
Do you want to post your error and some more information about the
problem? How was the database detached?|||Hi,
I have sorted it out now (touch wood). Basically we have a
setup program that as part of the install installs MSDE
2000, unfortunately on some PC's (mainly Win XP PCs) it
installs the earlier version of MSDE and this is what
caused the confusion. I have now successfully installed
MSDE 2000 and I can now attach databases to my hearts
content.
Thanks for your help.
Jen
>--Original Message--
>"JenC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:124b01c4999d$6ca7ada0$a301280a@.phx.gbl...
>> I am using SQL 2000 and I have tried using sp_attach_db
>> but with no joy.
> Do you want to post your error and some more
information about the
>problem? How was the database detached?
>
>.
>

Assessment of Database Stored Procedures

I am attempting to compile a list of questions that will enable me
assess 'at risk' stored procedures that need to be remediated in order
to minimize unplanned downtime and enhance database performance. Is
there a subset of criteria (parameters) from the MS SQL Server Best
Practices Analyzer that can be used for this purpose? Any pointers to
the appropriate documentation is most welcome.

Thanks in advance.It depends what you class as acceptable criteria. It depends on the nature
of the stored procedures.
For example, if it's a simple SELECT statement , returning it in 6 seconds
may be to slow for the end user., and could point to something else being
the problem.
Check http://www.sql-server-performance.c...icles_audit.asp for a
systematic approach

--

Jack Vamvas
___________________________________
Need an IT job? <a href="http://links.10026.com/?link=http://www.itjobfeed.com">uk it jobs</a>

"Umar Reyi" <iyerra@.indiatimes.comwrote in message
news:1177366044.733092.100680@.y80g2000hsf.googlegr oups.com...

Quote:

Originally Posted by

>I am attempting to compile a list of questions that will enable me
assess 'at risk' stored procedures that need to be remediated in order
to minimize unplanned downtime and enhance database performance. Is
there a subset of criteria (parameters) from the MS SQL Server Best
Practices Analyzer that can be used for this purpose? Any pointers to
the appropriate documentation is most welcome.
>
Thanks in advance.
>

ASP.Net Trace File

When we enable tracing for a web application where exactly the file or content of the file "Trace.axd" saves?I can't for the life of me understand why this is in this forum. lol|||Well thanks for your EXPLICIT guide!|||No. not this site forum. I'm saying under Sql Server. I'd assume you'd get a lot better results in a more framework oriented forum.

SHEESH!!!

for someone that's requesting help FOR FREE, you're of foul humor. I mean seriously, my life isn't richer and my soul isn't closer to heaven just cuz I help you. It's sheerly by the kindness of my heart and the boredom of insomnia that I'm here even replying to you. So at least be grateful for that.

*clears throat*

Any simpleton would have already tried this

the very first result comes from gotdotnet.
Any other semi-intelligent individual would have seen this one

within that, the set of paragraphs states:
---
In addition to the Page-level Trace funtionality, ASP.NET provides a way to enable trace output for an entire application. Enabling Trace at the application level has the effect of enabling Page-level Trace for every page within that application (provided there is no page-level directive to explicitly disable trace). When application-level tracing is enabled, the ASP.NET runtime also collects several additional statistics, such as the state of the control hierarchy, the contents of session and application state, the form and querystring input values, and other characteristics of request's execution. These statistics are collected for a specified number of requests as determined by the application's configuration file. To enable tracing for an application, place the following in the application's web.config file at the application root directory:

<configuration>
<system.web>
<trace enabled="true"/>
</system.web>
</configuration
Using the above configuration, each page in the application will run its page-level trace statements to be output in the client browser. To access the additional page statistics, request a specially-mapped "trace.axd" URL from the application root. For example, if the URL to your application is http://localhost/myapplication, you would request the URL http://localhost/myapplication/trace.axd to access the trace statistics for that application.
----
kthx bye bye|||I think if you're looking to be richer and want your soul to be closer to heaven , you should'nt be on "Technical Forums" (I think you already know this!!) , you probably used other's ideas , you got other's help (wether it was the kindness of their hearts or anything else) , now you go'n to pass it over (although you can NOT pass it over , too!) , but there's no big deal! once u're helped , once you're helping!
But I appreciate your activity (as any-other-one's)

Yes , I've been "Simpleton" and tried that , though I've read more than this before.

The only statement that might help , is THIS

"To access the additional page statistics, request a specially-mapped "trace.axd" URL from
the application root."

It is mapped , so where's the real version (which that has physical address on the server)?
I knew the mapped URL , but I still don't know where it physically stores on the server!

Thanks again!

ASP.Net DS ->SSRS Report? ...or do I?

Is there a "native" way to pass a sorted table or dataset to a SSRS?
Or, is there another way to do the following...
I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
params.
These will use a sProc that executes some dynamic SQL to accomodate the
variations in params passed.
This is all good and working as a prototype in .Net.
However, most of the results sent to the browser also need to be sorted and then
hard copy printed, so...
Option One; Have the ASP.Net app do all .Net datalists and the like presenting
all the data as needed. Then when a user wishes to print that data they click
the printable version link, which would pass the current dataset as sorted to
SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
alone.)
Option Two; Write my sorted data to a dynamic (rather than temp table) and then
call SSRS with params to get all the data as is from the dynamic table.
Option Three; give up, go home, take a nap, be a quiter, start crying like a
little boy, melt into a puddle of goo.
TIA
JeffP....I suggest rethinking a little how you do this. RS has a couple of ways to
integrate with your ASP. It has very good support for stored procedures. So
you can already use your stored procedure. You can integrate either by URL
or by web services. URL integration is the easiest way to go. Try just
creating a report with RS using the stored procedure and the parameters.
Once you have a report working then try out URL integration.
Passing a dataset is the hardest way to go to solve this. People have done
this but it requires a lot of jumping through hoops.
Bruce L-C
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:e6eWkzObEHA.2340@.TK2MSFTNGP10.phx.gbl...
> Is there a "native" way to pass a sorted table or dataset to a SSRS?
> Or, is there another way to do the following...
> I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
> params.
> These will use a sProc that executes some dynamic SQL to accomodate the
> variations in params passed.
> This is all good and working as a prototype in .Net.
> However, most of the results sent to the browser also need to be sorted
and then
> hard copy printed, so...
> Option One; Have the ASP.Net app do all .Net datalists and the like
presenting
> all the data as needed. Then when a user wishes to print that data they
click
> the printable version link, which would pass the current dataset as sorted
to
> SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
> alone.)
> Option Two; Write my sorted data to a dynamic (rather than temp table) and
then
> call SSRS with params to get all the data as is from the dynamic table.
> Option Three; give up, go home, take a nap, be a quiter, start crying like
a
> little boy, melt into a puddle of goo.
> TIA
> JeffP....
>|||Bruce,
I had a friend who is a much better programmer come over and we did a simple
sProc and created a SSRS Report.
We then ran the report as a SSRS report and then via URL; our biggest pain was
overcomming the "...you do not have permission to view this page..." or similar.
We added a default credential process if one was not present as well as a
user/pass textboxes w/cmd button to go to the report as a proof of concept that
we can accept win/auth, (won't be happening in any environment we have before
us) or default creds.
Anyway, back to my pain of displaying a report that was derived from the current
datalist control filtered and sorted as such.
I may try my dyna-temp table method. I think that there is a rumor indicating
that SSRS 05 will enable a method to call a SSRS report and pass it a .Net
DS/table.
I'd have thought that this would have been a first ed. feature(?)
TIA
JeffP...
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ONp0KaPbEHA.3664@.TK2MSFTNGP12.phx.gbl...
> I suggest rethinking a little how you do this. RS has a couple of ways to
> integrate with your ASP. It has very good support for stored procedures. So
> you can already use your stored procedure. You can integrate either by URL
> or by web services. URL integration is the easiest way to go. Try just
> creating a report with RS using the stored procedure and the parameters.
> Once you have a report working then try out URL integration.
> Passing a dataset is the hardest way to go to solve this. People have done
> this but it requires a lot of jumping through hoops.
> Bruce L-C
> "JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
> news:e6eWkzObEHA.2340@.TK2MSFTNGP10.phx.gbl...
> > Is there a "native" way to pass a sorted table or dataset to a SSRS?
> >
> > Or, is there another way to do the following...
> >
> > I need to enable a minimum of 3 combo box drop downs to search by, a.k.a.
> > params.
> >
> > These will use a sProc that executes some dynamic SQL to accomodate the
> > variations in params passed.
> >
> > This is all good and working as a prototype in .Net.
> >
> > However, most of the results sent to the browser also need to be sorted
> and then
> > hard copy printed, so...
> >
> > Option One; Have the ASP.Net app do all .Net datalists and the like
> presenting
> > all the data as needed. Then when a user wishes to print that data they
> click
> > the printable version link, which would pass the current dataset as sorted
> to
> > SSRS, (my personal opinion is that this cannot be done with .Net and SSRS
> > alone.)
> >
> > Option Two; Write my sorted data to a dynamic (rather than temp table) and
> then
> > call SSRS with params to get all the data as is from the dynamic table.
> >
> > Option Three; give up, go home, take a nap, be a quiter, start crying like
> a
> > little boy, melt into a puddle of goo.
> >
> > TIA
> >
> > JeffP....
> >
> >
>

ASP.NET 2.0 Interface for SSIS

Hi there,

we have several DWH Load processes running in SSIS, however I want to enable the enduser to have more control and information about the status of these processes. Therefore I plan to write a monitoring interface based on ASP.NET 2.0. However I hardly could find good docu or samples on what is available from within ASP.NET 2.0 to read out or control SSIS.

Anybody having me some good pointers to start with ?

To control Ssis packages programmatically start with the Microsoft.SqlServer.ManagedDTS assembly, (Microsoft.SQLServer.ManagedDTS.dll). For the more monitoring type functions, I don’t think there is anything specific, but I’d suggest you look at the logging built into SSIS, set this on in your packages, and query the destination log.

There is also the SSIS service, but not sure if there is a way of communicating with that, other than basic service APIs, and/or WMI.

|||Application class in Microsoft.SqlServer.Dts.Runtime namespace (Microsoft.SQLServer.ManagedDTS.dll assembly) provides some ability to interact with service and monitor/manage running packages. In particular, see
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.getrunningpackages.aspx
method.

Together with SSIS logging this should provide the API you need.