Viewing 15 posts - 151 through 165 (of 198 total)
Make the login user of msdb and grant SQLAgentReader permission.
June 18, 2007 at 12:28 am
Blocking is a manifestation of the logical locks that are needed to maintain the transactional consistency.
When the wait for locks exceed a threshold, it may impact the response time....
June 17, 2007 at 6:54 pm
It sounds like a WMI corruption. You may want to look for the equivalent for Win Vista of this:
Do you have (or did) a sql 2000 installation as well? However,...
June 17, 2007 at 6:27 pm
One way would be to schedule a (sql agent) check - every 2-3 minutes let's say - for the program name the users are connected from. In case the program name...
June 17, 2007 at 6:18 pm
Do you have an error number? It's pretty much unclear why the word "tape" appears into the message body if you backup on disk and then copy the.bak file to...
June 14, 2007 at 12:15 am
June 13, 2007 at 8:20 pm
Few adds on: You cannot modify a db file size to a lower value from the properties screen. TempDB will go to the initial size after restarting the sql server...
June 12, 2007 at 7:02 pm
June 11, 2007 at 11:33 pm
Did you try to fix the report margins in Report properties of report designer? Just save there the actual "A4..." measurements. It worked for me before.
Hope this helps.
June 6, 2007 at 7:26 pm
I'm not sure I understood what you are talking about, but if you don't have any valid login to connect to the sql 2005 instance then you may have to...
June 6, 2007 at 7:02 pm
This is more like an application way of securing the data than a dba action. However, you can use the solution here http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm
Hope this helps.
June 4, 2007 at 7:59 pm
Depending on what data you actualy replicate in you msdb, you would need to run sp_delete_backuphistory.
If it's not the case then just make sure the recovery model is set to full,...
June 4, 2007 at 7:52 pm
If your CPU is often that high then you have to do an emergency analysis at the sql instance level. Firstly monitor blocking issues, then look for excesive compilation/re-compilation, and inefficient...
June 3, 2007 at 5:38 pm
Yes, this can be done through CREATE/ALTER USER statement by assigning / re-assigning a default schema to a user. Don't need to prefix the object name with the user default...
May 30, 2007 at 8:46 pm
Assuming that the log backup1 was taken the same day with the differential one, you are correct about the order (your case sounds much like a MS exam question)
First 3...
May 28, 2007 at 12:04 am
Viewing 15 posts - 151 through 165 (of 198 total)