2008 Management Studio?

Hi all... I installed the 2008 CTP, and am trying to figure out where
Management Studio is.
I want to play around with the new auditing features and stuff... but can't
find any way to use it.
I tried searching "add features" in the BOL, but find nothing of any use.
Thanks in advance,
Arhur Dent.
Do you have SQL Server 2005 installed on the server on which you also
install SQL Server 2008?
Because if there is SQL Server 2005' s Management Studio is installed then
SQL Server 2008' s SSMS (Client Tools) will not be installed. You'll need to
uninstall SQL Server 2005' s Client Tools to be able to install SQL Server
2008's Client Tools.
If this is not your situation, then you may be missed to choose Client Tools
in SQL Server 2008 Setup\ Feature Selection\Shared Features?
Ekrem nsoy
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:7C16DA22-0BB1-484E-B9F6-39D593D5510F@.microsoft.com...
> Hi all... I installed the 2008 CTP, and am trying to figure out where
> Management Studio is.
> I want to play around with the new auditing features and stuff... but
> can't find any way to use it.
> I tried searching "add features" in the BOL, but find nothing of any use.
> Thanks in advance,
> Arhur Dent.
|||Also, if it's the Express Edition of SQL Server 2008 CTP, there is no
SSMS\SSMSE with it. There is SSMS of SQL Server 2008 only in the Developer
Edition CTP for now.
Ekrem nsoy
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:7C16DA22-0BB1-484E-B9F6-39D593D5510F@.microsoft.com...
> Hi all... I installed the 2008 CTP, and am trying to figure out where
> Management Studio is.
> I want to play around with the new auditing features and stuff... but
> can't find any way to use it.
> I tried searching "add features" in the BOL, but find nothing of any use.
> Thanks in advance,
> Arhur Dent.
|||Huh? I get what you say, but why the heck? That seems really odd,
considering they install in separate folders and hence, should be able to
coexists, and you can't even connect to the 2008 db anyway with the 2005
tools. It complains and says they can only be used to connect to 2000 or
2005 servers.
Someone at MS must've been a little distracted when they wrote that
installer. :-S
"Ekrem nsoy" <ekrem@.compecta.com> wrote in message
news:886968BD-CBB4-4143-B6A1-A887E106DA01@.microsoft.com...
> Do you have SQL Server 2005 installed on the server on which you also
> install SQL Server 2008?
> Because if there is SQL Server 2005' s Management Studio is installed then
> SQL Server 2008' s SSMS (Client Tools) will not be installed. You'll need
> to uninstall SQL Server 2005' s Client Tools to be able to install SQL
> Server 2008's Client Tools.
> If this is not your situation, then you may be missed to choose Client
> Tools in SQL Server 2008 Setup\ Feature Selection\Shared Features?
> --
> Ekrem nsoy
>
> "Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:7C16DA22-0BB1-484E-B9F6-39D593D5510F@.microsoft.com...
>
|||Arthur Dent (hitchhikersguideto-news@.yahoo.com) writes:
> Huh? I get what you say, but why the heck? That seems really odd,
> considering they install in separate folders and hence, should be able to
> coexists, and you can't even connect to the 2008 db anyway with the 2005
> tools. It complains and says they can only be used to connect to 2000 or
> 2005 servers.
> Someone at MS must've been a little distracted when they wrote that
> installer. :-S
If you have Mgmt Studio 2005 Express installed on a machine and install
Mgmt Studio 2005, this does not work out. You cannot run both versions
of Mgmt Studio on the same machine. I guess it's something similar here,
except that the installer prevents it from even happening.
There is a fix for connecting to SQL 2008 from SQL 2005 Mgmt Studio,
available in Cumultative Update 5: http://support.microsoft.com/kb/943656.
But I get a little worried when you say you install SQL 2008 on a machine
on which you already have SQL 2005. Not that that in itself is wrong, but
I hope this is not your day-to-day machine. I definitely recommend against
installing beta software on machines you don't want to reinstall. Not that
I know that the SQL 2008 CTP will wreck your machine, but it's not a game
of change I'm prepared to play myself. Personally, I install all betas on
virtual machines.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||I'd strongly recommend that you install any CTPs on a Virtual machine. VPC
is free.
-Paul
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:4B78B7D6-9027-408B-A211-B0213D8E823A@.microsoft.com...[vbcol=seagreen]
> Huh? I get what you say, but why the heck? That seems really odd,
> considering they install in separate folders and hence, should be able to
> coexists, and you can't even connect to the 2008 db anyway with the 2005
> tools. It complains and says they can only be used to connect to 2000 or
> 2005 servers.
> Someone at MS must've been a little distracted when they wrote that
> installer. :-S
>
> "Ekrem nsoy" <ekrem@.compecta.com> wrote in message
> news:886968BD-CBB4-4143-B6A1-A887E106DA01@.microsoft.com...
|||Yes, I know all the usual disclaimers and such about beta software, but
thank you for the suggestions.
the only problem with VPC is that while IT is free, it is NOT free to put a
copy of Windows in there. (AFAIK) you are supposed to buy another license of
windows just to run the VPC machine. :-S Rather a disincentive there.
:-\
"Paul Nielsen (SQL)" <pauln@.sqlserverbible.com> wrote in message
news:36931E74-AE48-41D6-BDAA-225AA2417A5C@.microsoft.com...
> I'd strongly recommend that you install any CTPs on a Virtual machine. VPC
> is free.
> -Paul
>
> "Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:4B78B7D6-9027-408B-A211-B0213D8E823A@.microsoft.com...
>
|||Arthur Dent (hitchhikersguideto-news@.yahoo.com) writes:
> Yes, I know all the usual disclaimers and such about beta software, but
> thank you for the suggestions.
> the only problem with VPC is that while IT is free, it is NOT free to
> put a copy of Windows in there. (AFAIK) you are supposed to buy another
> license of windows just to run the VPC machine. :-S Rather a
> disincentive there.
>:-\
You can even download a preconfigured virtual machine from
http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-
82e4-4efd6705f4a6&DisplayLang=en
This requires Virtual Server, but according to the page, Virtual Server is
free.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||yes, virtual server is available here for free:
http://technet.microsoft.com/en-us/bb738033.aspx
The virtual machine that Erland posted the link to works with this no
problem.
http://elsasoft.org
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9A1D8393BF992Yazorman@.127.0.0.1...
> Arthur Dent (hitchhikersguideto-news@.yahoo.com) writes:
> You can even download a preconfigured virtual machine from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-
> 82e4-4efd6705f4a6&DisplayLang=en
> This requires Virtual Server, but according to the page, Virtual Server is
> free.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||What version of 2008 is in the VHD? It doesn't seem to say on the page.
Is it Express or the full Developer version with all the management tools?
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9A1D8393BF992Yazorman@.127.0.0.1...
> Arthur Dent (hitchhikersguideto-news@.yahoo.com) writes:
> You can even download a preconfigured virtual machine from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-
> 82e4-4efd6705f4a6&DisplayLang=en
> This requires Virtual Server, but according to the page, Virtual Server is
> free.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

