The first select statement shows the NEXT run date for the Jobs. The second select statement shows the history.

To show all the scheduled date/time, not just the NEXT run...

Found bugs....

-----------------------------------------

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER PROCEDURE dbo.ScheduledJobs

( @Startdate smalldatetime,

@EndDate smalldatetime

)

AS

declare @tmpStartDate char(10)

declare @tmpEndDate char(10)

declare @tmpStartTime char(8)

declare @tmpEndTime char(8)

declare @myStartDate int

declare @myEndDate int

declare @myStartTime int

declare...

oops! I didn't read your posting carefully. sorry!

Try this:

selectcast(o.name as varchar(30)) 'Table Name',

rowcnt Rows,

reserved / 128.0 'Space Allocated MB',

used / 128.0 'Space Used MB'

fromsysindexes i

join sysobjects o

on i.id = o.id

where ( i.indid is null

or...

Hello, the following script has not been fully tested. But you get the point, you can do your own debugging.

-------------------------------------------

CREATE PROCEDURE dbo.ScheduledJobs

( @Startdate smalldatetime,

@EndDate smalldatetime

)

AS

declare @tmpStartDate char(10)

declare @tmpEndDate...

I think you should be more worry about what gets into production db and make sure what gets into works.

We usually create a lot of db for testing...

Gave me 2 days of headache as it was very difficult debug.

Found the answer in: http://support.microsoft.com/default.aspx?scid=kb;en-us;296848&Product=acc2000

I created my own SP to capture the DB size by copying the codes in sp_SpaceUsed. Hope it works on you!

CREATE TABLE [dbo].[tblDBSize] (

[DBName] [varchar] (50) NOT...

oops! billyburns posted the same solution while I was in the middle of typing. Sorry for the duplicate posting!

It happened to me when I have bit field type in the table.

My scenario: I imported data into the table but nothing is specified for the bit...

Hello. I have tried, received the following message:

Database name 'xxx' ignored, referencing object in tempdb.

Temp tables are placed in tempdb. It looks like we cannot referecning objects in tempdb...

I have tried that before using the Pass-Trough query. I got "Item not found in this collection" error when trying to assign the ADODB.recordset to report's recordset. Not...

Thanks for the tips, NPeeters. Figure it out!!

For those who are interested, my solutions are as below:

1. Create a DSN to connect to SQL Server.

2. Create a...

sorry, my fault. it's working now. Thanks!

Found the solution. It was becuase I am not the administrator in that server. Thanks!