How do I administer SqlServer 2005

Hi;
I just installed SqlServer 2005 developer edition and I can't find any way
to administer it. There is a "Sql Server Configuration Manager" in the menu
but nothing like the Enterprise Manager in SqlServer 2000.
What am I missing?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
You are missing SQL Server Management Studio.
You may need to put in the disk again, and select INSTALL Client Tools.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:CA288C02-B0C8-4F6E-A075-BB6AE535BCCF@.microsoft.com...
> Hi;
> I just installed SqlServer 2005 developer edition and I can't find any way
> to administer it. There is a "Sql Server Configuration Manager" in the
> menu
> but nothing like the Enterprise Manager in SqlServer 2000.
> What am I missing?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
>
|||that was it.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Arnie Rowland" wrote:

> You are missing SQL Server Management Studio.
> You may need to put in the disk again, and select INSTALL Client Tools.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "David Thielen" <thielen@.nospam.nospam> wrote in message
> news:CA288C02-B0C8-4F6E-A075-BB6AE535BCCF@.microsoft.com...
>
>
|||Thanks Dave -and I enjoyed 'Cubicle Wars'. Nice.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:BD10F348-D97E-4B53-9D16-9EE9DEE054EE@.microsoft.com...[vbcol=seagreen]
> that was it.
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
>
>
> "Arnie Rowland" wrote:
|||Hi David
You may install the client tools, then you'll get SQL Server Management
Studio.
If you need a web-based solution, then you can try myLittleAdmin for SQL
Server 2005
http://www.mylittleadmin.com
Best regards
David Thielen wrote:
> Hi;
> I just installed SqlServer 2005 developer edition and I can't find
> any way to administer it. There is a "Sql Server Configuration
> Manager" in the menu but nothing like the Enterprise Manager in
> SqlServer 2000.
> What am I missing?
I'm protected by SpamBrave
http://www.spambrave.com/

How do I adjust the tab settings in SQL Server Enterprise Manager.

I found how to adjust the tab settings when editing a stored procedure using
Query Analyzer, but I don't see any way to adjust the tab settings when
editing a stored procedure using SQL Server Enterprise Manager.
Does anyone know how to do this?
Thanks,
VernThere isn't. That dialog is only really appropriate for viewing the code or
copying it. You should use Query Analyzer to edit and will find the task is
much easier and cleaner.
Andrew J. Kelly SQL MVP
"Vern" <Vern@.discussions.microsoft.com> wrote in message
news:DF5D3DF0-B5EE-49C9-9816-F124D350F4F8@.microsoft.com...
>I found how to adjust the tab settings when editing a stored procedure
>using
> Query Analyzer, but I don't see any way to adjust the tab settings when
> editing a stored procedure using SQL Server Enterprise Manager.
> Does anyone know how to do this?
> Thanks,
> Vernsql

How do I add Virtual table to Report Model (dsv)?

Hi,

problem: I got "Sale" table that include Employee ID & Manager ID.

I want to connect" Employee" table twice to "Sale"

once: Sale.EmployeeID=Employee.EmployeeID

second: Sale.ManagerID=Employee.EmployeeID

how do I create a virtual table for the second connection? can't I solve it in the model layer or need to add view in the database layer?

Thanks,

Assaf

You need to open DSV in Model Designer and add new relationship with Sale.ManagerID=Employee.EmployeeID (you should already have one relship for Sale.EmployeeID=Employee.EmployeeID).

Then open the model and regen the two involved entities or create two new roles manually.

How do I add a single column heading row in the detail section?

Could somebody please tell me how to do this?
I've created a report with the wizard that lists Managers. You toggle
a Manager and a detail section of employees opens for that Manager. I
want to put a row of column names at the top of the detail section when
it's opened (not showing when the detail is closed). I've succeeded in
adding a row that shows above each detail record, but that's not what I
want. I just want a single row of column headings.
I've tried looking everywhere, including the Help system, and I can't
find how to do this. Probably simple, right?
Thanks, JulieHi Julie,
Highlight the Managers group, right click and select Insert Row Below.
That will add another row for that group, but since the group only gets
repeated once for each manager this is what you want. Toggle this new
row on the Manager and you're good to go.
take care,
Michelle|||Michelle, thank you, that's what I've been trying to do. That just
leaves me to figure out how to hide this new detail header when the
Manager group is not toggled. Setting the visibility of the detail
header to False makes it invisible all the time. I want it to become
visible when the Manager is toggled, and only for any Manager(s)
toggled.
Michelle wrote:
> Hi Julie,
> Highlight the Managers group, right click and select Insert Row
Below.
> That will add another row for that group, but since the group only
gets
> repeated once for each manager this is what you want. Toggle this
new
> row on the Manager and you're good to go.
> take care,
> Michellesql

