Viewing 15 posts - 541 through 555 (of 1,157 total)
Data/Log files missing or inaccessible
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 19, 2010 at 9:28 am
Restoring from the last transaction log backup is an option
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 19, 2010 at 5:23 am
To confirm, is the SQL Server startup account is part of local administrators group on the server?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 18, 2010 at 11:10 pm
What is the query that you are using to access the tables in Access database?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 18, 2010 at 10:58 pm
This article explains the minimum privileges required for a SQL Server service account.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 18, 2010 at 10:48 pm
QotD on this site has plenty of them. Here is the link.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 9, 2010 at 4:37 am
Please ensure that the subfolders of the Installation folder are properly named. Read more on this here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 9, 2010 at 4:03 am
Please don't cross post. All responses at http://www.sqlservercentral.com/Forums/Topic1001644-338-1.aspx
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 8, 2010 at 10:43 pm
You may make use of fn_get_sql function. More information here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 8, 2010 at 2:30 pm
Viewing 15 posts - 541 through 555 (of 1,157 total)