Modification Logs

Is there a way to determine when a file was changed/modified? We're on
SQL 2000 and I need to know when a view was modified and by whom.
Thanks!By "file" I assume you mean that the view on the database has been
modified?

If so then there are several things you could do:

1. Get a transaction log examining tool which will let you scan the
transaction logs for the DDL command that modified the view. The "by
whom" depends on how your database security is set up. If, for
example, everyone is accustomed to using the "sa" account then this
won't tell you very much. If you have specific account set up for
each individual user then you'll have all the info you need.

2. If the answer to the above was the former then review your database
access security and ensure that only person-specific user accounts
have the privileges to make modifications.

3. Implement a change process for your SQL code - take a look at
www.dbghost.com for a tool that enables such a process.sql

Model generation (for Report Builder)

I have had to add Calculated columns to some tables in my Data Source View in
order to correctly link some tables but this kills the model generation.
For example, although the job table has a CompanyID column, the job_task
table does not - but I need to be able to lookup a status in CompanyReason
which is indexed on CompanyID and PauseReason (this column is in job_task).
So I added 'theCompanyID' as a Calculated columns to job_task with the
following code:
SELECT TOP 1 j.company_id FROM mh4_job_task jt INNER JOIN mh4_job j on
j.job_id = jt.job_id
Makes sense? But when I create a model with it - this is the error message:
--
An error occurred while executing a command.
Message: Cannot perform an aggregate function on an expression containing an
aggregate or a subquery.
Line 5: Incorrect syntax near ')'.
Command:
SELECT
COUNT([notes]),
COUNT(DISTINCT [notes]),
COUNT((SELECT TOP 1 j.company_id FROM job_task jt INNER JOIN job j on
j.job_id = jt.job_id)),
COUNT(DISTINCT (SELECT TOP 1 j.company_id FROM job_task jt INNER JOIN job j
on j.job_id = jt.job_id)),
COUNT('task_status'),
COUNT(DISTINCT 'task_status')
FROM [dbo].[job_task] t
--
Of course, the error is correct - what I need to know is how to either
bypass the column uniqueness test FOR THIS ONE column or another method to
create the link in the Data Source View.
Thank you,
ScottI would use SSIS to get this set up. I have not done such a thing, but since
SSIS can provide report datasources that's the route I would look at.
"ScottB" <ScottB@.discussions.microsoft.com> wrote in message
news:95A89A5B-F36B-4056-96BF-A748B613CA25@.microsoft.com...
>I have had to add Calculated columns to some tables in my Data Source View
>in
> order to correctly link some tables but this kills the model generation.
> For example, although the job table has a CompanyID column, the job_task
> table does not - but I need to be able to lookup a status in CompanyReason
> which is indexed on CompanyID and PauseReason (this column is in
> job_task).
> So I added 'theCompanyID' as a Calculated columns to job_task with the
> following code:
> SELECT TOP 1 j.company_id FROM mh4_job_task jt INNER JOIN mh4_job j on
> j.job_id = jt.job_id
>
> Makes sense? But when I create a model with it - this is the error
> message:
> --
> An error occurred while executing a command.
> Message: Cannot perform an aggregate function on an expression containing
> an
> aggregate or a subquery.
> Line 5: Incorrect syntax near ')'.
> Command:
> SELECT
> COUNT([notes]),
> COUNT(DISTINCT [notes]),
> COUNT((SELECT TOP 1 j.company_id FROM job_task jt INNER JOIN job j on
> j.job_id = jt.job_id)),
> COUNT(DISTINCT (SELECT TOP 1 j.company_id FROM job_task jt INNER JOIN job
> j
> on j.job_id = jt.job_id)),
> COUNT('task_status'),
> COUNT(DISTINCT 'task_status')
> FROM [dbo].[job_task] t
> --
> Of course, the error is correct - what I need to know is how to either
> bypass the column uniqueness test FOR THIS ONE column or another method to
> create the link in the Data Source View.
> Thank you,
> Scott|||Hi,
I am new to SSIS. I have been searching for some examples to
use Expression Builder in SSIS to use derived columns
transformation...I basically want to add a new column to my data source
on the run and add this column as the 2nd column before loading into
destination. How can I achieve this? Plz help. Is there a link where I
can get examples online'

