I am sorry but maybe i was not clear enough in my question..

I have about 72 dept tables and each table has 50,000 + records.

I need to create a...

Thank you so much..for all of your help. i finally got it to work. i finally got what i needed.. i am new to this so everyones input helped a...

Sugesh,

I am trying to use your way to get this done. We have to send emails every time we run the job and there is an update. I can...

Thanks for all the replies. i will further look into output. I was also thinking of doing another job that can run right before the update and give me the...

Hey Lucky,

Thanks for the reply, i can not do a trigger on the table because there are updates going on in the table all the time. and this is...

This worked!!.. Thank you so much, saved me a couple of hours, I am new to SQL so learned something very helpful today.. thanks alot

Thank you very much for ur explaination

Thank you for your help. The code worked but could you please tell me what the CHAR(13) + CHAR(10) are used for and can the length of the fields be...

Thank you for your help.

This a third party application, so nothing can be changed and they create a new table in the yyyymm format everymonth but if the application hangs...

I can create a view using a variable below..

declare @newname varchar(60), @sql nvarchar(1500)

set @newname = 'Checks' + CONVERT(VARCHAR, DATEPART(YEAR, GETDATE())) + '_1'

set @sql = 'CREATE View testview AS

select...

Cory Ellingson (11/6/2007)

---

declare @newfilegroup varchar(60)

set @newfilegroup = substring(CONVERT(VARCHAR, DATEPART(YEAR, GETDATE())), 3, 4)

EXEC ('ALTER DATABASE northwind ADD FILEGROUP [' + @newfilegroup + ']')

It needs to be wrapped in the [...

Thankyou so much!

yes.. maybe but the thing is that right now they are created manually as yearlys like 07, 08 that works fine..

filegorup names can start with number.. right now they are manually created as 07, 08 and so on..

Thankyou for your help.. i tried using dynamic sql for creating a filegroup as a task in the beginning of the package but that is giving me an error now..could...