Viewing 15 posts - 31 through 45 (of 243 total)
Tim Riley (1/8/2009)
I know there is, but I can't remember how...How do you go about restoring a database that has a corrupt/bad transaction log?
Please take a tail log og current...
January 16, 2009 at 10:37 pm
sunshine (3/24/2008)
Msg 7314, Level 16, State 1, Line 1
The...
January 16, 2009 at 10:31 pm
gagsam2001 (1/16/2009)
I am facing issue while taking the snap manager backups as the backup drive I've is smaller in size and there are minimal chances of getting more space....
January 16, 2009 at 10:28 pm
iqtedar (1/15/2009)
i see few tables are been dropped from the db..i saw an article on this website..ran the script but there was...
January 16, 2009 at 10:26 pm
kiransuram19 (1/16/2009)
size:14399.06 MB
space available:4652.36 MB
customerdb.mdf : 4.59 GB;
customerdb.ldf : 9.46 GB;
I took backup of the customterDB(using Litespeed)...
January 16, 2009 at 10:25 pm
sunny Brook (1/16/2009)
DBCC INPUTBUFFER(spid) will give you a hint what that spid is running. From there, you may find a clue.
Yes, that i already posted..
January 16, 2009 at 10:21 pm
Grant Fritchey (1/16/2009)
Paresh Prajapati (1/15/2009)
U have to require row level lock with some range of columns..
Really? What happens if you're updating more than one row? What about if you were...
January 16, 2009 at 6:58 am
Abhijit More (1/16/2009)
it's not the problem of open transactions, the user does not have permission to view the table(GRANT)
This is the problem due to some one has the process of...
January 16, 2009 at 6:54 am
Syed Asim Rizvi (1/14/2009)
January 16, 2009 at 2:44 am
sharathsuman.n (1/15/2009)
I am using Linked Server for executing SP's on remote Server. And I have configured SQL Job for executing the remote Server SP on the Server and when I...
January 16, 2009 at 2:43 am
Raghavender (1/16/2009)
we are going to upgrade our SQL Server 2000 to SQL Server 2005.
SQL Server 2000 is a 64-Bit, if we install SQL Server 2005 32-bit version will upgradation...
January 16, 2009 at 1:58 am
foxjazz (1/13/2009)
I need to write a program to determine if any changes were made to these tables.
Option 1, I can write a trigger that sends an...
January 15, 2009 at 11:38 pm
aanryn (1/14/2009)
I'm using SQL Server 2005 Standard Edition. When I open my database and tyr to expand the tables sections on the left hand side of the pane an error...
January 15, 2009 at 11:34 pm
anjali.vishwakarma (1/14/2009)
I am...
January 15, 2009 at 11:30 pm
John (1/10/2009)
When I see a spid blocking, I want to...
January 15, 2009 at 11:25 pm
Viewing 15 posts - 31 through 45 (of 243 total)