I do understand the what each of the severity levels but my question is related to the behaviour of the application which will be calling the stored procedure .... ...

Very rightly said ... the user under which the sql job executes is a member of sysadmin role ....

so would u recommend creating a proxy account ..... and running...

Thanks guys .. I will keep you updated about my fight for 'Foreign Keys'

Yes I do understand the importance of the foreign keys for maintaining the integrity ................but what the question is that if the system is working without it why do we...

I am a developer who has been given task to develop upon a database with no foreign keys.

currently data will be passed to me from the data layer and...

Thanks Guys !!!! The Posts were really informative as i got to know :

That Foreign key's do effect performace when it comes to inserts / updates / delete's but...

In case the integrity is being maintained somehow. Should i still go ahead add the foreign key relationships or is it unecessary overhead?

I also wish to add that .... Currently error processing is done by checking @@error ..Would it be wise to change it to Try Catch

If you wish to enter an identity you can check it through @@identity which being a global variable will give you the next identity value

Also you can set a default...

I am not sure why is this happening ... and truly speaking i got no clue.

But do a small little check .. Like you connect to the database engine...

Go to Start>Run

Type in "Services.msc"

Check in that for SQL Server Integration services by right clicking it .... Check whether it is running or not

Hope that helps 🙂

Hi !!!

I had 2 suggestions. Please do let me know just in case any of these helps

1) Try using CTE's in place of table...

I am not sure but Can there be a chance where in the execution plan is being cached (earlier scenario ) and being used ... where as in case that...

I think in this case you would have to check the entire dataset as the depth of the hierarchies will have to be decided dynamically ..... If this is the...

But i fail to understand that why do we need to create  a new table if we can just move the existing table to the partition scheme. Cause as u...