Anamika (2/16/2010)

---

Hi,

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...

keyun (2/15/2010)

---

Muthukumaran,

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...

keyun (2/13/2010)

---

I have read about 50+ post on this website but not able to find the answer that I am looking for.

here is the issue: I have read only...

Ur Welcome 🙂

Answer is NO.

CheckDB is Checks the logical and physical integrity of all the objects in...

Shivrudra (2/15/2010)

---

Hi,

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...

mstephens1754 (2/15/2010)

---

Guys I would like to know how do you determine what actions a database performs? For exampe, I would like to be able to determine if a...

macherla.harish (2/12/2010)

---

HI Muthu ,

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...

sanya.bandaru 52584 (2/8/2010)

---

I have database in production Server which replication(transaction replication) is in use. The transaction log was set to restricted mode to 20GB. some transaction are going on that...

*vivian* (2/8/2010)

---

The server OS version is windows server 2003 standard edition, I see currently the server has 1.5GB avaliable memeory, so should be ok if enable /3gb? coz we may...

*vivian* (2/8/2010)

---

Hi MUTHUKKUMARAN, thank you so much for your great help. I accquire a lot from your post.

However We may not be able to upgrade the software in short...

Read the Gail's article and post back the Execution plan once.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

1.What is the database size?

-- 109GB

2.Are you feel slowness always...

*vivian* (2/8/2010)

---

Thanks so much for your reply. I just had a look at the query plan for 2 queries and didn't see table scan, most are the index scan or...

*vivian* (2/8/2010)

---

Dear All,

Thanks in advance for your help:-)

We have a SQL Server 2005 standard server,

server RAM is 4GB, and SQL Server is configured with Minimum server memory: 2000MB, Maximum...