Hi Lynn

Sorry, I did not answer your question.

The reason I looked for is as below

1. I need to perform certain validation on database if it is called

...

Hi All

Thankyou verymuch for the solutoins.

I tried using @@Nestlevel and it looks good to me

I implemented the same and tested as well.

Thanks a lot

I can now...

Before answering

What is the primary key of your table?

Is that user defined... or generated by any user defined function?

If So,

You may have to use the...

I remember the procedure EXEC dbo.sp_sendmail.

However, the feature needs to be turned on by the system administrator.

1. There should not be any then , endif... etc

2. You miss set

IF @asofdate = @priormonthdate and TimClosestatus = 'C'

BEGIN

SET @asofdate = CONVERT(char(10), DATEADD(day, - (1...

Use Red Gate's SQL Compare

You can compare Both Schema and Data as well

Worth in ivesting..

I am not sure if any information_schema maintain the last modified data for each database.

However, you can verify the timestamp on the following files of each database and sort...

The Best way to handle this is..

Instead of storing the value as column in table

Write a Function which will return the contribution percentage

example F_GET_COUNTRY_CONTRIBUTION ( country_name, Year)

By passing...

Hi

You can reset the identity to a defined value using following command

DBCC checkident (tablex, reseed, N)

where tablex - replace your able name

N - the number you want...

The Stright forward statement is

WHERE CancelFlag = 'False' or CancelFlag IS NULL

The bit datatype allows you to compare the column with value 'True' or 'False'

Venkat