Best practise to provide non-DBAs querying capabilities in SQL200

When we used SQLServer 2000, we installed just query analyzer on desktops of
several of our IT folks so they could query data easily. Some of these folks
have admin priv for non-DBA reasons. Now that querying data is integrated
into the SQL 2005 management studio I am not sure the best way to provide
this function to these users. I don't want to give the full management
studio, especially to those with Admin but no appreciation for DBA tasks.
Any thoughts would be appreciated.
Thanks
--
FloraPerhaps QALite work against 2005?
http://rac4sql.net/qalite_main.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Flora Seymour" <FloraSeymour@.discussions.microsoft.com> wrote in message
news:66C0EC4F-ACDB-47DB-9417-5258409A9584@.microsoft.com...
> When we used SQLServer 2000, we installed just query analyzer on desktops of
> several of our IT folks so they could query data easily. Some of these folks
> have admin priv for non-DBA reasons. Now that querying data is integrated
> into the SQL 2005 management studio I am not sure the best way to provide
> this function to these users. I don't want to give the full management
> studio, especially to those with Admin but no appreciation for DBA tasks.
> Any thoughts would be appreciated.
> Thanks
> --
> Flora|||Thanks - I'd rather stay within the MS SQL Server2005 product if possible,
but QALite may do the trick if I that does not work out. The info I found
on it does not mention SQL2005 , just SQL2000, SQL Server7. Any experience
with QALite on SQL2005?
--
Flora
"Flora Seymour" wrote:
> When we used SQLServer 2000, we installed just query analyzer on desktops of
> several of our IT folks so they could query data easily. Some of these folks
> have admin priv for non-DBA reasons. Now that querying data is integrated
> into the SQL 2005 management studio I am not sure the best way to provide
> this function to these users. I don't want to give the full management
> studio, especially to those with Admin but no appreciation for DBA tasks.
> Any thoughts would be appreciated.
> Thanks
> --
> Flora|||I haven't used QALite myself, but since the Query Analyzer (2000 version) work against 2005 (almost
all things), I think there's a good chance that QALite does as well.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Flora Seymour" <FloraSeymour@.discussions.microsoft.com> wrote in message
news:7E6DFEA1-4E1A-407C-938A-07EDB894F066@.microsoft.com...
> Thanks - I'd rather stay within the MS SQL Server2005 product if possible,
> but QALite may do the trick if I that does not work out. The info I found
> on it does not mention SQL2005 , just SQL2000, SQL Server7. Any experience
> with QALite on SQL2005?
> --
> Flora
>
> "Flora Seymour" wrote:
>> When we used SQLServer 2000, we installed just query analyzer on desktops of
>> several of our IT folks so they could query data easily. Some of these folks
>> have admin priv for non-DBA reasons. Now that querying data is integrated
>> into the SQL 2005 management studio I am not sure the best way to provide
>> this function to these users. I don't want to give the full management
>> studio, especially to those with Admin but no appreciation for DBA tasks.
>> Any thoughts would be appreciated.
>> Thanks
>> --
>> Flora

Best practise to provide non-DBAs querying capabilities in SQL200

When we used SQLServer 2000, we installed just query analyzer on desktops of
several of our IT folks so they could query data easily. Some of these folks
have admin priv for non-DBA reasons. Now that querying data is integrated
into the SQL 2005 management studio I am not sure the best way to provide
this function to these users. I don't want to give the full management
studio, especially to those with Admin but no appreciation for DBA tasks.
Any thoughts would be appreciated.
Thanks
--
FloraPerhaps QALite work against 2005?
http://rac4sql.net/qalite_main.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Flora Seymour" <FloraSeymour@.discussions.microsoft.com> wrote in message
news:66C0EC4F-ACDB-47DB-9417-5258409A9584@.microsoft.com...
> When we used SQLServer 2000, we installed just query analyzer on desktops
of
> several of our IT folks so they could query data easily. Some of these fol
ks
> have admin priv for non-DBA reasons. Now that querying data is integrated
> into the SQL 2005 management studio I am not sure the best way to provide
> this function to these users. I don't want to give the full management
> studio, especially to those with Admin but no appreciation for DBA tasks.
> Any thoughts would be appreciated.
> Thanks
> --
> Flora|||Thanks - I'd rather stay within the MS SQL Server2005 product if possible,
but QALite may do the trick if I that does not work out. The info I found
on it does not mention SQL2005 , just SQL2000, SQL Server7. Any experience
with QALite on SQL2005?
Flora
"Flora Seymour" wrote:

> When we used SQLServer 2000, we installed just query analyzer on desktops
of
> several of our IT folks so they could query data easily. Some of these fol
ks
> have admin priv for non-DBA reasons. Now that querying data is integrated
> into the SQL 2005 management studio I am not sure the best way to provide
> this function to these users. I don't want to give the full management
> studio, especially to those with Admin but no appreciation for DBA tasks.
> Any thoughts would be appreciated.
> Thanks
> --
> Flora|||I haven't used QALite myself, but since the Query Analyzer (2000 version) wo
rk against 2005 (almost
all things), I think there's a good chance that QALite does as well.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Flora Seymour" <FloraSeymour@.discussions.microsoft.com> wrote in message
news:7E6DFEA1-4E1A-407C-938A-07EDB894F066@.microsoft.com...[vbcol=seagreen]
> Thanks - I'd rather stay within the MS SQL Server2005 product if possible
,
> but QALite may do the trick if I that does not work out. The info I fou
nd
> on it does not mention SQL2005 , just SQL2000, SQL Server7. Any experience
> with QALite on SQL2005?
> --
> Flora
>
> "Flora Seymour" wrote:
>

Best Practices: Should other (unrelated) applications be installed on a SQL server?

