Viewing 15 posts - 541 through 555 (of 1,161 total)
Data/Log files missing or inaccessible
October 19, 2010 at 9:30 am
If you are on the Server Instance and trying to restore, then you will get the drives on the server.
If you are on the Local Instance (your system) and trying...
October 19, 2010 at 9:28 am
Restoring from the last transaction log backup is an option
October 19, 2010 at 5:23 am
To confirm, is the SQL Server startup account is part of local administrators group on the server?
October 18, 2010 at 11:10 pm
What is the query that you are using to access the tables in Access database?
October 18, 2010 at 11:07 pm
You need not stop the service which connects to the database whose index is being rebuilt offline. However during offline reindex locks will be held on the object and any...
October 18, 2010 at 10:58 pm
This article explains the minimum privileges required for a SQL Server service account.
October 18, 2010 at 10:53 pm
Agree with SteveB. Running a profiler trace is an overhead on the instance, instead you may run server side traces. Since you want to capture object creation details, it is...
October 18, 2010 at 10:48 pm
QotD on this site has plenty of them. Here is the link.
October 18, 2010 at 1:15 pm
Try adding the Linked Server using the below query.
EXEC sp_addlinkedserver 'RemoteServer\InstanceName', 'FALSE', 'locallogin','remotelogin','remotepassword'
GO
October 9, 2010 at 4:37 am
Please ensure that the subfolders of the Installation folder are properly named. Read more on this here
October 9, 2010 at 4:17 am
Check if there are any blocking processes using the below query
SELECT session_id, blocking_session_id FROM Sys.dm_exec_requests where blocking_session_id <> 0
October 9, 2010 at 4:03 am
Please don't cross post. All responses at http://www.sqlservercentral.com/Forums/Topic1001644-338-1.aspx
October 8, 2010 at 10:43 pm
You may make use of fn_get_sql function. More information here
October 8, 2010 at 10:42 pm
You can manually type the owner name into the Owner textbox or use the ... button to browse and select it
October 8, 2010 at 2:30 pm
Viewing 15 posts - 541 through 555 (of 1,161 total)