Hi Roger,

Yes, You need to have a profile and outlook installed on server where you send the email from. Also you can use DTS to send the email.

That is how...

Hello,

I am using SQL DTSBackup 2000, it is working fine at our IT Department. You can download it from the following location.

http://www.sqldts.com/default.aspx?242

Thank you everyone.

Leo

Hello,

Thanks for two of your suggestion. I tried with 1 cluster index and 1 normal index(which contain 6 fields in it), that make it bit faster. But it didn't show...

Sorted. Thanks.

Leo

Hi John,

I am currently using SP4 on our production sql 2000 servers. Main reason for using SP4 is to fix the memory leak on DTS Packages.

To upgrade to sql...

Hi Grant,

I have a couple of questions here,

1. What about detach the database in 2000 and reattach in 2008? It should be okay, isn't it?

2. About the Upgrade Advisor,...

Hi Guys,

According from the Q&A No. 2. Do we need to set compatibility Mode to 2000 first before attach the database then change compatibility mode to 2008 after attached the...

Hi,

I am fully recommend what EdVassie saying. I have done the some thing in SQL 2005 when I migrate my DTS packages from SQL 2000. Because migrate to SSIS package...

Hi Gift,

Thanks.

Leo

Hi Gift,

What do you mean SQL Remote Mode and Local Mode? i.e Remote Mode and Local Mode is already included in SQL Server when you buy it from Microsoft, isn't...

That website is quite useful. Thanks.

I have a few question to ask.

Can we create 'rdl' report file in VS2005 report viewer control without having SQL Reporting Service?

What is the...

Why RAID 5 need minimum of 3 drives?

I have checked my drive -

Disk 0 - Normal HDD with Win Server installed

Disk 1 -Promise Tech I20 RAID D SCSI DISK (690GB...

Anywhere can I find the software to check the Disk Config [eg. Raid 1, Raid 5, etc..] on the internet? So that I will know what config of HDD I...

Hi Perry,

I have similar situation at work. My IT guys build a Test Server for SQL 2005 and he said that we have 2 400GB x RAID 5 drives to...