not sure exactly what you mean but you'd have to ask your administrator which server hosts mail on your network. Test connectivity by Telnet to port 25

or just launch the sql2005 installer and select the sample databases option from the install selection!

RAID 5 employs striping with parity !!

run the traces server side then you'll have no worries 😉

LOOKUP_BI (10/17/2008)

I need to schedule a sql trace on Profiler.I see a stop time but no start time.Accordin to msdn I can schedule a Trace by the SQL Profiler GUI...

i could be wrong and let me know if i'm way off but it sounds to me like you have moved the database to a new server...

a 2000 character varchar field is certainly going to allow some undesirable isnt it :discuss:

think about it and this is painfully obvious 😉

if using a correlated subquery for checkinga condition\item i prefer EXISTS. I've always been under the impression this should be faster than IN. Am i way off base here?

this is only true for the system databases. I use detach and restore all the time. When attaching the...

out of the 2 i prefer Redgate SQL Backup!

the date and time shown above is 10PM not AM (22:47).

what you are seeing is the installed date and time i believe

you would have to restore

stuff.mdf

stuff.ldf

then create the extra filegroups\files and move objects from the primary file\group to the new files\groups

no application user account should need to connect using 'sa', especially a web user account. Assigning 'sa', this is all too common...

SBS comes with SQL server built in