Duncan Pryde (3/2/2011)

---

Koen Verbeeck (3/2/2011)

---

Thts very true indeed!!!

Ninja's_RGR'us (3/1/2011)

---

SKYBVI (3/1/2011)

---

ChazMan (3/1/2011)

---

I'm still confused about how the page is full. Since data pages are 8K and we are only using 4K, how is that full?

Also, in my...

river1 (3/1/2011)

---

hum...

Or i don't undestand you or you don't understand me 🙂

I will explain again

I have a excel file which , with your help i connected to SQL Server 2005.

I...

ChazMan (3/1/2011)

---

I'm still confused about how the page is full. Since data pages are 8K and we are only using 4K, how is that full?

Also, in my opinion, the...

river1 (3/1/2011)

---

Yes, but there that is not the problem...

The problem is:

I have to create a report through excel to send to the CEO of the company.

He wants...

river1 (3/1/2011)

---

It seems to work but when i pass the Excel to other computer it still shows the connection to SQL Server.

I wanto to extract data , but then want...

open excel, then data, external data, from other sources...choose sql server

and you can select your table or write your query there..

it will put results directly into excel file.

Regards,

Sushant

ISnt htere any option of scripting out all linked servers?

Regards,

Sushant

You can put all the records in the sql server table first, and then select your top 100 or watever resultset you require.

Regards,

Sushant

Why dont you write hte query directly in excel and then get results directly from excel itself.

Regards,

Sushant

Same with me, but i selected...

Koen Verbeeck (3/1/2011)

---

Where do you think they use checkboxes for?

If it was only one correct answer, it would have been...

The question should clearly tell that there are MULTIPLE ANSWERS..

Regards,

Sushant

The transaction log is full..

You have to shrink the transaction log before attempting to again re run the job.

Regards,

Sushant

wen u check on ur AD accounts, the account locked out option is checked ..

Regards,

Sushant