Please check for the registry privileges in that particular machine for that particular user i hope so the windows account does not have registry access that's why you get a...

just check in your backup jobs for any schedules that are scheduled to occur monthly and 30th of every month by this you can find what is running concurrently.

ask the user to logoff and then login and access the sql server.

whats the size of the database. check your event viewer for any errors in the disk also check for the error log and let us know whats the exact error...

try using locking hints in your update statement so that it locks only for updates and allows select.

Thi solution will surely work for you just try this.

1. Give the users the necessary permissions

2. create a DSN in thier machine with proper database access

3. ask the user...

I hope the script in this link http://www.sqlservercentral.com/scripts/contributions/1598.asp will solve your issue.

Just check this link. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=904828&SiteID=1

Also i would like to know ur parameters that you are using in creating the linked server.

The same tables are used in sql 2005 also. you can query those tables to find the necessary details

script out your sql server login with the object level permissions and use that script to create your new login

just try accessing your access database with opendatasource to see if you get the error in that also if so please send the exact error message

where is your query outputting too. check f ur sql server has permission to write to that path. it must be a permission problem with windows file and folder. check...

whats the amount of RAM in your server. Also check if your server has query timed out option enabled. check SET LOCK_TIMEOUT parameter also.

Hi all

I have solved this problem. The problem was not with SQL Server but was with WINDOWS 2003 DISTRIBUTED TRANSACTION CO-ORDINATOR. It was set to required password more and...