Viewing 15 posts - 736 through 750 (of 2,897 total)
e4d4 (3/2/2013)
Information about drop or detach db you can find in the SQL Server Default Trace.
But don't wait too long to look because it gets overwritten.
I set up my own...
March 2, 2013 at 1:36 pm
PIVOT Function ?
http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx
March 1, 2013 at 9:29 am
It might be more effective to start a new thread in the 2008 forum instead of dig up an old 2005 thread.
March 1, 2013 at 8:58 am
Maybe a version mis-match between Management Studio and the installed version of SQL ?
February 28, 2013 at 7:16 pm
tmeyer1969 31535 (2/28/2013)
On the plus side, after doing it 1000 times, you just won't care 😉
True. We had a PCI requirement to apply patches & reboot 15 servers every month...
February 28, 2013 at 9:43 am
Some 3rd party tools allow you to restore to a server that does not have a license. The license is just required for making the backup. I also remember that...
February 28, 2013 at 8:21 am
Reading Lynn's article reminded me that sometimes I am concerned about t-log growth, so then I add a second counter to take a t-log backup every X deletes.
February 27, 2013 at 6:40 pm
insanityflyff (2/27/2013)
and about the loop thing i dont know how to write it ...
DeleteMore:
waitfor delay 5 seconds (to give others some cpu)
delete top 10000 from tableA where ......
if @@rowcount >...
February 27, 2013 at 6:32 pm
In general, when I have a lot of rows to delete, I do it in a loop with a "wait". The advantages for me are:
Small chunks so I can...
February 27, 2013 at 2:46 pm
BuntyBoy (2/27/2013)
we are not facing any issues... So I believe it should be fine as long as you know what you are doing...
Big problem there ! :blush:
February 27, 2013 at 2:37 pm
" ... Exclusive access could not be obtained because the database is in use ..."
Someone has an open connection to the database.
You can use Activity Monitor or sp_who2 to identify...
February 22, 2013 at 10:49 am
Since I am often the confused person asking questions, when I finally get to help, I sometimes give extra info "just in case".
February 21, 2013 at 3:02 pm
opc.three (2/21/2013)
midnight251 (2/21/2013)
Interesting. I didn't know you could take it down that far and only restore certain data to certain tables.
You can't restore data for specific tables without the...
February 21, 2013 at 1:39 pm
Regardless of your current problem, if 'Aquapak_Live_app' database is a critical database, then you most likely should have it in FULL recovery, and take regular trans log backups so you...
February 21, 2013 at 11:10 am
Something like this ?? :
February 21, 2013 at 10:36 am
Viewing 15 posts - 736 through 750 (of 2,897 total)