nmalepati (5/11/2010)

---

Hello All,

I have a table that has data in below format:

UserID PackageID ...

imran_ghainsh (5/14/2010)

---

I made a Stored Procedure as Process with Table Index but when I Executed it on my Local PC it takes 50 Second for 27000 Records Process but while...

bengchoo.kuah (5/12/2010)

---

Hi, we need to migrate our Production server from MSSQL 2000 to MSSQL 2005.

This has to be done on the same server itself. Can anyone advise what is the...

bobby.creech (3/26/2010)

---

ok, I've got a report on the report server that gets clients by state, either individual or all. very simple report, client name and state.

they would like this...

sananthakumar (4/13/2010)

---

I am using Sp_Send_DbMail to send the mails. Everything works fine. But When we try to change the from address from code it wont allow and also through the...

To run xp_fixeddrives , you have require system admin rights.

vinayak_mohan (8/12/2009)

---

Hello guys,

The Stored procedure "xp_fixeddrives" will give you the free space on the disk. Is there any other sp which...

Yes, i have read all the difference.

As per Loop join have more and cpu cycle i think, Am i right?

I require urgently ....

we have compare two databases both are same on both servers.

SQAPro (2/11/2009)

---

Paresh Prajapati (2/11/2009)

---

SQAPro (2/11/2009)

---

That's not a 'valid' IP, it's one of the ones that is reserved for special or future uses..

http://www.iana.org/assignments/ipv4-address-space/

You sometimes see that IP used by...

Erode P. Satheesh (2/10/2009)

---

Thanks Paresh Prajapati. I checked only in sys.sysobjects before posting :rolleyes:.

Thanks GSquared, I will consider using DDL Triggers. Can you help me with best practice documents?

Thanks for...

SQAPro (2/11/2009)

---

That's not a 'valid' IP, it's one of the ones that is reserved for special or future uses..

http://www.iana.org/assignments/ipv4-address-space/

You sometimes see that IP used by trojans or botnets...

SQAPro (2/10/2009)

---

Paresh Prajapati (2/10/2009)

---

Only I know that...

-- Tables

select * from sys.objects where type =...

Only I know that from Network people...