I was taught long ago that database servers should be database servers
and nothing more. I have been asked by my current employer to install
a new application on our SQL server because "we aren't using all of
it." In other words, they feel the server is under-utilized and want
to run other applications on it. I told them this was a bad idea and
that we should identify another server for the installation. That was
rejected and I've been challenged to "prove" that best practices are
to avoid loading unrelated applications on a database server.
Can anyone point me to a statement from Microsoft or some DB authority
that says as much? I have located dozens of bloggers who agree with
me but I can't really cite "CyberDawg420" as a reference when making
my argument. Any help at all is greatly appreciated!
You seem to be trying to "prove" common sense.
How about this. Don't share unless there is absolutely no choice.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
<jimguytrucker@.yahoo.com> wrote in message
news:1194452329.877280.250570@.v3g2000hsg.googlegro ups.com...
>I was taught long ago that database servers should be database servers
> and nothing more. I have been asked by my current employer to install
> a new application on our SQL server because "we aren't using all of
> it." In other words, they feel the server is under-utilized and want
> to run other applications on it. I told them this was a bad idea and
> that we should identify another server for the installation. That was
> rejected and I've been challenged to "prove" that best practices are
> to avoid loading unrelated applications on a database server.
> Can anyone point me to a statement from Microsoft or some DB authority
> that says as much? I have located dozens of bloggers who agree with
> me but I can't really cite "CyberDawg420" as a reference when making
> my argument. Any help at all is greatly appreciated!
>
|||On Nov 7, 10:38 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> You seem to be trying to "prove" common sense.
> How about this. Don't share unless there is absolutely no choice.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
> <jimguytruc...@.yahoo.com> wrote in message
> news:1194452329.877280.250570@.v3g2000hsg.googlegro ups.com...
>
>
> - Show quoted text -
You are spot on with the "common sense" comment. I'm frustrated
because it is obvious to me but they want "evidence." The only way to
PROVE I'm right is to do what they ask, slow down the SQL server, and
create numerous headaches. I would be willing to do this to make my
point but I'm the one who would have to clean up the aftermath.

Best Practices: Should other (unrelated) applications be installed on a SQL server?

I was taught long ago that database servers should be database servers
and nothing more. I have been asked by my current employer to install
a new application on our SQL server because "we aren't using all of
it." In other words, they feel the server is under-utilized and want
to run other applications on it. I told them this was a bad idea and
that we should identify another server for the installation. That was
rejected and I've been challenged to "prove" that best practices are
to avoid loading unrelated applications on a database server.
Can anyone point me to a statement from Microsoft or some DB authority
that says as much? I have located dozens of bloggers who agree with
me but I can't really cite "CyberDawg420" as a reference when making
my argument. Any help at all is greatly appreciated!You seem to be trying to "prove" common sense.
How about this. Don't share unless there is absolutely no choice.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
<jimguytrucker@.yahoo.com> wrote in message
news:1194452329.877280.250570@.v3g2000hsg.googlegroups.com...
>I was taught long ago that database servers should be database servers
> and nothing more. I have been asked by my current employer to install
> a new application on our SQL server because "we aren't using all of
> it." In other words, they feel the server is under-utilized and want
> to run other applications on it. I told them this was a bad idea and
> that we should identify another server for the installation. That was
> rejected and I've been challenged to "prove" that best practices are
> to avoid loading unrelated applications on a database server.
> Can anyone point me to a statement from Microsoft or some DB authority
> that says as much? I have located dozens of bloggers who agree with
> me but I can't really cite "CyberDawg420" as a reference when making
> my argument. Any help at all is greatly appreciated!
>|||On Nov 7, 10:38 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> You seem to be trying to "prove" common sense.
> How about this. Don't share unless there is absolutely no choice.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
> <jimguytruc...@.yahoo.com> wrote in message
> news:1194452329.877280.250570@.v3g2000hsg.googlegroups.com...
>
> >I was taught long ago that database servers should be database servers
> > and nothing more. I have been asked by my current employer to install
> > a new application on our SQL server because "we aren't using all of
> > it." In other words, they feel the server is under-utilized and want
> > to run other applications on it. I told them this was a bad idea and
> > that we should identify another server for the installation. That was
> > rejected and I've been challenged to "prove" that best practices are
> > to avoid loading unrelated applications on a database server.
> > Can anyone point me to a statement from Microsoft or some DB authority
> > that says as much? I have located dozens of bloggers who agree with
> > me but I can't really cite "CyberDawg420" as a reference when making
> > my argument. Any help at all is greatly appreciated!- Hide quoted text -
> - Show quoted text -
You are spot on with the "common sense" comment. I'm frustrated
because it is obvious to me but they want "evidence." The only way to
PROVE I'm right is to do what they ask, slow down the SQL server, and
create numerous headaches. I would be willing to do this to make my
point but I'm the one who would have to clean up the aftermath.

Best Practices: Should other (unrelated) applications be installed on a SQL server?

I was taught long ago that database servers should be database servers
and nothing more. I have been asked by my current employer to install
a new application on our SQL server because "we aren't using all of
it." In other words, they feel the server is under-utilized and want
to run other applications on it. I told them this was a bad idea and
that we should identify another server for the installation. That was
rejected and I've been challenged to "prove" that best practices are
to avoid loading unrelated applications on a database server.
Can anyone point me to a statement from Microsoft or some DB authority
that says as much? I have located dozens of bloggers who agree with
me but I can't really cite "CyberDawg420" as a reference when making
my argument. Any help at all is greatly appreciated!You seem to be trying to "prove" common sense.
How about this. Don't share unless there is absolutely no choice.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
<jimguytrucker@.yahoo.com> wrote in message
news:1194452329.877280.250570@.v3g2000hsg.googlegroups.com...
>I was taught long ago that database servers should be database servers
> and nothing more. I have been asked by my current employer to install
> a new application on our SQL server because "we aren't using all of
> it." In other words, they feel the server is under-utilized and want
> to run other applications on it. I told them this was a bad idea and
> that we should identify another server for the installation. That was
> rejected and I've been challenged to "prove" that best practices are
> to avoid loading unrelated applications on a database server.
> Can anyone point me to a statement from Microsoft or some DB authority
> that says as much? I have located dozens of bloggers who agree with
> me but I can't really cite "CyberDawg420" as a reference when making
> my argument. Any help at all is greatly appreciated!
>sql

