Viewing 15 posts - 676 through 690 (of 859 total)
sanketahir1985 (2/16/2010)
try sp_who4 active SP
What is sp_who4 ?:-)
February 16, 2010 at 6:03 am
Anamika (2/16/2010)
I'm working in sql server 2005 SP3.
my server has 2 GB RAM and DB size is 200 GB HDD is 465GB.
when testing is going on, the entire memory gets...
February 16, 2010 at 5:17 am
keyun (2/15/2010)
Here are the errors that i have received so far.
Error # 1
Message
Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'MySystem_NT\ServerB$'. [SQLSTATE 28000] (Error 18456). The step failed.
Then...
February 16, 2010 at 12:45 am
keyun (2/13/2010)
here is the issue: I have read only...
February 15, 2010 at 7:27 am
Shivrudra (2/15/2010)
Thanks.....
Ur Welcome 🙂
February 15, 2010 at 7:19 am
Shivrudra (2/15/2010)
yes I fired UdateUsagesand it is successfull.is Dbcc CheckdB atomaticaly update stats or not
Answer is NO.
CheckDB is Checks the logical and physical integrity of all the objects in...
February 15, 2010 at 7:17 am
Shivrudra (2/15/2010)
I have migrated SQL server 2000 Database to SQL server 2008 successfully then i checked consistancy of database by DBCC checkdb
now i like to know whether it is necessary...
February 15, 2010 at 6:42 am
mstephens1754 (2/15/2010)
February 15, 2010 at 6:23 am
macherla.harish (2/12/2010)
Good script given.
HI muthu, i have a Dought in Sqlserver2000 , IN sqlserver 2005 Copy_only option is there But In sql server2000 not there if hava log...
February 13, 2010 at 3:38 am
sanya.bandaru 52584 (2/8/2010)
February 9, 2010 at 3:47 am
*vivian* (2/8/2010)
February 8, 2010 at 10:03 pm
*vivian* (2/8/2010)
However We may not be able to upgrade the software in short...
February 8, 2010 at 10:42 am
*vivian* (2/8/2010)
Hi, I attached 2 query plans for 2 of the slow queries, thanks again :--)
Read the Gail's article and post back the Execution plan once.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2010 at 6:06 am
*vivian* (2/8/2010)
Hi muthukkumaran, thanks a lot for taking your time on this, really appreciated. Below is my update to your queries:
1.What is the database size?
-- 109GB
2.Are you feel slowness always...
February 8, 2010 at 6:03 am
*vivian* (2/8/2010)
February 8, 2010 at 5:05 am
Viewing 15 posts - 676 through 690 (of 859 total)