Viewing 15 posts - 1 through 15 (of 32 total)
Create a trace and run it during the time you need to find out.
capture SQL depepnding upon the duration from the trace and run into SQL Analyser for execution plan.
January 21, 2010 at 2:35 am
When you take Log backup the unwritten transactions are written to the disk and your log file will reduce after the backup completes so you may experience the large log...
February 17, 2009 at 4:38 am
If you need to gather specific information of user over specific time best option would be create and run a trace.otherewise you could follow the previous post.
February 17, 2009 at 4:33 am
Windows XP wont allow to install SQL Server Ent edition
February 17, 2009 at 4:30 am
In activity monitor you have a cloumn status which would says runnable this means the user is active at present and doing some action.
February 17, 2009 at 4:16 am
There are two SP map_login and sp_sidmap which can be downloaded form microsoft website.
February 17, 2009 at 4:13 am
Try droping and recreating indexes.
February 17, 2009 at 3:55 am
You can work in 2005 management studio >Management>Activity Monitor and in 2000 Management>current activity >Processinfo.
also you can use sp_who
February 17, 2009 at 3:48 am
After executing Exec XP_MSver you will get 20 rows in result
Checkbelow X86 that means it is 32 bit or if it show X64 then it is 64 bit.
February 17, 2009 at 3:44 am
SET quer time out value higher than default.
February 11, 2009 at 6:42 am
Check whether you have selected Local and remote connections, or Local connections only in surface area configuration
February 11, 2009 at 6:35 am
Try Restart the services.
February 11, 2009 at 6:21 am
This will help you.
February 11, 2009 at 6:17 am
The error message occurred due to incomplete sequence of log backups.there may be some log backups that had generated after you took the full backup.Please check the backuphistory system table...
February 11, 2009 at 6:10 am
If you add one more file log shipping wil be uneffected.
August 27, 2008 at 6:25 am