Need to create a user in sql 2005 to run the dashCommerce script.
It wants create table previleges and so forth. What kind of user should I create and what
properties should I give him. So the script can run well.
This step will install the necessary database objects and the base data needed to run dashCommerce. This includes the ASP.NET Membership database objects.
There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005.
The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
Recently, I was involved in a di…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?