I have a website which uses a SQL Server database (version 7 I think).
I have two database files a 'mdf' and a 'ldf'.
This is the asp code that connects to it
Application("Conn_ConnectionString") = "DSN=km" 'local
sql = "SELECT * FROM AdminUser"
set rsPass = server.CreateObject("adodb.recordset")
rsPass.Open sql, Application("Conn_ConnectionString")
I have only ever used MS Access databases in the past so im not sure where to start.
What software do I need to install?
How do I setup the DSN connection - Is it the same as MS Access?
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed