creating SQL Server 2005 database from powershell function

• mcginn

  SSCommitted

  Points: 1592

  More actions

  December 8, 2009 at 9:58 am

  #218332

  I misposted this topic in the SQL Server development forum before I knew this forum existed.

  I have developed a powershell script to install databases and database objects (procedures, functions, etc). The script allows the user to pass in a directory and request that the database be created at that location. What I want to do is validate that the user has permissions to create the database at that location. I have checks that validate the passed location is a directory, but I can not figure out to validate that SQL Server is allowed to created the database files in the requested file system location.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 20, 2010 at 8:13 pm

  #1122410

  The following articles describe how to create a Database using Powershell:

  http://arcware.net/creating-a-sql-server-database-from-powershell/

  http://sqlblog.com/blogs/allen_white/archive/2008/04/28/create-database-from-powershell.aspx

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/