Best practices for an installation of SQL Server 2000 Reporting Se

Hi,
Where would one install SQL Service 2000 Reporting Services? I though about
installing them on a Web Server (with NO local SQL Server installed on) and
connection remote to a SQL Server 2000. Does this approach make sense?
I donâ't have a good feeling installing the Web Services on a Database Server
where I have to install IIS and the .NET Framework as well.
Best regards,
DanielThis will work fine. One point to keep in mind is that you have to have a
SQL Server license on the box with RS.
What I do is have SQL Server just for RS on the box. The data the reports
are based on reside on a different box. My feeling is why not have SQL
Server for the object caching that RS uses it for be on the same box. I have
to pay for it anyway.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
> Hi,
> Where would one install SQL Service 2000 Reporting Services? I though
> about
> installing them on a Web Server (with NO local SQL Server installed on)
> and
> connection remote to a SQL Server 2000. Does this approach make sense?
> I don't have a good feeling installing the Web Services on a Database
> Server
> where I have to install IIS and the .NET Framework as well.
> Best regards,
> Daniel|||Bruce,
Thanks for your answer! Just to make sure I got your point. You suggest to
have both (SQL Server and RS) installed on the same computer? Am I also right
that this constellation would only require on SQL Server license?
And one more question: Can RS be installed on a computer with NO SQL Server
installed? I had some troulbe installing RS on my Web Server where on SQL
Server is installed on. The installation skipped the part where I am supposed
to select the SQL Server but told me all is fine :-( This problem though
could have been caused by the Terminal Services which I had not disabled
(Will try tomorrow).
Thanks!
Daniel
"Bruce L-C [MVP]" wrote:
> This will work fine. One point to keep in mind is that you have to have a
> SQL Server license on the box with RS.
> What I do is have SQL Server just for RS on the box. The data the reports
> are based on reside on a different box. My feeling is why not have SQL
> Server for the object caching that RS uses it for be on the same box. I have
> to pay for it anyway.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
> > Hi,
> >
> > Where would one install SQL Service 2000 Reporting Services? I though
> > about
> > installing them on a Web Server (with NO local SQL Server installed on)
> > and
> > connection remote to a SQL Server 2000. Does this approach make sense?
> >
> > I don't have a good feeling installing the Web Services on a Database
> > Server
> > where I have to install IIS and the .NET Framework as well.
> >
> > Best regards,
> >
> > Daniel
>
>|||From a licensing perspective there is no difference. You have to have a SQL
Server license for the box that has Reporting Services. Reporting Services
uses SQL Server for it's object storage. For instance, all reports are
stored in the database. You will not see any rdl files on the server. It
uses SQL Server for other objects as well. So, RS has to have SQL Server
somewhere. If you use a SQL Server that is somewhere other than the box you
are installing RS on you have to use the command line install and specify
where SQL Server can be found. I have not done this myself. I assume the
info on how to do this is in the readme. If you use the setup program it
plans that SQL Server is on the box you are installing RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:E02F3FE4-EDD4-4A35-AD4D-D772A811424A@.microsoft.com...
> Bruce,
> Thanks for your answer! Just to make sure I got your point. You suggest to
> have both (SQL Server and RS) installed on the same computer? Am I also
> right
> that this constellation would only require on SQL Server license?
> And one more question: Can RS be installed on a computer with NO SQL
> Server
> installed? I had some troulbe installing RS on my Web Server where on SQL
> Server is installed on. The installation skipped the part where I am
> supposed
> to select the SQL Server but told me all is fine :-( This problem though
> could have been caused by the Terminal Services which I had not disabled
> (Will try tomorrow).
> Thanks!
> Daniel
>
> "Bruce L-C [MVP]" wrote:
>> This will work fine. One point to keep in mind is that you have to have a
>> SQL Server license on the box with RS.
>> What I do is have SQL Server just for RS on the box. The data the reports
>> are based on reside on a different box. My feeling is why not have SQL
>> Server for the object caching that RS uses it for be on the same box. I
>> have
>> to pay for it anyway.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
>> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
>> > Hi,
>> >
>> > Where would one install SQL Service 2000 Reporting Services? I though
>> > about
>> > installing them on a Web Server (with NO local SQL Server installed on)
>> > and
>> > connection remote to a SQL Server 2000. Does this approach make sense?
>> >
>> > I don't have a good feeling installing the Web Services on a Database
>> > Server
>> > where I have to install IIS and the .NET Framework as well.
>> >
>> > Best regards,
>> >
>> > Daniel
>>|||Thank you Bruce,
this is good to know!
Daniel
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:%238AtkHJYFHA.2796@.TK2MSFTNGP09.phx.gbl...
> From a licensing perspective there is no difference. You have to have a
> SQL Server license for the box that has Reporting Services. Reporting
> Services uses SQL Server for it's object storage. For instance, all
> reports are stored in the database. You will not see any rdl files on the
> server. It uses SQL Server for other objects as well. So, RS has to have
> SQL Server somewhere. If you use a SQL Server that is somewhere other than
> the box you are installing RS on you have to use the command line install
> and specify where SQL Server can be found. I have not done this myself. I
> assume the info on how to do this is in the readme. If you use the setup
> program it plans that SQL Server is on the box you are installing RS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:E02F3FE4-EDD4-4A35-AD4D-D772A811424A@.microsoft.com...
>> Bruce,
>> Thanks for your answer! Just to make sure I got your point. You suggest
>> to
>> have both (SQL Server and RS) installed on the same computer? Am I also
>> right
>> that this constellation would only require on SQL Server license?
>> And one more question: Can RS be installed on a computer with NO SQL
>> Server
>> installed? I had some troulbe installing RS on my Web Server where on SQL
>> Server is installed on. The installation skipped the part where I am
>> supposed
>> to select the SQL Server but told me all is fine :-( This problem though
>> could have been caused by the Terminal Services which I had not disabled
>> (Will try tomorrow).
>> Thanks!
>> Daniel
>>
>> "Bruce L-C [MVP]" wrote:
>> This will work fine. One point to keep in mind is that you have to have
>> a
>> SQL Server license on the box with RS.
>> What I do is have SQL Server just for RS on the box. The data the
>> reports
>> are based on reside on a different box. My feeling is why not have SQL
>> Server for the object caching that RS uses it for be on the same box. I
>> have
>> to pay for it anyway.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in
>> message
>> news:A0462F4B-9A38-4B88-B2DB-C42B6514EF8B@.microsoft.com...
>> > Hi,
>> >
>> > Where would one install SQL Service 2000 Reporting Services? I though
>> > about
>> > installing them on a Web Server (with NO local SQL Server installed
>> > on)
>> > and
>> > connection remote to a SQL Server 2000. Does this approach make sense?
>> >
>> > I don't have a good feeling installing the Web Services on a Database
>> > Server
>> > where I have to install IIS and the .NET Framework as well.
>> >
>> > Best regards,
>> >
>> > Daniel
>>
>|||" If you use a SQL Server that is somewhere other than the box you
are installing RS on you have to use the command line install and specify
where SQL Server can be found."-Bruce
Are you absolutely 100% certain this is the case?
I'm certainly stuck trying to install enterprise RS on the web server
pointing to a SQL server DB on another sql server(2000). Problem is the
install ends "successfully" but then throws an activivation error. No
resolution for this error in sight.
However if I MUST use the commend line too to configure RS across servers
this may explain the activiation error. I don't remember finding anything
documented telling me I must use this command line approach.
Please verify this is true. Thanks! Could save a lot of headaches...

Best Practices Analyzer

Before hand, I Apologize if I am posting this on a wrong group.
I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
is installed. The installation went fine. I created a report by connecting to
a server. Now, I want to print the report but I can't.
The document "MSBPA_User_Guide.doc" that comes with it says that I should be
able to print report by clicking on the "print report" icon on "Compliance
Reports" page but THERE IS NO "PRINT REPORT" icon.
Am I dreaming ? or what document says really doesn't match what the software
does ? or is this a limitation on Windows XP ?
Thanks for any help.Hi DXC:
you should have just four choices on the report form:
[Remove Report], [Copy Report], [Previous Report] and [Next Report].
To print a report you should use the [Copy] option and then paste it ona a
Word document or on any other editor you like.
This action let you generate a document containig the reèportsummary. to
Print the details you should copy any of them (or just the details you are
interested for) one at a time.
"DXC" wrote:
> Before hand, I Apologize if I am posting this on a wrong group.
> I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
> is installed. The installation went fine. I created a report by connecting to
> a server. Now, I want to print the report but I can't.
> The document "MSBPA_User_Guide.doc" that comes with it says that I should be
> able to print report by clicking on the "print report" icon on "Compliance
> Reports" page but THERE IS NO "PRINT REPORT" icon.
> Am I dreaming ? or what document says really doesn't match what the software
> does ? or is this a limitation on Windows XP ?
> Thanks for any help.|||Thanks Gilberto.........I wanted to print details also but If I have to
print one by one then I will not print.........Is it any better if I use
the "SQL Server Reporting Services" ?
Thanks again.
"Gilberto Zampatti" wrote:
> Hi DXC:
> you should have just four choices on the report form:
> [Remove Report], [Copy Report], [Previous Report] and [Next Report].
> To print a report you should use the [Copy] option and then paste it ona a
> Word document or on any other editor you like.
> This action let you generate a document containig the reèportsummary. to
> Print the details you should copy any of them (or just the details you are
> interested for) one at a time.
> "DXC" wrote:
> > Before hand, I Apologize if I am posting this on a wrong group.
> >
> > I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> >
> > on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
> > is installed. The installation went fine. I created a report by connecting to
> > a server. Now, I want to print the report but I can't.
> >
> > The document "MSBPA_User_Guide.doc" that comes with it says that I should be
> > able to print report by clicking on the "print report" icon on "Compliance
> > Reports" page but THERE IS NO "PRINT REPORT" icon.
> >
> > Am I dreaming ? or what document says really doesn't match what the software
> > does ? or is this a limitation on Windows XP ?
> >
> > Thanks for any help.|||To use Reporting services you need to save the report details in a compliant
data source: anyway you have to peek each detail you are interested to.
Surely you can obtain a much better result in terms of presentation and
usability.
"DXC" wrote:
> Thanks Gilberto.........I wanted to print details also but If I have to
> print one by one then I will not print.........Is it any better if I use
> the "SQL Server Reporting Services" ?
> Thanks again.
> "Gilberto Zampatti" wrote:
> > Hi DXC:
> > you should have just four choices on the report form:
> > [Remove Report], [Copy Report], [Previous Report] and [Next Report].
> > To print a report you should use the [Copy] option and then paste it ona a
> > Word document or on any other editor you like.
> > This action let you generate a document containig the reèportsummary. to
> > Print the details you should copy any of them (or just the details you are
> > interested for) one at a time.
> >
> > "DXC" wrote:
> >
> > > Before hand, I Apologize if I am posting this on a wrong group.
> > >
> > > I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
> > >
> > > http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> > >
> > > on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
> > > is installed. The installation went fine. I created a report by connecting to
> > > a server. Now, I want to print the report but I can't.
> > >
> > > The document "MSBPA_User_Guide.doc" that comes with it says that I should be
> > > able to print report by clicking on the "print report" icon on "Compliance
> > > Reports" page but THERE IS NO "PRINT REPORT" icon.
> > >
> > > Am I dreaming ? or what document says really doesn't match what the software
> > > does ? or is this a limitation on Windows XP ?
> > >
> > > Thanks for any help.

Best Practices Analyzer

Before hand, I Apologize if I am posting this on a wrong group.
I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
is installed. The installation went fine. I created a report by connecting to
a server. Now, I want to print the report but I can't.
The document "MSBPA_User_Guide.doc" that comes with it says that I should be
able to print report by clicking on the "print report" icon on "Compliance
Reports" page but THERE IS NO "PRINT REPORT" icon.
Am I dreaming ? or what document says really doesn't match what the software
does ? or is this a limitation on Windows XP ?
Thanks for any help.
Hi DXC:
you should have just four choices on the report form:
[Remove Report], [Copy Report], [Previous Report] and [Next Report].
To print a report you should use the [Copy] option and then paste it ona a
Word document or on any other editor you like.
This action let you generate a document containig the reèportsummary. to
Print the details you should copy any of them (or just the details you are
interested for) one at a time.
"DXC" wrote:

> Before hand, I Apologize if I am posting this on a wrong group.
> I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
> on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
> is installed. The installation went fine. I created a report by connecting to
> a server. Now, I want to print the report but I can't.
> The document "MSBPA_User_Guide.doc" that comes with it says that I should be
> able to print report by clicking on the "print report" icon on "Compliance
> Reports" page but THERE IS NO "PRINT REPORT" icon.
> Am I dreaming ? or what document says really doesn't match what the software
> does ? or is this a limitation on Windows XP ?
> Thanks for any help.
|||Thanks Gilberto.........I wanted to print details also but If I have to
print one by one then I will not print.........Is it any better if I use
the "SQL Server Reporting Services" ?
Thanks again.
"Gilberto Zampatti" wrote:
[vbcol=seagreen]
> Hi DXC:
> you should have just four choices on the report form:
> [Remove Report], [Copy Report], [Previous Report] and [Next Report].
> To print a report you should use the [Copy] option and then paste it ona a
> Word document or on any other editor you like.
> This action let you generate a document containig the reèportsummary. to
> Print the details you should copy any of them (or just the details you are
> interested for) one at a time.
> "DXC" wrote:
|||To use Reporting services you need to save the report details in a compliant
data source: anyway you have to peek each detail you are interested to.
Surely you can obtain a much better result in terms of presentation and
usability.
"DXC" wrote:
[vbcol=seagreen]
> Thanks Gilberto.........I wanted to print details also but If I have to
> print one by one then I will not print.........Is it any better if I use
> the "SQL Server Reporting Services" ?
> Thanks again.
> "Gilberto Zampatti" wrote:
sql

Best Practices Analyzer

Before hand, I Apologize if I am posting this on a wrong group.
I have downloaded and installed "SQL Server 2000 Best Practices Analyzer" fr
om
http://www.microsoft.com/downloads/...&displaylang=en
on to my Windows XP machine where I have "SQL Server 2000 Personal addition"
is installed. The installation went fine. I created a report by connecting t
o
a server. Now, I want to print the report but I can't.
The document "MSBPA_User_Guide.doc" that comes with it says that I should be
able to print report by clicking on the "print report" icon on "Compliance
Reports" page but THERE IS NO "PRINT REPORT" icon.
Am I dreaming ? or what document says really doesn't match what the software
does ? or is this a limitation on Windows XP ?
Thanks for any help.Hi DXC:
you should have just four choices on the report form:
[Remove Report], [Copy Report], [Previous Report] and [Next
Report].
To print a report you should use the [Copy] option and then paste it ona
a
Word document or on any other editor you like.
This action let you generate a document containig the reèportsummary. to
Print the details you should copy any of them (or just the details you are
interested for) one at a time.
"DXC" wrote:

> Before hand, I Apologize if I am posting this on a wrong group.
> I have downloaded and installed "SQL Server 2000 Best Practices Analyzer"
from
> http://www.microsoft.com/downloads/...&displaylang=en
> on to my Windows XP machine where I have "SQL Server 2000 Personal additio
n"
> is installed. The installation went fine. I created a report by connecting
to
> a server. Now, I want to print the report but I can't.
> The document "MSBPA_User_Guide.doc" that comes with it says that I should
be
> able to print report by clicking on the "print report" icon on "Compliance
> Reports" page but THERE IS NO "PRINT REPORT" icon.
> Am I dreaming ? or what document says really doesn't match what the softwa
re
> does ? or is this a limitation on Windows XP ?
> Thanks for any help.|||Thanks Gilberto.........I wanted to print details also but If I have to
print one by one then I will not print.........Is it any better if I use
the "SQL Server Reporting Services" ?
Thanks again.
"Gilberto Zampatti" wrote:
[vbcol=seagreen]
> Hi DXC:
> you should have just four choices on the report form:
> [Remove Report], [Copy Report], [Previous Report] and [Nex
t Report].
> To print a report you should use the [Copy] option and then paste it o
na a
> Word document or on any other editor you like.
> This action let you generate a document containig the reèportsummary. to
> Print the details you should copy any of them (or just the details you are
> interested for) one at a time.
> "DXC" wrote:
>|||To use Reporting services you need to save the report details in a compliant
data source: anyway you have to peek each detail you are interested to.
Surely you can obtain a much better result in terms of presentation and
usability.
"DXC" wrote:
[vbcol=seagreen]
> Thanks Gilberto.........I wanted to print details also but If I have to
> print one by one then I will not print.........Is it any better if I us
e
> the "SQL Server Reporting Services" ?
> Thanks again.
> "Gilberto Zampatti" wrote:
>

Best practice question

I have a aspx page that needs data from sqlexpress. When I installed sqlexpress, I installed it with "mixed-mode" security. When a user visit's my page, by default the username is IUSR_MyMachine. So, I added this user to the SQLServer2005MSSSQLUSers$MyMachine$SQLEXPRESS group. I have a connection string that looks like:

"Data Source=MyServer\sqlexpress;Initial Catalog=MyDB;Integrated Security=True;Pooling=True"

At this point I can go on my merry way and log in and do my thing. My question is this, is this the right way to do this? Should I be adding IUSR to the sql group? Should I set up a sql user instead? What's the best practice for connecting to a db from an aspx page?

Any insight would be great.
Thanks ... Ed

This is a repost. I never got a response the first time.

I'm pretty sure that you made a major error just then. By adding the IUSR account to that group, you gave anonymous visitors full database admin rights. I *think* you want to set up a limited account, and grant it specific rights on specific databases or tables w/in databases. I'm poking around myself to figure out how to do it right (which brought me here), but I think your solution is like making everybody domain admin. Sure, everything works that way :), but some things you don't want to "work" for some users.|||In general the most secure way to configure this is to create a new local user called SQLReader. Then configure this local user inside SQL Server to only allow login to your specfic database, granting the user read-only access. This keeps the access very restricted. Then map the aspx page to the SQLReader account.

Of course I am leaving out all the gory details of mapping a specific aspx page to a specific user, this can be bloody difficult. One way to do it is to create a .NET component hosted in COM+ and set the COM+ package to run as a specific user (having the aspx page make calls to the component). You can also twiggle around with the web.config file in aspx to do this mapping.

However, since you already have all your desired users mapped to IUSR_MyMachine by default, then you can just skip the SQLReader part, just add IUSR_MyMachine as login to only the MyDB database and only grant read access and you are set. This is assuming you are ok for any user that hits your web site to read from the SQL database.|||Thanks for the response. You've given me a lot to think about. I appreciate the thoughtful comments.
Later ... Ed

best practice analyzer "copy report" but no "print report" -more info

I reinstalled the software and I also installed the software on another machine. The problem still exists. One machine is W2K sever sp4 and the other is XP Pro sp1
Unfortunately it is a documentation bug. Print functionality was removed
from BPA (available in the beta) but was missed from the documentation. :-(
The two possible ways to achieve print are:
1) use "copy". After clicking on it you should be able to paste in a variety
of formats, word, excel, etc.
2) use SQL Server Reporting Services. This also has many formats (pdf,
excel, html) you can use to generate & print reports.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:7AE5FBD7-3C64-4AB5-B20D-60316BF9F10D@.microsoft.com...
> I reinstalled the software and I also installed the software on another
machine. The problem still exists. One machine is W2K sever sp4 and the
other is XP Pro sp1

Best Practice Analyzer

I just installed the product, and noticed in the instructions to print it states go to
compliance reports, view reports, and click the print reports button.
I only have a "Copy Report" "Remove Report" "Previous Report" "Next Report" button.
Build:1.0.59.0
Hi Robert
It is a doc bug. :-( Sorry about it. You'll have to copy from BPA and paste
into word/excel/etc to print or use reporting services to generate reports
which can also be exported to multiple formats - and print of course.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Salazar" <Robert Salazar@.discussions.microsoft.com> wrote in message
news:5575B090-38F2-453D-AD3B-F4EB9294C5FC@.microsoft.com...
> I just installed the product, and noticed in the instructions to print it
states go to
> compliance reports, view reports, and click the print reports button.
> I only have a "Copy Report" "Remove Report" "Previous Report" "Next
Report" button.
>
> Build:1.0.59.0
>
|||Do I have to install MS Reporting Services on a IIs machine? Is there a way to install on it on my local PC and use the report options with the BPA.
Thanks
"Christian Kleinerman [MS]" wrote:

> Hi Robert
> It is a doc bug. :-( Sorry about it. You'll have to copy from BPA and paste
> into word/excel/etc to print or use reporting services to generate reports
> which can also be exported to multiple formats - and print of course.
> - Christian
> --
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Robert Salazar" <Robert Salazar@.discussions.microsoft.com> wrote in message
> news:5575B090-38F2-453D-AD3B-F4EB9294C5FC@.microsoft.com...
> states go to
> Report" button.
>
>
|||You do need to install Reporting Services (RS). You could use a server with
IIS or your local PC (which likely has IIS too). The question becomes more
of a licensing issue. You can install RS free of charge in the same machine
where you have your SQL Server. In a different machine, I believe it
requires a new license.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"robert_at_cbb" <robertatcbb@.discussions.microsoft.com> wrote in message
news:413B4B6F-2EA1-4DE5-AD6E-AE100EF294F3@.microsoft.com...
> Do I have to install MS Reporting Services on a IIs machine? Is there a
way to install on it on my local PC and use the report options with the BPA.[vbcol=seagreen]
> Thanks
> "Christian Kleinerman [MS]" wrote:
paste[vbcol=seagreen]
reports[vbcol=seagreen]
rights.[vbcol=seagreen]
message[vbcol=seagreen]
it[vbcol=seagreen]

Best Practice Analyzer

I recently installed & ran the best practice analyzer on all of our
production SQL Servers. The only report we ended up being compliant with was
the full-text which we don't use. There are so many different standards that
this tool is looking for. Are there any that are more important than others
that you really should pay attention to? I can see the benefits of some of
the suggestions but how much difference is there really between using a
insert into table without specifying the columns and using insert into table
with the columns listed out? I understand that some of these standards are
for maintainability of code but are they all really worth the effort of going
through several hundred SPs? I am just trying to get a handle of how to
realistically use this tool. Any input on how others have used this tool in
their DBA roles would be appreciated!
Thanks!
John
there are quite a few that are pretty darn important.
the one you mention is for maintainability purposes only
if you failed every area, I would guess that you may have some serious
issues.
I thought the tool listed a severity level...It's been over a year since
I've used it on our prod DB's
Greg Jackson
PDX, Oregon
|||Greg,
We didn't fail every other one. We just always had maybe one that didn't
pass in a certain area. We only were fully compliant on the full-text. I
didn't see a severity level but I will have to look at it again.
John
"pdxJaxon" wrote:

> there are quite a few that are pretty darn important.
> the one you mention is for maintainability purposes only
> if you failed every area, I would guess that you may have some serious
> issues.
> I thought the tool listed a severity level...It's been over a year since
> I've used it on our prod DB's
>
>
> Greg Jackson
> PDX, Oregon
>
>
|||Anything security or recovery related would be first and foremost on my
list...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"John D." <John D.@.discussions.microsoft.com> wrote in message
news:2942010E-7A6D-46EC-B05D-64913D957782@.microsoft.com...
>I recently installed & ran the best practice analyzer on all of our
> production SQL Servers. The only report we ended up being compliant with
> was
> the full-text which we don't use. There are so many different standards
> that
> this tool is looking for. Are there any that are more important than
> others
> that you really should pay attention to? I can see the benefits of some
> of
> the suggestions but how much difference is there really between using a
> insert into table without specifying the columns and using insert into
> table
> with the columns listed out? I understand that some of these standards
> are
> for maintainability of code but are they all really worth the effort of
> going
> through several hundred SPs? I am just trying to get a handle of how to
> realistically use this tool. Any input on how others have used this tool
> in
> their DBA roles would be appreciated!
> Thanks!
> John
|||How important are the ANSI compliant settings? Most of them on our databases
were turned to off but the BPA suggested they be turned on. I looked them up
in BOL and don't see why they couldn't be turned on but I don't know if there
is enough to make the change. Part of me wonders if something is going to
blow up if I turn them on. Anybody have any experience with this?
John

Best practice analyser tool installation

I installed a sql server best practice analyser tool on
our new windows 2003 server.
I log in as my own username which is a system
admininstrator.
After installation, I found the program is only available
by logging using my own username, if login using other
admin username or other username, I cannot see the program.
Even when I move the shortcut to all users, it gives
message:
This action is only available to currently installed
program
And during installation, it didn't ask to intall for all
users or current users.
How can I make the program available to all users?
Thanks
I think this should work. Try the following from the other (non-setup)
accounts.
regasm.exe $(O)\bpacommon.dll /tlb
regasm.exe $(O)\bpaclient.dll /tlb
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Best practise analyser" <anonymous@.discussions.microsoft.com> wrote in
message news:0a8b01c4903a$462f62b0$a401280a@.phx.gbl...
> I installed a sql server best practice analyser tool on
> our new windows 2003 server.
> I log in as my own username which is a system
> admininstrator.
> After installation, I found the program is only available
> by logging using my own username, if login using other
> admin username or other username, I cannot see the program.
> Even when I move the shortcut to all users, it gives
> message:
> This action is only available to currently installed
> program
> And during installation, it didn't ask to intall for all
> users or current users.
> How can I make the program available to all users?
> Thanks

Best practice advice please

I'm looking for advice on the best way to stop stored procedures and CLR assemblies from being

copied from their originally installed server to a different server, for the same company or even copied

to another company.

Are there established ways for achieving this level of protection.

Also, I was hoping that encrypting stored procedures would be a 100% reliable way to stop

malicious copying of the code. But I have read that this is not the case. Any advice in this

area would also be appreciated.

Thanks

Steve

Procedure encryption, like the locks on the doors to your home/abode, are only designed to keep out the 'merely curious' -not those determined to be inside.

It is very difficult to prevent a dba (sysadmin) from accessing the code from stored procedures and assemblies. Easily obtainable 'decryption' tools will allow you to see the the code in unencrypted form -even if the code is from an obfuscated assembly (SQL 2005).

Best Practice is to control who has sysadmin access to the servers, all other users have finely 'tumed' permissions, and have a well crafted 'acceptable use' policy in place.

|||

Thanks Arnie.

In my using of Profiler, I could not see the code for encrypted SPs, so I am surprised to hear that the code from an obfuscated assembly can be seen.

Any how, I'll have to think some more.

Thank you

Steve

|||Well the assembly itself cannot be seen and the statements neither, it will only by the following visible in Profiler:

-- Encrypted text

But in addition to Arnie, the "encryption" in SQL Server 2005 is weak and not build for hiding the procedure code in a secure manner. It is just to add an additional barrier to prevent the users to easily read the procedure code. it is doable to read the code but needs additional knowledge about decryption of the procedure code (or even just a good experience to handle the google search :-) )

Jens K. Suessmeyer

http://www.sqlserver2005.de

Best Possible Solution

Hi folks, guidance required!
Clients have an MSDE installed and they need all of their data to be dowloaded for the first time from our website. 30 tables r involved.
Can i automate this? I suspect BCP allows only one table to be exported into a text file. Since it's the first time process i don't want to setup replication.

Howdy!What do you mean downloaded from you website?|||Hi, sir.
An offline scheduler type application that could be downloaded from our website. All the data of the clients is at the db server running our website. Now for the first time when the log on to the app they could be offered the facility to download all their data locally from the db. I suspect there could b a better way around to give the data to each provider in an automated way rather than selecting the data for each client; creating a database for each client and shipping it manually with the software.

Howdy!

beginning SQL

I purchased SQL Server 2005 and intend to take a class this month. I have installed it. How do I get started trying it out? I took an online tutorial, but I don't understand the mechanics of accessing the db to start with or if I even have a db to work with. Any suggestions?

Book on line > SQL Server 2005 Tutorials >SQL Server Tools Tutorial

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/655e709b-346b-469c-bddc-a5a0238d07e0.htm

HTH

Beginner's question

I just installed SQL Server 2005, Office 2007, and the add-in, but when I check services.msc, I don't see the SQL Server Analysis Services. Does anyone know how I can get this to load? Also, when I run the server configuration utility in the DM add-in folder, do you know what I should put in the server name to get it to run off my hard disk and not a server? local host doesn't seem to work. Thanks in advance!

Which edition of SQL Server 2005 did you install? If you installed the express edition, Analysis Services is not included in that edition. To access Data Mining features, you can install an eval edition of SQL Server 2005 from http://technet.microsoft.com/en-us/sqlserver/bb462637.aspx

The DM Addins needs Analysis Server to run and cannot run off a local file from your hard drive. You'll need Analysis Server installed to use the addins from Office.

|||I have the evaluation version, but don't know how to set it up to have my hard drive as the server. Do you know how I can get the SQL analysis services to run so that it will appear in services.msc?
|||While installing the evaluation edition, did you select Analysis Services as as installation option? You can go to Add/Remove Programs, find Microsoft SQL Server 2005, select Modify and check the list of products installed. Analysis Services should be one of the options.|||Thanks a lot for you help. If I had 50 products and 60,000 different customers with different assortments of products per customers (basket), do you know how microsoft's associate function can help determine the association rules that have the highest probability of occurring? Thanks again.
|||Are you referring to the PredictAssociation function? Or just how to setup the mining model to do a market-basket analysis?|||Market-basket analysis would be great. Is there any way to get it to give the probabilities of Product C given that Product A and B are also sold, or will it just be able to do the probability of product B given that A is sold? Thanks
|||

It does both. The Association Rules algorithm uses all rules that "fire" for the input set. For example if you had rules such as

A->C

A,B->C

A,D->C

and you had A,B, and D in your input, all three rules would "fire". The resultant probability is based on the probability of the rules, and may not match any one in particular.

|||So would I just select the 50,000 clients and 50 products and then run the associate function? Do you know how long it would take for the associate or clustering feature to run with this amount of data on a local hard drive?
|||

The amount of time to perform such an operation is not long. However, reading your original question - "the association rules with the highest probability of occurring", the answer is simply those rules whose LHS itemsets have the highest support. Take for example you have rules

A -> C

A,B -> D

A,B -> C

A, B, C -> E

Say you have 50,000 cases and you have support(A)=5,000, support (A,B) = 2,000, support(A,B,C) = 1000.

The probability given any input case of each rule firing would then be

10% A->C

4% A,B->D

4% A,B->C

2% A,B,C->E

beginner: "Login failed for user sa."

Hello,
(sorry for my English...)
Could you help me with a SQL Server 2005 problem?
I had installed SQL Server 2005 and then I tried to setup some application
using SQL Server. Unfortunatelly setup fails because the application cannot
logon to SQL Server in SQL Server Authentication mode (user 'sa', password
'sa'). I checked Server Management Studio Express: I have sa/sa account
(because I've prepared it), but although I can logon in Windows
Authentication mode, I cannot logon in SQL Server Authentication (sa/sa)
because of:

Login failed for user 'sa'. The user is not associated with a trusted SQL
Server connection (Microsoft SQL Server, Error: 18452).

Could you help me plase? I suspect that solution is simple but my experience
is not enough.
Thank you very much.
/RAMtake a look here
http://sqlservercode.blogspot.com/2...reason-not.html|||Andrzej Magdziarz (andrzej.magdziarz@.wp.pl) writes:
> Could you help me with a SQL Server 2005 problem? I had installed SQL
> Server 2005 and then I tried to setup some application using SQL Server.
> Unfortunatelly setup fails because the application cannot logon to SQL
> Server in SQL Server Authentication mode (user 'sa', password 'sa').

That is not a very good password. :-)

> I checked Server Management Studio Express: I have sa/sa account
> (because I've prepared it), but although I can logon in Windows
> Authentication mode, I cannot logon in SQL Server Authentication (sa/sa)
> because of:
> Login failed for user 'sa'. The user is not associated with a trusted SQL
> Server connection (Microsoft SQL Server, Error: 18452).
> Could you help me plase? I suspect that solution is simple but my
> experience is not enough.

By default, SQL Server accepts only logins through Windows authentication,
and you must explicitly permit SQL authentication. Your first chance
to so is during setup, but you can also do this from Mgmt Studio.
Right-click the server itself in the Object Explorer, select Properies
and then find the Security page.

--
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

beginner in MSDE

Hello
Two questions:
I have installed the MSDE included on the Visual Studio NET, I use the tools in Visual to create data bases, but what other interface can I use to create MSDE data bases if I don't have SQL Server neither access ?
I create a view in a database with the following command:
SELECT ind_emp, lastName + firstName AS name FROM employee
when I try to run the view I received a message that says "operator ADD is not valid to use with texts champs" Why is that?
Thanks a lot
hi Carmen,
"Carmen" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:D15E830D-7C49-46D8-8F27-E737000A399E@.microsoft.com...
> Hello
> Two questions:
> I have installed the MSDE included on the Visual Studio NET, I use the
tools in Visual to create data bases, but what other interface can I use to
create MSDE data bases if I don't have SQL Server neither access ?
> I create a view in a database with the following command:
> SELECT ind_emp, lastName + firstName AS name FROM employee
> when I try to run the view I received a message that says "operator ADD is
not valid to use with texts champs" Why is that?
> Thanks a lot
>
in order to manage MSDE instance in a visual way, you can have a look at a
free prj of mine, available at the link following my sign.m which provides a
user interface similar to Enterprise Manager..
further tools are listed at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442
as regard your second question, you can not concatenate text and blob
columns like that..
anyway, you probably have to change the datatype for your lastName +
firstName columns to VARCHAR datatype..
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply