On SQL Server there are many activities concurrently run and the execution time for any SQL depends upon the Load at that time on your server this may be only...

I also Got the same error while doing the configuration settig for SSRS virtual Directory.

I can acess the report manager with http://localhost/reports but If I try the server...

no need to put the columns for default value . It takes care by sql server.

Alkesh Khedle

Right SSCCHASING. We can have very good options like Readcommited Snapshot Isolation level that will work on process level and Snapshot Isolation level work on transaction level with the concept...

I am agree with your view that sm update statements might be present in the batch that will create the deadlock condition but why with nolock on each table in...

Hi Barry thanks for the solution .

Can u plz tell me how to call these function in sql server. I never called SMO's in SQL Server yet.Is that required...

Hello Gail,

U r absoulately correct about putting Nolock every where is not the best way to...

Hi

I Tried to use CLR UDF to achive the same but I didnt get the result .

Can I get the proper name and the procedure to use call...

Hi I am getting same error even using with nolock in select query???