-- Create the Holiday Table

create table tblHolidays

(

id int identity(1,1),

Holiday datetime

)

-- Insert test Holiday dates

Insert Into tblHolidays(holiday)

select (getdate()-1)

Union all

select (getdate()+2)

Union all

select (getdate()+1)

Union all

select (getdate()+10)

-- Insert this as a part of...

Very Neat and Tidy script Paul 🙂

The other way is to create a insert/update/delete trigger that roll backs any modification to the base table, however i still prefer the previous method of putting the table in...

One way that i can think of doing this is put this table...

You were much faster Lowell with detailed explanation.:w00t:

I dont think it's possible to modify a column to take identity property.

Please have a look at the following article from SSC, which describes two ways of achieving what...

for the logspace part, the following code will write the results in a table which you can query later.

create table tblLogSize(dbname varchar(100),

logsize float,

used float,

status int

)

go

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

create procedure LogSpace

as

dbcc sqlperf(logspace)

go

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

Create Procedure InsertIntoTable

as

truncate...

whats the problem in creating it?

for dbcc sqlperf(logspace) you may want to capture the results to a table... use dynamic query for this..

Glad I could help 🙂

I dont think this feature is available while scheduling your job. You'll have to manually disable it/enable it OR you can create a Holidays table containing holiday dates and query...

you can modify the table's property from management studio.

Right click on your table, Modify, from the column properties tab, you can modify the column to be identity.

use this code.

SELECT o.[name], o.[type], i.[name], i.[index_id], f.[name]

FROM sys.indexes i

INNER JOIN sys.filegroups f

ON i.data_space_id = f.data_space_id

INNER JOIN sys.all_objects o

ON i.[object_id] = o.[object_id]

WHERE i.data_space_id = 2

refer: http://www.mssqltips.com/tip.asp?tip=1112

What version of sql server are you running. Microsoft suggests installing SP2 and then CU build 3161.

Refer : http://support.microsoft.com/kb/933766

As far as i know, sql agent services are not a part of express edition.

There is a setting where you define maximum no of rows of history of a particular job.

Pls go through this link:

http://www.mssqltips.com/tip.asp?tip=1269