Replace 'password' with your password
restore database XXX from disk ='E:\XXX\sonytcamera_1000.bak'
with PASSWORD ='password',
move 'sony1_Data' to 'E:\Data\XXX_Data.MDF',
move 'sony2t_Log' to 'E:\Log\XXX_Log.LDF',
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…
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 …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…