2005 Update Statistics Task fails

Hi,
Can anyone, given the history below, tell me why this task fails? Or could
you tell me how to figure out why the task fails?
Thanks,
Jim
Windows Server 2003 SP2
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on
Windows NT 5.2 (Build 3790: Service Pack 2)
---
Date 9/10/2007 9:58:00 AM
Log Job History (User Maintenance.Update Statistics)
Step ID 1
Server GENOME-GENDB
Job Name User Maintenance.Update Statistics
Step Name Update Statistics
Duration 00:03:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00 for
64-bit Copyright (C) Microsoft Corp 1984-2005.
All rights reserved.
Started: 9:58:00 AM
Progress: 2007-09-10 09:58:00.59
Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete
End Progress
Progress: 2007-09-10 10:00:10.27
Source: Update Statistics Task
Executing query "use [blast_xml] ".: 12% complete
End Progress
Progress: 2007-09-10 10:00:10.33
Source: Update Statistics Task
Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".: 25%
complete
End Progress
Progress: 2007-09-10 10:00:10.33
Source: Update Statistics Task
Executing query "use [blast_xml] ".: 37% complete
End Progress
Progress: 2007-09-10 10:00:10.44
Source: Update Statistics Task
Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".: 50%
complete
End Progress
Progres... The package execution fa... The step failed.I would create a text file for the log for more details, instead of just
relying on the job history.
You can also execute the SSIS package while in the designer window and watch
which step fails in the debug mode.
"Jim" <noreply@.noreply.com> wrote in message
news:eEJ35X88HHA.4752@.TK2MSFTNGP04.phx.gbl...
> Hi,
> Can anyone, given the history below, tell me why this task fails? Or
> could you tell me how to figure out why the task fails?
> Thanks,
> Jim
> Windows Server 2003 SP2
> Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
> on Windows NT 5.2 (Build 3790: Service Pack 2)
> ---
> Date 9/10/2007 9:58:00 AM
> Log Job History (User Maintenance.Update Statistics)
> Step ID 1
> Server GENOME-GENDB
> Job Name User Maintenance.Update Statistics
> Step Name Update Statistics
> Duration 00:03:00
> Sql Severity 0
> Sql Message ID 0
> Operator Emailed
> Operator Net sent
> Operator Paged
> Retries Attempted 0
> Message
> Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00 for
> 64-bit Copyright (C) Microsoft Corp 1984-2005.
> All rights reserved.
> Started: 9:58:00 AM
> Progress: 2007-09-10 09:58:00.59
> Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete
> End Progress
> Progress: 2007-09-10 10:00:10.27
> Source: Update Statistics Task
> Executing query "use [blast_xml] ".: 12% complete
> End Progress
> Progress: 2007-09-10 10:00:10.33
> Source: Update Statistics Task
> Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".: 25%
> complete
> End Progress
> Progress: 2007-09-10 10:00:10.33
> Source: Update Statistics Task
> Executing query "use [blast_xml] ".: 37% complete
> End Progress
> Progress: 2007-09-10 10:00:10.44
> Source: Update Statistics Task
> Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".: 50%
> complete
> End Progress
> Progres... The package execution fa... The step failed.
>|||Thank you, YPD. I will keep this in mind when I return to troubleshooting
that situation.
"YPD" <y.ding@.neu.edu> wrote in message
news:286E5C59-EE3E-4263-96C1-D51E7461915A@.microsoft.com...
>I would create a text file for the log for more details, instead of just
>relying on the job history.
> You can also execute the SSIS package while in the designer window and
> watch which step fails in the debug mode.
>
> "Jim" <noreply@.noreply.com> wrote in message
> news:eEJ35X88HHA.4752@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> Can anyone, given the history below, tell me why this task fails? Or
>> could you tell me how to figure out why the task fails?
>> Thanks,
>> Jim
>> Windows Server 2003 SP2
>> Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50
>> Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
>> on Windows NT 5.2 (Build 3790: Service Pack 2)
>> ---
>> Date 9/10/2007 9:58:00 AM
>> Log Job History (User Maintenance.Update Statistics)
>> Step ID 1
>> Server GENOME-GENDB
>> Job Name User Maintenance.Update Statistics
>> Step Name Update Statistics
>> Duration 00:03:00
>> Sql Severity 0
>> Sql Message ID 0
>> Operator Emailed
>> Operator Net sent
>> Operator Paged
>> Retries Attempted 0
>> Message
>> Executed as user: <our_domain>\<our_sql_server_account>. ...00.3042.00
>> for 64-bit Copyright (C) Microsoft Corp 1984-2005.
>> All rights reserved.
>> Started: 9:58:00 AM
>> Progress: 2007-09-10 09:58:00.59
>> Source: {5D469B6D-98A4-4907-92D7-904C931892B5}
>> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
>> 100% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.27
>> Source: Update Statistics Task
>> Executing query "use [blast_xml] ".: 12% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.33
>> Source: Update Statistics Task
>> Executing query "UPDATE STATISTICS [dbo].[tBlastOutput] WITH SAMP".:
>> 25% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.33
>> Source: Update Statistics Task
>> Executing query "use [blast_xml] ".: 37% complete
>> End Progress
>> Progress: 2007-09-10 10:00:10.44
>> Source: Update Statistics Task
>> Executing query "UPDATE STATISTICS [dbo].[tBlastRun] WITH SAMPLE ".:
>> 50% complete
>> End Progress
>> Progres... The package execution fa... The step failed.
>>
>