Are you using any third party tool to take backup?

dbapt605 (2/17/2012)

---

Is it possible to insert a large number of records into a fairly big table, and not have SQL Server lock the entire table against updates or other smaller...

both are totally different, Drop removes the object from database and truncate just deallocates the data pages but retains the definition.

clearing in the sense what truncate or delete? and it wont allow to clear while other users are accessing the table simultaneously.

thanks, this is very useful in training program.

Check this

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/61550/

Try to recall all possible password because there is no other way in sql to find out the passord.. else contact some third party tool to recover the pswd.

Have a look on this article.

http://www.mssqltips.com/sqlservertip/1590/understanding-and-dealing-with-orphaned-users-in-a-sql-server-database/

Here is example:

http://msdn.microsoft.com/en-us/library/cc627464.aspx

Is this full error message? try with restoring the trn file manually and check if you get any error message.

Check this article for more details.

http://www.sqldbops.com/2010/05/token-based-server-access-validation.html

This is a login failure error. your windows login might not be added in Sql server login. as this is windows 2008 server try to open SSMS with run as...

Please provide your query execution plan for better analysis.

I never seen this type of difference by changing the resultset view.

which report you are fatching first txt or grid ?

try to find host name of correspinding session_id in below dmv

sys.dm_exec_connections, sys.dm_exec_sessions