Another example of incomplete support of some legal database names

It has already been reported that the View tool in Enterprise Manager
cannot handle databases which have a period in their name (e.g.
"mydomain.com"). It doesn't show the individual field names.
Today I found a second problem: when scheduling a Job under SQL Server
Agent, in the New Step dialog you are prompted for a database name.
Databases with a period in their name are not listed. Tomorrow I'll
use ISQL to schedule the job in Windows Scheduler.
Hopefully MSFT will add these tests to the test scripts for the next
version and service pack (but don't hold your breath).
PS: I inherited this database name. It's too late (read: expensive)
now to fix it.
-Tom.Many of the tools do not support non-standard object names.
Even though SQL Server lets you create objects with invalid
names they aren't really legal names. You can find the rules
for object names in books online under the topic Using
Identifiers
-Sue
On Tue, 23 Mar 2004 19:39:31 -0700, Tom van Stiphout
<tom7744@.no.spam.cox.net> wrote:

>It has already been reported that the View tool in Enterprise Manager
>cannot handle databases which have a period in their name (e.g.
>"mydomain.com"). It doesn't show the individual field names.
>Today I found a second problem: when scheduling a Job under SQL Server
>Agent, in the New Step dialog you are prompted for a database name.
>Databases with a period in their name are not listed. Tomorrow I'll
>use ISQL to schedule the job in Windows Scheduler.
>Hopefully MSFT will add these tests to the test scripts for the next
>version and service pack (but don't hold your breath).
>PS: I inherited this database name. It's too late (read: expensive)
>now to fix it.
>-Tom.|||On Tue, 23 Mar 2004 19:39:31 -0700, Tom van Stiphout wrote:

>It has already been reported that the View tool in Enterprise Manager
>cannot handle databases which have a period in their name (e.g.
>"mydomain.com"). It doesn't show the individual field names.
>Today I found a second problem: when scheduling a Job under SQL Server
>Agent, in the New Step dialog you are prompted for a database name.
>Databases with a period in their name are not listed. Tomorrow I'll
>use ISQL to schedule the job in Windows Scheduler.
>Hopefully MSFT will add these tests to the test scripts for the next
>version and service pack (but don't hold your breath).
Hopefully not. I would prefer that MSFT removes the ability to call a
database "mydomain.com" or other pathological formats.

>PS: I inherited this database name. It's too late (read: expensive)
>now to fix it.
That's too bad.
I presume that you can still write scripts for all of the things that
you can't accomplish via the GUI? If so, then you have the tradeoff
costs of writing everything in scripts versus changing the name of the
database in the application (and all the associated testing).
--
"There is more to life than simply increasing its speed." - Mahatma Gandhi|||On Tue, 23 Mar 2004 21:32:35 -0700, Sue Hoegemeier
<Sue_H@.nomail.please> wrote:
You are correct. To my horror I found that:
sp_renamedb 'pubs', '123'
works, while BOL clearly has strict rules about the first character of
an identifier.
Would it kill MSFT to implement those rules, and not allow identifiers
that it later can't work with?
-Tom.
>Many of the tools do not support non-standard object names.
>Even though SQL Server lets you create objects with invalid
>names they aren't really legal names. You can find the rules
>for object names in books online under the topic Using
>Identifiers
>-Sue
>On Tue, 23 Mar 2004 19:39:31 -0700, Tom van Stiphout
><tom7744@.no.spam.cox.net> wrote:
>|||You could always send your request for this to
sqlwish@.microsoft.com
-Sue
On Wed, 24 Mar 2004 06:56:01 -0700, Tom van Stiphout
<tom7744@.no.spam.cox.net> wrote:
>On Tue, 23 Mar 2004 21:32:35 -0700, Sue Hoegemeier
><Sue_H@.nomail.please> wrote:
>You are correct. To my horror I found that:
>sp_renamedb 'pubs', '123'
>works, while BOL clearly has strict rules about the first character of
>an identifier.
>Would it kill MSFT to implement those rules, and not allow identifiers
>that it later can't work with?
>-Tom.
>

Another Enterprise Manager Question

I used to do all my MSDE dev in MS Acc2K. As I was converting a friend to
developing SQL Dbs rather than Access mdb one, he discovered and downloaded
from the MS Site a util called client tools which turned out to be Enterprise
Manager.
Is this no longer available for download? If so can anyone point me to it?
I'm about to try out the web based item that I've just downloaded but I'm so
used to EM I'd prefer it if possible.
Regards,
Mr. Smith
The new SQL 2005 Express has some tools like that available. For MSDE 2K,
you'd have to either use EM off a SQL 2K CD, locate a third-party app, or
use an ASP/ASP.NET version.
"Mr. Smith" <MrSmith@.discussions.microsoft.com> wrote in message
news:8AAA465B-8043-4924-A13F-728968BDB246@.microsoft.com...
> I used to do all my MSDE dev in MS Acc2K. As I was converting a friend to
> developing SQL Dbs rather than Access mdb one, he discovered and
> downloaded
> from the MS Site a util called client tools which turned out to be
> Enterprise
> Manager.
> Is this no longer available for download? If so can anyone point me to
> it?
> I'm about to try out the web based item that I've just downloaded but I'm
> so
> used to EM I'd prefer it if possible.
> Regards,
> Mr. Smith
|||Thanks for that. I had a feeling. The Web based offering from MS is
useless, Acc2K has far better tools to admin MSDE than that. I've gotten
hold of EMS MS SQL Lite which is OK in the interim but I'm gonna have to get
hold on an SQL2K disc
Regs,
Mr. Smith
"Michael C#" wrote:

> The new SQL 2005 Express has some tools like that available. For MSDE 2K,
> you'd have to either use EM off a SQL 2K CD, locate a third-party app, or
> use an ASP/ASP.NET version.
> "Mr. Smith" <MrSmith@.discussions.microsoft.com> wrote in message
> news:8AAA465B-8043-4924-A13F-728968BDB246@.microsoft.com...
>
>

Angry about Reporting Services

I have seen the odd thread on here that just mentions in passing that data-driven subscriptions are only available on the SQL 2005 Enterprise edition. Does no-one else but me think that this is absolutely disgraceful? We bought SQL Server Standard for our 2 processor server and it cost just under ￡8,000. The only reason we would have to buy Enterprise is for the data-driven subscriptions in RS and that would cost us ￡33,000. When the beta of RS came out, it had data-driven subscriptions at all levels. When RS 2000 came out, we could easily get a legitimate copy of RS 2000 Enterprise from Microsoft and have the same functionality. Now we have to pay ￡25,000 for the privilege or hand-code the whole thing. I repeat; this is an absolutely disgraceful piece of profiteering from Microsoft. Do they really think that data-driven subscriptions are only of value to people using the Enterprise edition?

This forum is intended for assistance and bug reporting with RS. Call customer support if you're that upset about the product. What do you expect them to do? Give it to you for free now because you're angry?

I think it is disgraceful that you would use an open forum to vent about a product that you purchased which is documented as to what it includes and what it does not include.

|||

I think it's disgraceful that a product which was in all versions of the beta and freely available in SQL 2000, now costs me ￡25,000 in SQL 2005. Don't you?

As I believe this forum is read by Microsoft developers, maybe I thought they could give me a rational response. If you know of a place where I can get a better response, or where I ought to post this, please let me know. It is not my intention to upset anyone on the forum, just to let Microsoft know how I feel about their product.

|||

Leaving strong words aside, I think your complaint is not unreasonble and it is good to provide this kind of feedback. Crossing the enterprise hefty price tag is not an easy sell especially for vendors. I tend to agree with you we are suffering from an "enterprise" identity crisis and thus the meaning of enerprise should be better scoped out. IMO, enterprise editions should differ only in the areas of scalability and to some extend extensibility in order to meet high loads and more involved integration requirements of large companies. Following this line of thought, I'd say that web farm deployment and partitioning are definately enterprise-level features while features like data-driven subscriptions and semi-additive measures (SSAS) are probably not.

From BOL: "Enterprise Edition scales to the performance levels required to support the largest enterprise online transaction processing (OLTP), highly complex data analysis, data warehousing systems, and Web sites. Enterprise Edition’s comprehensive business intelligence and analytics capabilities and its high availability features such as failover clustering allow it to handle the most mission critical enterprise workloads. Enterprise Edition is the most comprehensive edition of SQL Server and is ideal for the largest organizations and the most complex requirements."

Analyze CPU Time per SQL Session

Hello
Installation is SQL Server 2005 Enterprise Edition with 8 Processor. Is it
possible to analyze which SQL Server Session is consuming how much Processor
Ressource in Time or Percent? With the DMV Views i see that there are 11000
open SQL server Session. The 8 CPU are constant by 80 Percent (perfmon and
Taskmanager). This server is dedicated for SQL Server.
With the View sys.dm_exec_sessions i see how many Sessions are open, but i
must now, how many CPU Consumption per Session, so i can identify the
Sessions who are responsable for the high CPU Workload
Somebody knows how i can use the DMV Views or are there tools to retrieve
the information?
regards
PaoloYou have already found sys.dm_exec_sessions. Have you looked at the
column cpu_time it returns?
Roy Harvey
Beacon Falls, CT
On Fri, 7 Mar 2008 09:05:44 +0100, "Paolo Taverna" <nomail@.nomail.nml>
wrote:
>Hello
>Installation is SQL Server 2005 Enterprise Edition with 8 Processor. Is it
>possible to analyze which SQL Server Session is consuming how much Processor
>Ressource in Time or Percent? With the DMV Views i see that there are 11000
>open SQL server Session. The 8 CPU are constant by 80 Percent (perfmon and
>Taskmanager). This server is dedicated for SQL Server.
>With the View sys.dm_exec_sessions i see how many Sessions are open, but i
>must now, how many CPU Consumption per Session, so i can identify the
>Sessions who are responsable for the high CPU Workload
>Somebody knows how i can use the DMV Views or are there tools to retrieve
>the information?
>regards
>Paolo
>|||Hi Roy
yes i had a look at the column cpu_time. So far i understand is the column
cpu_time the sum of the total cpu_time of the request since this Session is
alive. So if the column last_request_end_time is a lot behind the time when
the CPU's have high workload, the column total_cpu_time is not helpful.
Regards Paolo
"Roy Harvey (SQL Server MVP)" <roy_harvey@.snet.net> schrieb im Newsbeitrag
news:okf2t3demqlov8f9s7v1qca3ve11lhnl5v@.4ax.com...
> You have already found sys.dm_exec_sessions. Have you looked at the
> column cpu_time it returns?
> Roy Harvey
> Beacon Falls, CT
> On Fri, 7 Mar 2008 09:05:44 +0100, "Paolo Taverna" <nomail@.nomail.nml>
> wrote:
>>Hello
>>Installation is SQL Server 2005 Enterprise Edition with 8 Processor. Is it
>>possible to analyze which SQL Server Session is consuming how much
>>Processor
>>Ressource in Time or Percent? With the DMV Views i see that there are
>>11000
>>open SQL server Session. The 8 CPU are constant by 80 Percent (perfmon and
>>Taskmanager). This server is dedicated for SQL Server.
>>With the View sys.dm_exec_sessions i see how many Sessions are open, but i
>>must now, how many CPU Consumption per Session, so i can identify the
>>Sessions who are responsable for the high CPU Workload
>>Somebody knows how i can use the DMV Views or are there tools to retrieve
>>the information?
>>regards
>>Paolo|||It's not an ideal approach, but you could always take snapshots of the DMV
and find the cpu time differences between snapshots, and that should give you
some rough idea.
Linchi
"Paolo Taverna" wrote:
> Hi Roy
> yes i had a look at the column cpu_time. So far i understand is the column
> cpu_time the sum of the total cpu_time of the request since this Session is
> alive. So if the column last_request_end_time is a lot behind the time when
> the CPU's have high workload, the column total_cpu_time is not helpful.
> Regards Paolo
> "Roy Harvey (SQL Server MVP)" <roy_harvey@.snet.net> schrieb im Newsbeitrag
> news:okf2t3demqlov8f9s7v1qca3ve11lhnl5v@.4ax.com...
> > You have already found sys.dm_exec_sessions. Have you looked at the
> > column cpu_time it returns?
> >
> > Roy Harvey
> > Beacon Falls, CT
> >
> > On Fri, 7 Mar 2008 09:05:44 +0100, "Paolo Taverna" <nomail@.nomail.nml>
> > wrote:
> >
> >>Hello
> >>Installation is SQL Server 2005 Enterprise Edition with 8 Processor. Is it
> >>possible to analyze which SQL Server Session is consuming how much
> >>Processor
> >>Ressource in Time or Percent? With the DMV Views i see that there are
> >>11000
> >>open SQL server Session. The 8 CPU are constant by 80 Percent (perfmon and
> >>Taskmanager). This server is dedicated for SQL Server.
> >>With the View sys.dm_exec_sessions i see how many Sessions are open, but i
> >>must now, how many CPU Consumption per Session, so i can identify the
> >>Sessions who are responsable for the high CPU Workload
> >>
> >>Somebody knows how i can use the DMV Views or are there tools to retrieve
> >>the information?
> >>
> >>regards
> >>Paolo
> >>
>
>

Analysis Services upgrade to Enterprise Edition

I was running SQL 2000 Standard with the Analysis Services
repository in a SQL database.
I upgraded SQL to Enterprise. When a user tried to create
a partitioned cube he got: user-defined partitions are
available only if you install Analysis Services SQL Server
2000 Enterprise Edition
I "upgraded" to Analysis Services Enterprise - actually
all it did was reinstall. Since I had already migrated
the repository to SQL, my cubes did not exist.
Here is probably where my mistake occurred: I "re-
migraded" the repository to SQL ... my cubes are still not
there.
I have since restored the repository database from a pre-
upgraded Analysis Services version ... my cubes are still
not there.
I have a large project that is waiting for these cubes.
Please tell me I have a chance of getting these cubes back!
Does anyone have any suggestiongs?
TIA
WadeIf you were using SQL Database A as repository before upgrading and
migrating repsitory to SQL Database B after upgrading, then restore the
backup to Database A won't help. You need to edit the repository connection
string so it points to the database holds the right meta data for OLAP.
Thanks
Wei Zhang
Microsoft OLAP Support

Analysis Services upgrade to Enterprise Edition

I was running SQL 2000 Standard with the Analysis Services
repository in a SQL database.
I upgraded SQL to Enterprise. When a user tried to create
a partitioned cube he got: user-defined partitions are
available only if you install Analysis Services SQL Server
2000 Enterprise Edition
I "upgraded" to Analysis Services Enterprise - actually
all it did was reinstall. Since I had already migrated
the repository to SQL, my cubes did not exist.
Here is probably where my mistake occurred: I "re-
migraded" the repository to SQL ... my cubes are still not
there.
I have since restored the repository database from a pre-
upgraded Analysis Services version ... my cubes are still
not there.
I have a large project that is waiting for these cubes.
Please tell me I have a chance of getting these cubes back!
Does anyone have any suggestiongs?
TIA
Wade
If you were using SQL Database A as repository before upgrading and
migrating repsitory to SQL Database B after upgrading, then restore the
backup to Database A won't help. You need to edit the repository connection
string so it points to the database holds the right meta data for OLAP.
Thanks
Wei Zhang
Microsoft OLAP Support

Analysis Services Install - Add. componets not found.

I'm trying to install Analysis Services, and we have a full enterprise msdn
set,
but when I go to add additional components I can't fine Analysis Services on
the April 2004 cd available. It doesn't appear to be listed.
Anyone have an idea of what's up with that?
KenMHi Ken,
Can you check "Analysis Services" item in the same screen as "add
Additional Components" of the same sqlserver installation cd?
Thanks,
Dutta
"KenM" wrote:

> I'm trying to install Analysis Services, and we have a full enterprise msd
n
> set,
> but when I go to add additional components I can't fine Analysis Services
on
> the April 2004 cd available. It doesn't appear to be listed.
> Anyone have an idea of what's up with that?
> KenM|||Hi, thanks for the reply., and
Nope. That's the problem. I come to the screen that has two boxes in it
showing components and sub-components and no matter where I click I can not
find "Analysis Services" anywhere.
I have an academic version of the msdn enterprise and am installing it to
get MS Project Services on a Win2003 server.
Just can't seem to find it.
Any help will be appreciated.
Ken
"Chandan DUtta" wrote:
[vbcol=seagreen]
> Hi Ken,
> Can you check "Analysis Services" item in the same screen as "add
> Additional Components" of the same sqlserver installation cd?
> Thanks,
> Dutta
>
> "KenM" wrote:
>|||Its actually on the very first screen with SQL Install
starts. The same one that says "Install SQL"
It is not in the "Add additional components" screen with
some other Checkboxed items.

>--Original Message--
>Hi, thanks for the reply., and
>Nope. That's the problem. I come to the screen that has
two boxes in it
>showing components and sub-components and no matter where
I click I can not
>find "Analysis Services" anywhere.
>I have an academic version of the msdn enterprise and am
installing it to
>get MS Project Services on a Win2003 server.
>Just can't seem to find it.
>Any help will be appreciated.
>Ken
>"Chandan DUtta" wrote:
>
screen as "add[vbcol=seagreen]
installation cd?[vbcol=seagreen]
a full enterprise msdn[vbcol=seagreen]
fine Analysis Services on[vbcol=seagreen]
listed.[vbcol=seagreen]
>.
>

Analysis Services Install - Add. componets not found.

I'm trying to install Analysis Services, and we have a full enterprise msdn
set,
but when I go to add additional components I can't fine Analysis Services on
the April 2004 cd available. It doesn't appear to be listed.
Anyone have an idea of what's up with that?
KenM
Hi Ken,
Can you check "Analysis Services" item in the same screen as "add
Additional Components" of the same sqlserver installation cd?
Thanks,
Dutta
"KenM" wrote:

> I'm trying to install Analysis Services, and we have a full enterprise msdn
> set,
> but when I go to add additional components I can't fine Analysis Services on
> the April 2004 cd available. It doesn't appear to be listed.
> Anyone have an idea of what's up with that?
> KenM
|||Hi, thanks for the reply., and
Nope. That's the problem. I come to the screen that has two boxes in it
showing components and sub-components and no matter where I click I can not
find "Analysis Services" anywhere.
I have an academic version of the msdn enterprise and am installing it to
get MS Project Services on a Win2003 server.
Just can't seem to find it.
Any help will be appreciated.
Ken
"Chandan DUtta" wrote:
[vbcol=seagreen]
> Hi Ken,
> Can you check "Analysis Services" item in the same screen as "add
> Additional Components" of the same sqlserver installation cd?
> Thanks,
> Dutta
>
> "KenM" wrote:
|||Its actually on the very first screen with SQL Install
starts. The same one that says "Install SQL"
It is not in the "Add additional components" screen with
some other Checkboxed items.

>--Original Message--
>Hi, thanks for the reply., and
>Nope. That's the problem. I come to the screen that has
two boxes in it
>showing components and sub-components and no matter where
I click I can not
>find "Analysis Services" anywhere.
>I have an academic version of the msdn enterprise and am
installing it to[vbcol=seagreen]
>get MS Project Services on a Win2003 server.
>Just can't seem to find it.
>Any help will be appreciated.
>Ken
>"Chandan DUtta" wrote:
screen as "add[vbcol=seagreen]
installation cd?[vbcol=seagreen]
a full enterprise msdn[vbcol=seagreen]
fine Analysis Services on[vbcol=seagreen]
listed.
>.
>

Analysis Services Install - Add. componets not found.

I'm trying to install Analysis Services, and we have a full enterprise msdn
set,
but when I go to add additional components I can't fine Analysis Services on
the April 2004 cd available. It doesn't appear to be listed.
Anyone have an idea of what's up with that?
KenMHi Ken,
Can you check "Analysis Services" item in the same screen as "add
Additional Components" of the same sqlserver installation cd?
Thanks,
Dutta
"KenM" wrote:
> I'm trying to install Analysis Services, and we have a full enterprise msdn
> set,
> but when I go to add additional components I can't fine Analysis Services on
> the April 2004 cd available. It doesn't appear to be listed.
> Anyone have an idea of what's up with that?
> KenM|||Hi, thanks for the reply., and
Nope. That's the problem. I come to the screen that has two boxes in it
showing components and sub-components and no matter where I click I can not
find "Analysis Services" anywhere.
I have an academic version of the msdn enterprise and am installing it to
get MS Project Services on a Win2003 server.
Just can't seem to find it.
Any help will be appreciated.
Ken
"Chandan DUtta" wrote:
> Hi Ken,
> Can you check "Analysis Services" item in the same screen as "add
> Additional Components" of the same sqlserver installation cd?
> Thanks,
> Dutta
>
> "KenM" wrote:
> > I'm trying to install Analysis Services, and we have a full enterprise msdn
> > set,
> > but when I go to add additional components I can't fine Analysis Services on
> > the April 2004 cd available. It doesn't appear to be listed.
> >
> > Anyone have an idea of what's up with that?
> >
> > KenM|||Its actually on the very first screen with SQL Install
starts. The same one that says "Install SQL"
It is not in the "Add additional components" screen with
some other Checkboxed items.
>--Original Message--
>Hi, thanks for the reply., and
>Nope. That's the problem. I come to the screen that has
two boxes in it
>showing components and sub-components and no matter where
I click I can not
>find "Analysis Services" anywhere.
>I have an academic version of the msdn enterprise and am
installing it to
>get MS Project Services on a Win2003 server.
>Just can't seem to find it.
>Any help will be appreciated.
>Ken
>"Chandan DUtta" wrote:
>> Hi Ken,
>> Can you check "Analysis Services" item in the same
screen as "add
>> Additional Components" of the same sqlserver
installation cd?
>> Thanks,
>> Dutta
>>
>> "KenM" wrote:
>> > I'm trying to install Analysis Services, and we have
a full enterprise msdn
>> > set,
>> > but when I go to add additional components I can't
fine Analysis Services on
>> > the April 2004 cd available. It doesn't appear to be
listed.
>> >
>> > Anyone have an idea of what's up with that?
>> >
>> > KenM
>.
>