How do I access MSDE?

Hi,
I don't have Visual Studio, so I'm using web matrix and MSDE. My question is, how do I get to MSDE? I don't have the enterprise manager that comes with SQL Server. Thanks
amitDownload the SQL Server Web Data Administrator
Easily manage your SQL Server and MSDE data, wherever you are. Use this tool to create and edit databases, manage users and roles, export and import database schema and data, and more—all from your favorite Web browser. Available from the Microsoft Download Center

http://www.microsoft.com/sql

I have not tried it yet, but it might be what you need.

KM|||Check outthis link which has a free Query Analyzer tool. Also here is aweb admin tool from microsoft. HTH|||That's just what I need, thanks to both!sql

How can you tell if SP1 was applied?

Especially in a multi-server environment where I have RS installed with
separate servers for the DB and IIS Report Manager.
I'm guessing there's some kind of @.@.version or version number hidden
somewhere, but where?
I am inheriting a deployment from a previous dba and I don't know if
SP1 was ever installed.
TIA!Go to http://yourserver/Reportserver
It should show version this at the bottom of the page displayed:
Microsoft SQL Server Reporting Services Version 8.00.878.00
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave" <macleary2000@.yahoo.com> wrote in message
news:1108055493.899520.289400@.z14g2000cwz.googlegroups.com...
> Especially in a multi-server environment where I have RS installed with
> separate servers for the DB and IIS Report Manager.
> I'm guessing there's some kind of @.@.version or version number hidden
> somewhere, but where?
> I am inheriting a deployment from a previous dba and I don't know if
> SP1 was ever installed.
> TIA!
>|||Found it. Thank you.
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> It should show version this at the bottom of the page displayed:
> Microsoft SQL Server Reporting Services Version 8.00.878.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave" <macleary2000@.yahoo.com> wrote in message
> news:1108055493.899520.289400@.z14g2000cwz.googlegroups.com...
> > Especially in a multi-server environment where I have RS installed with
> > separate servers for the DB and IIS Report Manager.
> >
> > I'm guessing there's some kind of @.@.version or version number hidden
> > somewhere, but where?
> >
> > I am inheriting a deployment from a previous dba and I don't know if
> > SP1 was ever installed.
> >
> > TIA!
> >
>
>

How can pass variable or parameter in DATA READER SOURCE ising ADO:NET Connection manager

In SSIS in Sql task we have option to pass parameter or variable..But in Data Flow Task when we use Data Reader Source using ADO.NET connection..There is no option to pass parameter or variable Or no option to receive a parameter or variable .

I am having a query were it need to pass a parameter.in sql task ...And Data Reader Source have to receive this parameter from sql task .

Sql Task finds a value of parameter and pass to DataReader Source in DataFlow Task .. ...

Please can any one help me to solve this problem of Receiving parameter or variable in DataReader Source using DAO.Net connection in DataFlow Task..thank you dilsa

USe an expression to override SQLCommand porperty of the data reader:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1283829&SiteID=1

How can I test for divide by zero without using CASE?

