Joel Greijer

Follow this post (Follow Ogauthier, not christo) http://forums.silverlight.net/forums/p/187247/430038.aspx Remember to disable anonymous and enable windows auth in IIS

To enable SqlCmd in Management Studio, select: Query / SQLCMD Mode Management studio willl replace variables before these are sent to the Sql server :setvar DbName DevDb go create procedure dbo.GetPersonsFromAnotherDb as select * from $(DbName).dbo.Person print '$(DbName)' go /* Procedure will be created like: ALTER procedure [dbo].[GetPersonsFromAnotherDb] as select * from DevDb.dbo.Person print 'DevDb' */ To execute parameterized from sqlcmd.exe file.sql containts the following: print '$(DbName) was used as input' Execute file: sqlcmd -E -S . -i file.sql -v DbName=TstDb Output: TstDb was used as input