Thanks for the help and correction.

What about using update trigger for this purpose?

Regards

It also seems working efficient, i would compare the efficiency of both suggestions.

Thanks and Regards

Thanks for your help, its working well.

Regards

Thanks for reply, Moden. Actually this example UDF was to convey my problem. I was looking to create some UDFs for various tasks and was required to use dynamic sql...

Thanks for tip, I also tried this approach before but here i face limitation of UDF with following error

Msg 557, Level 16, State 2, Line 1

Only functions and extended...

Every table has at least one partitioned defined. I have noticed that following script provides number of partitions for a table equal to number of indexes defined in that particular...

Partition functions and schemes are implemented for partitioning and any new table created with file groups on that scheme will be with required partitioning criteria implemented. The only question is...

Along with technical details, most important step is through testing of your application flow and T-SQL code with upgraded database server in test environment.

Regards

Thanks a lot PS for this help. It is...

I looked these in BOL but there was problem to combine use these.

this query will simply return all start dates for an employee. And there will be records for each...

Thanks for your help. problem is solved by update of SP. After many repetitive installations on my test server, i lost track of SP.

Thanks

sorry that i paste here the error message of my modified trigger. Related error message for BOL trigger (that i mentioned in code) is

Msg 1084, Level 15, State 1,...

Thanks for ur reply.