One question.. is there an existing script that we can use to automatically resize the excel cells and automatically put a border to an excel file so that when i...

Wow!!!!! great article Phil this is very informative.. I will try to learn this I think my question will be answered in this article thanks..

Edogg (12/19/2007)

---

If you want to size you data files the same across 3 drives for optimal I/O. You can create a new database with the same name as your old...

Hi thanks for the reply i did that to install the dll in the server BINN I've spotted the problem. The problem is that our mail server disabled SMTP so...

Thanks for the answer EdVassie... 🙂

We ALMOST have exactly the same problem mine is that i have 2 mdf and 2 ldf and after transferring the database it must be 1 mdf and 1 ldf...

Hi.. I ran this command to disable xp_cmdshell in MSSQL 2000

-- To allow advanced options to be changed.

EXEC sp_configure 'show advanced options', 1

GO

-- To update the currently configured value for...

(Take A Deep Breath) Thanks MarkusB 😀 I'll be transferring today at 11:00 AM wish me luck 😎

Here you go sir.... Run this script on your source database and then copy the result of this script and run in the destination database. I did not include the...

Thanks.. So you mean QA is more reliable in terms of transferring data than using DTS??? It is more reliable to creata all the tables then use a script...

Thanks Markus what is more reliable the EM or QA?? The reason why i am asking is that We have a Server with 2 mdf and 2 ldf and we...

Thanks for the quick answer guys. The first thing comes into my mind is dettaching the database then put the mdf and ldf to the other drive then attaching it...

Once you set your transaction log to Full Recovery Your transaction log will not shrink automatically. If you want it that way you must choose Simple Mode but like Nikolay...

Wow very nice information but i cant send messages using our local mailserver (MS Outlook). Is there anything i should configure to work with this xp_smtp_sendmail??

Thanks for the response..

#2 Do i need to create another user? Or can i change the owner to dbo resulting to 2 Table1 with same dbo owner? i dont think...