2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike Hayes
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A
|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready".
It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody
knows.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can downloa
d,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Service Pack 2 Release Version schedule

Greetings,
I'm looking for a scheduled release date for Service Pack 2 for SQL Server
2005.
Thanks,
Mike HayesMS do not decide on such dates. The official response is "when it is ready". It is in RC2 now, so
based on that, we can *guess* that it might be 1.5-2 months away, but nobody knows.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes|||> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
There is no such thing.
The release date will be largely based, I would guess, on how much
[negative] feedback is obtained from the SP2 CTP. Which you can download,
kick the tires, and report any problems at connect.microsoft.com:
http://www.microsoft.com/sql/ctp.mspx
Other than that, as Tibor mentioned, we can guess, but there are no
announced dates, because it is not based on a date, but rather WHEN IT'S
READY.
A|||At the keynote at PASS, Paul Flessner I believe stated that SP2 would likely
be out in "early Q1." Of course that is not an official announcement, and
it really could mean anytime between January 1st and March 31st. Or later,
if it's simply not ready.
"Mike Hayes" <Mike Hayes@.discussions.microsoft.com> wrote in message
news:197E3D6C-2878-4122-9D2B-747061E25C59@.microsoft.com...
> Greetings,
> I'm looking for a scheduled release date for Service Pack 2 for SQL Server
> 2005.
> Thanks,
> Mike Hayes

2005 Management Studio: Jobs Details (summary page)

I'm missing the info I got from EM on jobs, in the summary page, e.g. when a
job was last run, success/failure, scheduled, enabled, etc.
I don't see any way to add these columns on the summary page in Managment
Studio, am I missing something, or is this info not available there?
Thanks
Tom
TomT wrote:
> I'm missing the info I got from EM on jobs, in the summary page, e.g. when a
> job was last run, success/failure, scheduled, enabled, etc.
> I don't see any way to add these columns on the summary page in Managment
> Studio, am I missing something, or is this info not available there?
> Thanks
> Tom
Tom,
Go to Object Explorer - SQL Server Agent - Jobs. Here you can right
click on the job and get the job history, properties etc. Pretty much
the same as you're used to on EM but it looks a bit different.
HTH
Regards
Steen
|||Hi Tom,
In SQL Server 2005, we use Job Activity Monitor to see following items
Name - Name of the job.
Enabled - Whether the job is enabled (yes) or not enabled (no).
Status - Current status of the job.
Last Run Outcome - Job status when last run.
Last Run - Date and time job was last run.
Next Run - Date and time the job is next scheduled to run.
Category - The job category assigned to the job.
Runnable - Yes if the job can be run; No if the job cannot be run.
Scheduled - Yes if the job is assigned to a job schedule; No if the job has
no schedule.
For more detailed information, check BOL or MSDN topic
Job Activity Monitor
http://msdn2.microsoft.com/en-us/library/ms188272.aspx
How to: View Job Activity (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms187449.aspx
Monitoring Job Activity
http://msdn2.microsoft.com/en-us/library/ms188272.aspx
How to: Set Up the Job History Log (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms175072.aspx
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

2005 beta Backup problems

Hi there,
I've created a maintenance plan in SQL2005 bet 2 (not default instance)
scheduled to run everyday but it never runs, I've all the services running.
When I choose to execute in the moment it says it had success after 5 seconds
but nothing happens really.
Is this a limitation of the beta release? Or am I doing something wrong?
I've another instance instaled in the same server (but with sql2000
version-default instance) and the maintenance plans work fine.
thanks in advance.
Nelson
Please re-post this on the beta newsgroups.
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Nelson Andr" <NelsonAndr@.discussions.microsoft.com> wrote in message
news:E0B1B330-9D78-4704-8FDF-3A855A5DF64E@.microsoft.com...
> Hi there,
> I've created a maintenance plan in SQL2005 bet 2 (not default instance)
> scheduled to run everyday but it never runs, I've all the services
> running.
> When I choose to execute in the moment it says it had success after 5
> seconds
> but nothing happens really.
> Is this a limitation of the beta release? Or am I doing something wrong?
> I've another instance instaled in the same server (but with sql2000
> version-default instance) and the maintenance plans work fine.
> thanks in advance.
> Nelson
>
|||Where can I find it? I've searched the whole microsoft site and couldn't find
any reference to a sql2005 beta newsgroup
"Wayne Snyder" wrote:

> Please re-post this on the beta newsgroups.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Nelson André" <NelsonAndr@.discussions.microsoft.com> wrote in message
> news:E0B1B330-9D78-4704-8FDF-3A855A5DF64E@.microsoft.com...
>
>
|||http://communities.microsoft.com/new...=sqlserver2005
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nelson André" wrote:
[vbcol=seagreen]
> Where can I find it? I've searched the whole microsoft site and couldn't find
> any reference to a sql2005 beta newsgroup
> "Wayne Snyder" wrote:

2005 beta Backup problems

