MS Access 2010/2007 database to manage SQL Server scripts

Submitted by: 
Language: 
Visitors have accessed this post 11170 times.

This application allows the user to manage SQL Server scripts. It also allows the user to place SQL Server .SQL scripts in a "Run Once" Windows folder or in a general "Run Whenever" Windows folder.

The scripts can be prioritized so they run in a specific order, if necessary.

The program works with Windows Logon as well as SQL Server Logon.

The code was written using MS Access 2010 but I tested it using MS Access 2007 and it seems to work as well. I did not do an exhausting test in MS Access 2007.

There is another program called TextMaker Viewer 2010 that should be installed. It allows the user to view the Log Files from the program. The log files are created in Windows Folders. You can get it at http://www.officeviewers.com/. This is a FREE program.

Uncheck ALL associations so this program does not become the main program to view them unless you want it to be.

I would have included it in the zip file but then the file would exceed the 2 MB limit.

There is a user document file included in the zip file.


Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

How to start MySQL can u refer the book name in near future?

ii

Donk90 says.....
Enjoy Codeeeeeeeennnnnn............

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.