MLM Database

Which components are suitable for MLM genea;logy view in binary /trinary ? Thanx in advance

You may visiti the for more resources, which shares lots of components for mlm, scripts.

http://www.vclcomponents.com/catalog/Mlm

missing system databases folder from management studio

Hi All
My view of database on management studio does not have folder with system
databases. I am sysadmin on server and member of local admins group. Do you
know what could be a problem?In Management Studio take a look at Tools, Options, Hide system objects in
Object Explorer. Is the box checked?
Hope this helps,
Ben Nevarez
"Gene." wrote:
> Hi All
> My view of database on management studio does not have folder with system
> databases. I am sysadmin on server and member of local admins group. Do you
> know what could be a problem?|||Hi Gene
There is an option available that turns system objects visible or invisible.
Look at the Options in the Tools menu. The General tab has the checkbox
"Hide system objects in Object Explorer"
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:FAEC8F2B-9E3E-467C-B368-756773D1BD16@.microsoft.com...
> Hi All
> My view of database on management studio does not have folder with system
> databases. I am sysadmin on server and member of local admins group. Do
> you
> know what could be a problem?|||Hi Ben, Kalen
This is genious!
I did not change those settings but that was a fix!
Thank you so much. I am happy again now.
"Kalen Delaney" wrote:
> Hi Gene
> There is an option available that turns system objects visible or invisible.
> Look at the Options in the Tools menu. The General tab has the checkbox
> "Hide system objects in Object Explorer"
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:FAEC8F2B-9E3E-467C-B368-756773D1BD16@.microsoft.com...
> > Hi All
> > My view of database on management studio does not have folder with system
> > databases. I am sysadmin on server and member of local admins group. Do
> > you
> > know what could be a problem?
>
>
>

Missing Report Graphs

I am testing a new install of Reporting Services with Mom 2005. Every report
that I try to view that contains a graph simply displays an empty box with a
red X in the upper left. Is there some component that I am possibly missing
that contains the graph object?
Any help is appreciated!
--
Dale Foshe, mcseSee if cookies are allowed in the browser by looking at the status bar when
the report is requested.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Dale Foshe, mcse" <DaleFoshemcse@.discussions.microsoft.com> wrote in
message news:AE3335EA-A974-4D0E-A3AC-49FAAE34B759@.microsoft.com...
> I am testing a new install of Reporting Services with Mom 2005. Every
report
> that I try to view that contains a graph simply displays an empty box with
a
> red X in the upper left. Is there some component that I am possibly
missing
> that contains the graph object?
> Any help is appreciated!
> --
> Dale Foshe, mcse

Missing INFORMATION_SCHEMA.ROUTINES

Hi all,
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!
I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:

> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>
|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
[vbcol=seagreen]
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
|||Where are you looking? The view only exists in the master database physically, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" <me_no_like_spam_juanDOTromero@.bowneDOTcom> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...[vbcol=seagreen]
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
[vbcol=seagreen]
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:

Missing INFORMATION_SCHEMA.ROUTINES

Hi all,
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:

> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleas
ew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
>|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleas
ew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
>|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
[vbcol=seagreen]
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
>|||Where are you looking? The view only exists in the master database physicall
y, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" < me_no_like_spam_juanDOTromero@.bowneDOTco
m> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...[vbcol=seagreen]
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
>|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
[vbcol=seagreen]
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
>

Missing INFORMATION_SCHEMA.ROUTINES