Hi there,
I've created a maintenance plan in SQL2005 bet 2 (not default instance)
scheduled to run everyday but it never runs, I've all the services running.
When I choose to execute in the moment it says it had success after 5 seconds
but nothing happens really.
Is this a limitation of the beta release? Or am I doing something wrong?
I've another instance instaled in the same server (but with sql2000
version-default instance) and the maintenance plans work fine.
thanks in advance.
NelsonPlease re-post this on the beta newsgroups.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Nelson André" <NelsonAndr@.discussions.microsoft.com> wrote in message
news:E0B1B330-9D78-4704-8FDF-3A855A5DF64E@.microsoft.com...
> Hi there,
> I've created a maintenance plan in SQL2005 bet 2 (not default instance)
> scheduled to run everyday but it never runs, I've all the services
> running.
> When I choose to execute in the moment it says it had success after 5
> seconds
> but nothing happens really.
> Is this a limitation of the beta release? Or am I doing something wrong?
> I've another instance instaled in the same server (but with sql2000
> version-default instance) and the maintenance plans work fine.
> thanks in advance.
> Nelson
>|||Where can I find it? I've searched the whole microsoft site and couldn't find
any reference to a sql2005 beta newsgroup
"Wayne Snyder" wrote:
> Please re-post this on the beta newsgroups.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Nelson André" <NelsonAndr@.discussions.microsoft.com> wrote in message
> news:E0B1B330-9D78-4704-8FDF-3A855A5DF64E@.microsoft.com...
> > Hi there,
> > I've created a maintenance plan in SQL2005 bet 2 (not default instance)
> > scheduled to run everyday but it never runs, I've all the services
> > running.
> > When I choose to execute in the moment it says it had success after 5
> > seconds
> > but nothing happens really.
> > Is this a limitation of the beta release? Or am I doing something wrong?
> > I've another instance instaled in the same server (but with sql2000
> > version-default instance) and the maintenance plans work fine.
> > thanks in advance.
> > Nelson
> >
>
>|||http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nelson André" wrote:
> Where can I find it? I've searched the whole microsoft site and couldn't find
> any reference to a sql2005 beta newsgroup
> "Wayne Snyder" wrote:
> > Please re-post this on the beta newsgroups.
> >
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > (Please respond only to the newsgroup.)
> >
> > I support the Professional Association for SQL Server ( PASS) and it's
> > community of SQL Professionals.
> > "Nelson André" <NelsonAndr@.discussions.microsoft.com> wrote in message
> > news:E0B1B330-9D78-4704-8FDF-3A855A5DF64E@.microsoft.com...
> > > Hi there,
> > > I've created a maintenance plan in SQL2005 bet 2 (not default instance)
> > > scheduled to run everyday but it never runs, I've all the services
> > > running.
> > > When I choose to execute in the moment it says it had success after 5
> > > seconds
> > > but nothing happens really.
> > > Is this a limitation of the beta release? Or am I doing something wrong?
> > > I've another instance instaled in the same server (but with sql2000
> > > version-default instance) and the maintenance plans work fine.
> > > thanks in advance.
> > > Nelson
> > >
> >
> >
> >

2005 beta Backup problems

Hi there,
I've created a maintenance plan in SQL2005 bet 2 (not default instance)
scheduled to run everyday but it never runs, I've all the services running.
When I choose to execute in the moment it says it had success after 5 second
s
but nothing happens really.
Is this a limitation of the beta release? Or am I doing something wrong?
I've another instance instaled in the same server (but with sql2000
version-default instance) and the maintenance plans work fine.
thanks in advance.
NelsonPlease re-post this on the beta newsgroups.
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Nelson Andr" <NelsonAndr@.discussions.microsoft.com> wrote in message
news:E0B1B330-9D78-4704-8FDF-3A855A5DF64E@.microsoft.com...
> Hi there,
> I've created a maintenance plan in SQL2005 bet 2 (not default instance)
> scheduled to run everyday but it never runs, I've all the services
> running.
> When I choose to execute in the moment it says it had success after 5
> seconds
> but nothing happens really.
> Is this a limitation of the beta release? Or am I doing something wrong?
> I've another instance instaled in the same server (but with sql2000
> version-default instance) and the maintenance plans work fine.
> thanks in advance.
> Nelson
>|||Where can I find it? I've searched the whole microsoft site and couldn't fin
d
any reference to a sql2005 beta newsgroup
"Wayne Snyder" wrote:

> Please re-post this on the beta newsgroups.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Nelson André" <NelsonAndr@.discussions.microsoft.com> wrote in message
> news:E0B1B330-9D78-4704-8FDF-3A855A5DF64E@.microsoft.com...
>
>|||http://communities.microsoft.com/ne...p=sqlserver2005
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nelson André" wrote:
[vbcol=seagreen]
> Where can I find it? I've searched the whole microsoft site and couldn't f
ind
> any reference to a sql2005 beta newsgroup
> "Wayne Snyder" wrote:
>