Single Proc? Dual Proc? Quad Proc? Single Core? HyperThreaded? Dual Core? Quad Core?

Disk subsystems? Are they then same/similar?

Nope. Permission issue.

Any help on that thread would be welcome. Based on further information from the OP, I'm thinking something written using SMO may be a better option than a stored...

This may take more work. Even under a privledged account, I get an error with the CREATE DATABASE part of the stored proc.

Don't give up hope yet. If...

Mike Levan (4/9/2009)

---

I think Tara wants to check dbname from 4 different servers and more over she dont need to give create command, she can directly create database as it...

Probably. Work got...

Steve Jones - Editor (4/9/2009)

---

And having seen the Gilamonster in action, I'm...

Honestly?...

And yes, I just posted a warning regarding my code and SQL Injection.

********* WARNING ***********

A quick aside regarding my code. It needs more work. Currently it is wide open to SQL Injection. This would be a good opportunity for...

I think mzak deserves a Gold Star and a big round of applause!

And then there are those who really should not be giving advice. The code provided here wouldn't even pass a check in SSMS.

The only thing I haven't done yet is actually test the procedure, but the following code will actually create the procedure.

CREATE PROCEDURE dbo.CreateNewClientDatabase (

@DBName varchar (128),

...

Mike Levan (4/9/2009)

---

CREATE PROCEDURE CreateNewClientDatabase

@DBName varchar (128),

@Username varchar (30)

WITH EXECUTE AS 'dbo'

AS

if not exists(select dbid from master.sysdatabases where name = @DBName)

CREATE DATABASE @DBName

print 'Database @DBName Created'

else

raiserror("Database already...

Are you using the Native SQL Server Backup or a third-party tool?