Viewing 15 posts - 21,571 through 21,585 (of 26,484 total)
Lowell (4/9/2009)
don't you have to add a USE DATABASENAME command before you add the user, otherwise it would just re-add the user to the existing connected database?
Probably. Work got...
April 9, 2009 at 11:30 am
Steve Jones - Editor (4/9/2009)
GilaMonster (4/9/2009)
There are times I wish I could reach through the computer screen and beat some sense into people...
And having seen the Gilamonster in action, I'm...
April 9, 2009 at 11:26 am
GilaMonster (4/9/2009)
Lynn Pettis (4/9/2009)
And then there are those who really should not be giving advice. The code provided here wouldn't even pass a check in SSMS.Are we really surprised?
Honestly?...
April 9, 2009 at 11:18 am
And yes, I just posted a warning regarding my code and SQL Injection.
April 9, 2009 at 11:15 am
********* 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...
April 9, 2009 at 11:14 am
I think mzak deserves a Gold Star and a big round of applause!
April 9, 2009 at 11:11 am
And then there are those who really should not be giving advice. The code provided here wouldn't even pass a check in SSMS.
April 9, 2009 at 11:07 am
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),
...
April 9, 2009 at 11:04 am
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...
April 9, 2009 at 10:54 am
Are you using the Native SQL Server Backup or a third-party tool?
April 9, 2009 at 10:39 am
Did you check the SQL Server Logs, not the SQL Server Agent Logs.
April 9, 2009 at 10:38 am
Steve Jones - Editor (4/9/2009)
GSquared (4/9/2009)
duh duh duh - duh duh duh duh duh duh ...
I got that right away, hmmm, what does that say about me?
My kids wanted to...
April 9, 2009 at 9:07 am
sward (4/9/2009)
Ok, here it is, the sample code i gave you was a mini replication of what i need to do, the field names and stuff are diffrent but...
April 9, 2009 at 9:03 am
GSquared (4/9/2009)
duh duh duh - duh duh duh duh duh duh ...Hmmmmm ....
Just doesn't seem to work that way.
Here, this'll be better! (Attached)
That was perfect!
April 9, 2009 at 8:41 am
RBarryYoung (4/8/2009)
EdVassie (4/8/2009)
This would show to new users to SQLServerCentral that advice given by an MVP is potentially correct and they should take notice of what is said.
Heh....
April 9, 2009 at 6:51 am
Viewing 15 posts - 21,571 through 21,585 (of 26,484 total)