if any of your application hold an lock while the rebuild index running on. if no other job creating a problem try to create trace only for deadlock to...

how you have migrate your 2000 server to 2008

have ran the update statistic after your upgrade.

Regards,

Subbu

http://mssqlforum.wordpress.com

if you are changing into simple recovery model and truncate the log , it will break the LSN ,if you have T-Log Scheulde you will not be having the proper...

you can also refer the following to get more details on authentication

http://support.microsoft.com/kb/326985

RAID 1 will give you the better Read performance, however the backup is a write operation it will not give the better performance.

by standard if you have budget you can...

you need to pass the user name through your application to your procedure or to your query to capture them

Regards,

Subbu

http://mssqlforum.wordpress.com

if you add new LUN to windows server it will automatically detect and it wont seek for reboot. however if you are make cluster group dependency on this drive you...

file is under any shared location on the same machine. such as \\localhost\sharename

Regards,

Subbu

http://mssqlforum.wordpress.com

for ex. if you have table called email

create table email (id int ,emailaddress varchar(50))

here you have email address on emailaddress column. please use the below query to show your email...

When you are enforcing a relationship you should have the data on the parent table without that you will not be able to enter data into child table.

for ex. parent...

here the table name should be the Workbook name of your excell file. make sure that you are using the workbook name as [TAble1].

Thanks