best way!

run a server side trace and dump the output into a sql table

truncating the log will remove any inactive entries but not reduce the actual physical file size.

shrinking the log will reduce the physical file size,

but it's worth noting you cannot...

if the browser is running it does yes

i seem to remember, initial contact is made over 1433 then the server passes back the details of the named instance(s) and its ports\IP address

Vista users run as low privelege normally, what does sql authentication produce running the same statement?

Lynn Pettis (12/17/2008)

---

since it needs to create the table on the fly it doesn't know how big the column needs to be so it so it makes it the maximum...

from where exactly?

at the end of the day this is exactly what clustering is designed to protect against so yes its the best way. Fail...

just be sure not to tick the "relay messages to all domains" check box otherwise after a couple of hours your public ip address will be blocked 😉

not at all.

RAID 10 will generally offer a performance boost over RAID1 due to the striping across mirrored sets. As SQL server writes to...

there are some freebiee sql utils but the best bet is either Redgate SQL Backup or Quest Litespeed?

i would say the RAID 10 array is best as it offers the best performance and fault tolerance combined into one package. The downside of RAID 10 is the disk...

sorry god but i'm not the one with the ego problem am i. Also i havent made any obscene comments, i just told you to quit crying like a pair...

VEB (12/24/2008)

---

I have similar situation.

The problem is that the host with SQL Server has Windows Firewall configured. Ports 1434/UDP and the static ports associated with instances are opened in the...

port 2525 is usually used if blocking port 25.

Verify with the exchange admin the listener and outgoing ports?

Is the exchange server on the same network as the sql server?