Since the query builder (not the query analyzer) in enterprise manager does
not support case statments, I was wondering if there's a way to structure
the following in a different way (without case statements) so that the query
builder works. I thought there might be a way to do soemthing with NULLIF
and/or COALESCE but I got stuck.
CASE WHEN x = 0 THEN 0 ELSE y/x END AS AvgCustBalance
Thanks,
Keith> Since the query builder (not the query analyzer) in enterprise manager
> does
> not support case statments, I was wondering if there's a way to structure
> the following in a different way (without case statements) so that the
> query
> builder works.
Sure, don't use the query builder. Why do you want to force yourself to use
a tricycle to commute to work, when there's a Ferrari in your driveway?|||> Since the query builder (not the query analyzer) in enterprise manager
> does
> not support case statments, I was wondering if there's a way to structure
> the following in a different way (without case statements) so that the
> query
> builder works. I thought there might be a way to do soemthing with NULLIF
> and/or COALESCE but I got stuck.
> CASE WHEN x = 0 THEN 0 ELSE y/x END AS AvgCustBalance
How about :
WHERE x <> 0
--
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane|||Well, that will leave rows out. I wonder if something like this will work:
SELECT COALESCE(y/NULLIF(x,0),0)
FROM
(SELECT x = 1,y=5
UNION ALL SELECT x=2,y=5
UNION ALL SELECT x=0,y=5) z
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:uDUnLsoyFHA.904@.tk2msftngp13.phx.gbl...
> How about :
> WHERE x <> 0
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||Could you tell me what tool you are referring to as a Ferrari?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ue40XqoyFHA.3700@.TK2MSFTNGP10.phx.gbl...
> Since the query builder (not the query analyzer) in enterprise manager
> does
> not support case statments, I was wondering if there's a way to structure
> the following in a different way (without case statements) so that the
> query
> builder works.
Sure, don't use the query builder. Why do you want to force yourself to use
a tricycle to commute to work, when there's a Ferrari in your driveway?|||If one is a todler, then it makes perfect sense. ;-)
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ue40XqoyFHA.3700@.TK2MSFTNGP10.phx.gbl...
> Sure, don't use the query builder. Why do you want to force yourself to
> use a tricycle to commute to work, when there's a Ferrari in your
> driveway?
>|||Query Analyzer, or a host of third party tools. Enterprise Manager is
definitely not the place to write code, view data or manage objects.
"Keith G Hicks" <krh@.comcast.net> wrote in message
news:e3R06DpyFHA.2960@.tk2msftngp13.phx.gbl...
> Could you tell me what tool you are referring to as a Ferrari?
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message
> news:ue40XqoyFHA.3700@.TK2MSFTNGP10.phx.gbl...
> Sure, don't use the query builder. Why do you want to force yourself to
> use
> a tricycle to commute to work, when there's a Ferrari in your driveway?
>
>|||Keith,
Try (as test):
--test for /0 error without using case
CREATE TABLE YX
(Y INT NOT NULL,
X INT NOT NULL)
INSERT YX
VALUES(10,1)
INSERT YX
VALUES(10,0)
INSERT YX
VALUES(10,2)
SELECT Y,X,COALESCE(Y/NULLIF(X,0),0) AS 'Y/X'
FROM YX
HTH
Jerry
"Keith G Hicks" <krh@.comcast.net> wrote in message
news:exTFjnoyFHA.1028@.TK2MSFTNGP12.phx.gbl...
> Since the query builder (not the query analyzer) in enterprise manager
> does
> not support case statments, I was wondering if there's a way to structure
> the following in a different way (without case statements) so that the
> query
> builder works. I thought there might be a way to do soemthing with NULLIF
> and/or COALESCE but I got stuck.
> CASE WHEN x = 0 THEN 0 ELSE y/x END AS AvgCustBalance
> Thanks,
> Keith
>|||This is good, thanks. I didn't realize that 5/null = null. Guess that should
have been obvious.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uREka%23oyFHA.3812@.TK2MSFTNGP09.phx.gbl...
SELECT COALESCE(y/NULLIF(x,0),0)
FROM
(SELECT x = 1,y=5
UNION ALL SELECT x=2,y=5
UNION ALL SELECT x=0,y=5) z|||As far as I understand QA does not have a feature that lets you build
queries in a visual way like you can in EM. I'm a very visually oriented
person and prefer to work in that type of an environment when I can. I
generally use Database workbench for most of my SQL work and I'm very happy
with that. But the vsiual query builder is far from complete. If you don't
mind listing some of the "host of third party tools" I'd find that a bit
more helpful.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OsN1zGpyFHA.2076@.TK2MSFTNGP14.phx.gbl...
Query Analyzer, or a host of third party tools. Enterprise Manager is
definitely not the place to write code, view data or manage objects.
"Keith G Hicks" <krh@.comcast.net> wrote in message
news:e3R06DpyFHA.2960@.tk2msftngp13.phx.gbl...
> Could you tell me what tool you are referring to as a Ferrari?
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message
> news:ue40XqoyFHA.3700@.TK2MSFTNGP10.phx.gbl...
> Sure, don't use the query builder. Why do you want to force yourself to
> use
> a tricycle to commute to work, when there's a Ferrari in your driveway?
>
>