Paul White NZ (4/3/2010)

---

There are lots of possibilities here, so I'm going to take them one by one.

Does the...

bhuvanesh

I think Paul was asking if i had OFF in my query session but NO either in job or query session i am explicitly using " ON "

No, I dont have NULL 's from the query result.

Lynn Pettis (3/23/2010)

---

If the database is using the SIMPLE recovery model, backing up the database periodically isn't going to help. You need to look at the data going in...

may be you update only data right?

Lynn

May be you are missing exec (@SQLCmd); after creating a user.

Lynn I aggree with you, may code has errors.

that was the rough idea i gave to Tara.

Lynn

When you said she has to run code on each server instead can she...

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 is being...

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 exists.",3)

CREATE USER...

That server do not have the capacity to copy all the databases, more over those databases are very big we can not afford to have a copu over there.

Also to...

yes that is the problem you can try to look if there is any chance from any kind of DMV's which give you that information.

Actually here is what i am trying to acheive..

I have PRoduction and Stage Server.

1. Restore production database "Employees" backup onto stage

2. Update stage with latest data

3. Backup stage and restore...

may be i have restore it again.

Can i use a single bak file to restore on 2 servers simultaneously.

ofcourse i am doing that else how can irun it without EXEC command but my doubt is different.

guys i didnt follow what that script id doing, but Tara wants to allows a non sys admin to grant access to windows users for the particular databases where database...