What's your issue?

Lavanyasri (9/2/2011)

---

HI ,

Thanks for quick response.

I googled for this is issue , in some articles saying the pagelife expectancy value should be low .

i searched , but i...

That will be fine .Is there any problem ?

In future post your SQL 2000 questions to sql 2000 forum link.

What will you do if the user login used in connection string?

Don't delete instead disable it. Write query and check it out where are the logins are used it.

Todd Canedy-416047 (8/25/2011)

---

I'm so confused about what to do about this.

I have two table in msdb that are fragmented

sysmaintplan at 95.55% and sysjobhist at 90.54%

From reading online people say...

Post the error details and query too.

Then, post the query and execution plan too. We will help you.

Be careful with “Xp_cmdshell “

I have to mention this also here. We know it’s easily create SQLinjection but, the another problem its removes the whole folder if you forget to...

Jeff Moden (8/17/2011)

---

muthukkumaran Kaliyamoorthy (8/17/2011)

---

I tried to avoid using xp_cmdshell but sometime I can't.

Most of time I used the xp_cmdshell for deleting the old backups because the drive got full...

noeld (10/25/2006)

---

That error is because you are probably connected to a database that has compatibility level set to 8.0 (2000) instead of 9.0 (2005)

Cheers,

<img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile'...

For waht you think its safe. Trace will decrease the server performance.

I tried to avoid using xp_cmdshell but sometime I can't.

Most of time I used the xp_cmdshell for deleting the old backups because the drive got full and apps goes down....

Raghavender (8/17/2011)

---

Hi All,

I have configured a db mail in SQL Server 2005. I am trying to send the mails using that dbmail, but its not sending. What might be the...

Thanks Lowell.