SQL Server Security

Let say i have a shopping cart and i store all the CC info in a .MDB on a secure server, so all the transaction between my asp and my db on the secure server is secure cuz it's all under the same server !

But, what if i store my info in a SQL Server DB from my Secure Server, is that secure ?

yes of course it is, if you set permissions and users up correctly SQL Server is very secure.

Im assuming by secure you mean the asp pages are using SSL. I would also recommend encrypting the credit card numbers into the database for extra protection.