Hi all,
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
>>I do not think that this view was added as a service pack addition. Pleasew
>>verify that you are logging in with applicable permissions. This view is
>>created by default.
>>"Madestro" wrote:
>>
>>Hi all,
>>For some reason this view is missing from my MSSQL:
>>INFORMATION_SCHEMA.ROUTINES
>>Does anyone have any idea why?... Is it a service pack maybe?
>>Please let me know. Thank you!
>>|||Where are you looking? The view only exists in the master database physically, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" <me_no_like_spam_juanDOTromero@.bowneDOTcom> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
>> I do not think that this view was added as a service pack addition. Pleasew
>> verify that you are logging in with applicable permissions. This view is
>> created by default.
>> "Madestro" wrote:
>> > Hi all,
>> >
>> > For some reason this view is missing from my MSSQL:
>> >
>> > INFORMATION_SCHEMA.ROUTINES
>> >
>> > Does anyone have any idea why?... Is it a service pack maybe?
>> >
>> > Please let me know. Thank you!
>> >|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
> > I do not think that this view was added as a service pack addition. Pleasew
> > verify that you are logging in with applicable permissions. This view is
> > created by default.
> >
> > "Madestro" wrote:
> >
> > > Hi all,
> > >
> > > For some reason this view is missing from my MSSQL:
> > >
> > > INFORMATION_SCHEMA.ROUTINES
> > >
> > > Does anyone have any idea why?... Is it a service pack maybe?
> > >
> > > Please let me know. Thank you!
> > >

Missing Images in rendered HTML View

Hi,

i have a report with an image on the footer. When i view the report in the designer/report manager or export to any format, everythings fine. Now i have a ASP.NET site which makes a webservice call to get HTML output from my report. in this case no image show up. The Url of the image is like that: h**p://servername/ReportServer?%2fDocuments%2fGerman%2fOrder%2fOrderResponse&rs%3aFormat=HTML4.0&rs%3aImageID=ac8c4a8c-8a63-4ff9-ba74-6d6a7076a0ef

When i check the HTML version of the Report Manager the url of the image is like: h**p://servername/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=iuwsgfikvz4ezfmd0tqmyj45&ControlID=cee4d933-5ab6-413f-8c28-4c3a2b3ff230&Culture=1031&UICulture=7&ReportStack=1&OpType=ReportImage&StreamID=84e7491d-eab4-4502-adac-2bec4254da90

I take the byte stream of the report from the RS Service an put it to the HttpResponse of the ASP.NET page.

What could be the problem?

When you render a report which contains an image or a chart (which is really just an image), you not only have to call Render(), but then you call RenderStream() for each image in the report. Books online has some good examples of this.|||

Ok, when i understand it correctly, the RenderStream method provides the functionality to get each image stream for this report.

The images in my report are external images and are part of the project. In this case i can use the DeviceInfo - parameter HTMLFragment set to true. But this doesn't work.

What could be te problem?

Missing History for Jobs (msdb.dbo.sysjobhistory)

New server running our SQL... upgrade from Advanced 2000 to Enterprise
2003... our SQL Instance normally records all history (View History from Job
s
in SQL Agent). For some reason, currently unknown, history disappears every
so often. In this case, all history from 11/24 going backward is gone. All
history from 11/25 through today is here. This happened previously. Is
there any logical explanation for this? I'd settle for a server reboot, but
to my knowledge, this did not happen either.
Also there is a disk space problem on one of the drives. The msdb does not
touch that drive so, in my way of thinking the drive space issue cannot be
connected to the missing history (sysjobhistory). Is this logical to assume
?
An additional thought comes to mind. The jobs were imported from one server
to another. The owner was either the service account (with plenty of
permission) or the sa account, but the jobs were recreated from script using
the sa login. Could this have an effect on the job history?
--
Regards,
JamieAlso I believe this is happenning each week. Saturday night or Sunday
morning to be sure.
--
Regards,
Jamie
"thejamie" wrote:

> New server running our SQL... upgrade from Advanced 2000 to Enterprise
> 2003... our SQL Instance normally records all history (View History from J
obs
> in SQL Agent). For some reason, currently unknown, history disappears eve
ry
> so often. In this case, all history from 11/24 going backward is gone. A
ll
> history from 11/25 through today is here. This happened previously. Is
> there any logical explanation for this? I'd settle for a server reboot, b
ut
> to my knowledge, this did not happen either.
> Also there is a disk space problem on one of the drives. The msdb does no
t
> touch that drive so, in my way of thinking the drive space issue cannot be
> connected to the missing history (sysjobhistory). Is this logical to assu
me?
> An additional thought comes to mind. The jobs were imported from one serv
er
> to another. The owner was either the service account (with plenty of
> permission) or the sa account, but the jobs were recreated from script usi
ng
> the sa login. Could this have an effect on the job history?
> --
> Regards,
> Jamie|||thejamie,
Recreating the jobs would cause them to have a new job_id, so any history
records that might still exist in sysjobhistory will no longer join to
existing jobs. (If you still have your previous server and can figure out
the old job_id to new job_id mapping, you could update rowsn in your
sysjobhistory and all would be well.)
Also, make sure that your SQL Agent Properties - History settings are the
same on you new server as your old, or you will find SQL Agent (by default)
deleting history fairly frequently.
RLF
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:C078BDDA-ED20-4F42-AD0E-2FF1AED4EE7F@.microsoft.com...
> New server running our SQL... upgrade from Advanced 2000 to Enterprise
> 2003... our SQL Instance normally records all history (View History from
> Jobs
> in SQL Agent). For some reason, currently unknown, history disappears
> every
> so often. In this case, all history from 11/24 going backward is gone.
> All
> history from 11/25 through today is here. This happened previously. Is
> there any logical explanation for this? I'd settle for a server reboot,
> but
> to my knowledge, this did not happen either.
> Also there is a disk space problem on one of the drives. The msdb does
> not
> touch that drive so, in my way of thinking the drive space issue cannot be
> connected to the missing history (sysjobhistory). Is this logical to
> assume?
> An additional thought comes to mind. The jobs were imported from one
> server
> to another. The owner was either the service account (with plenty of
> permission) or the sa account, but the jobs were recreated from script
> using
> the sa login. Could this have an effect on the job history?
> --
> Regards,
> Jamie|||Thanks for the reply Russell. Actually, I moved the data over on 11/4. I
didn't expect any history to go back before the move. What bothers me is
that on Saturday I had history going back to 11/4. On Sunday, it extended
only from 11/25. Everything prior to 11/24 is wiped. It still exists in
sysjobhistory. I am not the sole DBA so it is possible that someone other
than myself wiped it, but I have to presume that is not the case. It isn't
vital. I can filter the log for a given job to get the history. The histor
y
was set to 1000 - I have lots of disk space at the moment so I moved it to
10000 and from 100 to 1000 on the rows. Still a mystery. I suspect that
the disk space on the one drive being low may have something to do with the
history disappearing.
--
Regards,
Jamie
"Russell Fields" wrote:

> thejamie,
> Recreating the jobs would cause them to have a new job_id, so any history
> records that might still exist in sysjobhistory will no longer join to
> existing jobs. (If you still have your previous server and can figure out
> the old job_id to new job_id mapping, you could update rowsn in your
> sysjobhistory and all would be well.)
> Also, make sure that your SQL Agent Properties - History settings are the
> same on you new server as your old, or you will find SQL Agent (by default
)
> deleting history fairly frequently.
> RLF
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:C078BDDA-ED20-4F42-AD0E-2FF1AED4EE7F@.microsoft.com...
>
>|||Jamie,
If the rows are still in sysjobhistory then they should connect to the jobs.
If the jobs will not show history further back than 11/24, then did someone
redeploy the jobs again, such that they got new job_ids?
RLF
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:A8C507C7-D1B6-46FF-AD2F-9E9EBCF829F5@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply Russell. Actually, I moved the data over on 11/4. I
> didn't expect any history to go back before the move. What bothers me is
> that on Saturday I had history going back to 11/4. On Sunday, it extended
> only from 11/25. Everything prior to 11/24 is wiped. It still exists in
> sysjobhistory. I am not the sole DBA so it is possible that someone other
> than myself wiped it, but I have to presume that is not the case. It
> isn't
> vital. I can filter the log for a given job to get the history. The
> history
> was set to 1000 - I have lots of disk space at the moment so I moved it to
> 10000 and from 100 to 1000 on the rows. Still a mystery. I suspect that
> the disk space on the one drive being low may have something to do with
> the
> history disappearing.
> --
> Regards,
> Jamie
>
> "Russell Fields" wrote:
>|||Sounds very possible. Thanks.
--
Regards,
Jamie
"Russell Fields" wrote:

> Jamie,
> If the rows are still in sysjobhistory then they should connect to the job
s.
> If the jobs will not show history further back than 11/24, then did someon
e
> redeploy the jobs again, such that they got new job_ids?
> RLF
>
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:A8C507C7-D1B6-46FF-AD2F-9E9EBCF829F5@.microsoft.com...
>
>