this errors comes usually if the file is opened While running the bulk insert command.

SQL server is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those...

is your database in suspect status?

Which version of sql server that you are using ?

Have you double checked that there is no processes is curently using your database.

Select * from sys.sysprocesses where dbid=db_id('dbname') ---- run this and check.

There is nice script in below link.

http://stackoverflow.com/questions/869315/invalid-object-name-error-when-trying-to-execute-stored-procedure

http://www.sqlserver-training.com/sql-server-2008-clustering-enhancements/-

Use this.

EXECUTE AS USER = 'Wanida'; -- User name

SELECT * FROM fn_my_permissions('HumanResources.Employee', 'OBJECT')

ORDER BY subentity_name, permission_name ;

REVERT;

GO

more details.

http://www.mssqltips.com/sqlservertip/1440/script-to-determine-permissions-in-sql-server-2005/

Check this.

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/d9d68385-2886-4b31-b92b-c2704da763fe

nice article!!!

are you still seeing same?

http://blog.sqlauthority.com/2009/05/10/sql-server-10-reasons-for-database-outsourcing/

timeout error comes at any specific time? or it comes certain event like report extraction or any other. ?

if so try to figure our what exactly the requets are...

Try using this in your query.

SELECT * FROM tablenae WHERE DATEPART(dw, datecolumn) IN (1, 7);