Hi

There is a syntax error in your code , "=" is missing .

IF EXISTS (SELECT *

FROM dbo.SysObjects

...

really liked the article...

Yup... i got the same results..

SET @SqlCmd = 'USE ?;SELECT DB_NAME() AS DATABASENAME,

OBJECT_NAME(B.OBJECT_ID) AS TABLENAME,

...

Hi

In the @Database table variable store database id also.

Then in you select query change this part

"FROM SYS.DM_DB_INDEX_USAGE_STATS C

...

Hi

sorry for the delay.

to calculate the scheduledate

select * from

Maintenance where dateadd(mm,6,datestart) for maint_id = "somevalue" and datestart = getdate().

similarly for the week,year,days etc.

Put this in a proc...

what abt this..

One single encrypted procedure containing the open master key statement.

In the procedure that inserts the data

call the master key proc

do the...

Its been a relatively fast release for SQL 2008. I sometimes feel that such fast releases result in a lot of cost to companies and people working on SQL. All...

pls post the query.

from BOL - " A sort column can include an expression, but when the database is in SQL Server 2005 (90) compatibility mode the expression cannot resolve...

Try to insert the data in small batches if thats possible.

Hi

I do not use any tools , so what i do may not help you. But still... All the schema changes are stored in a folder createad for each date....

Hi

Dont know whthr this will help or not ... what abt putting the open master key statement in a encrypted procedure.

I agree with Steve... Most of us can take a break and come back to our previous levels in a (short) period of time. The main reason i think is...

Seems like you want us to help you in designing tables. My suggestion is that you do a rough design and then post it here. It will give us more...

Hi

U can use sys.databases by joining it with SYS.DM_DB_INDEX_USAGE_STATS on database_id column.