If isolation level is read committed and you are not using any query hint then SELECT statement would be blocked by the UPDATE statement. You can see the blocking using...

Hi Daniel,

A very informative and well written article indeed. Just wanted to know if lack of JAVA knowledge proved to be an impediment in exploring and learning hadoop. Additionaly, could...

If mirroring had been configured for synchronous mode then mirror would already be in synch with principal. Any in-flight transactions will obviously not make it to the mirror.

In that case "transaction log full" error should not come. Please check file auto growth settings for log file again

Looks like log file has filled up the entire disk on which it is hosted. Try adding a new log file on a different drive and then try taking a...

[font="Verdana"]Yes you can run all insertions in parallel. Be sure to drop all indexes on the table before running the import and recreate them afterwards[/font]

You can use UPDATE() or COLUMNS_UPDATED() trigger functions to accomplish this. Refer to BOL for further details.

RESTORE VERIFYONLY will detect most of the errors but not all of them. It is a good idea to restore your backups frequently to check their validity.

First of all find out the service account, SQL server is running under. You can find it out from Services Applet in windows or from SQL Server configuration manager.

Then...

Hi Guys,

I found a way to get around this problem. I was also facing the same issue after changing the column size of a table.If you try to change the...

Hi

U will find sql server licensing inside control panel

Hi,

stop the mssqlserver servoce from controlpanel-administrative tools- services.After that start the sql server service normally.I think you should be able to get access

Hi Rudy,

I suppose the problem is due to some missing dll on which the xplog70.dll depends.Will it be resolved by reinstalling the EM??

Thanks

when you try to copy back the data to original table, the error will be thrown up because select into creates the destination table on the fly.The correct way to...

Thanks for your reply but i do not need TOP 5 per date.I only need the TOP 5 distinct values for c_id with the records arranged in descending order of...