Batch Processing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Batch Processing

Batch Processing

Rate Topic

Display Mode

Topic Options

Author

Message

NightCrawler

Posted Wednesday, November 26, 2008 10:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 27, 2008 8:33 AM
Points: 6, Visits: 49

"
EXEC dbo.sp_delete_backup @database_name = M'{0}'
GO
USE [master]
GO
ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [{0}] SET SINGLE_USER
GO
USE [master]
GO
DROP DATABASE [{0}]
GO
"

Above is the script i use to delete the database{0}. Now i need to update {0} to another database called "DateAgain".

Please provide a script to update. Thanks in advance

Post #609319

Tim Mitchell

Posted Wednesday, November 26, 2008 5:32 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:11 PM
Points: 1,033, Visits: 2,593

You'll need to provide some more information about what you are trying to do, your environment, etc.

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
twitter.com/Tim_Mitchell

Post #609514

RBarryYoung

Posted Wednesday, November 26, 2008 7:50 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Specifically, you need to explain what "i need to update {0} to another database' means, because it makes no sense.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #609531

Lynn Pettis

Posted Wednesday, November 26, 2008 8:44 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 21,599, Visits: 27,419

Could it be he is trying to drop multiple databases? Only the OP knows for sure.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #609539

Tim Mitchell

Posted Wednesday, November 26, 2008 8:46 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:11 PM
Points: 1,033, Visits: 2,593

That's how I interpreted his post. That could go wrong in a hurry.

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
twitter.com/Tim_Mitchell

Post #609540

RBarryYoung

Posted Wednesday, November 26, 2008 9:43 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Hmm, that's an angle I hadn't thought of. Still, I'd like some clarification from the OP.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #609554

Lynn Pettis

Posted Wednesday, November 26, 2008 9:45 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 21,599, Visits: 27,419

Actually, I think that is what we are all waiting for.

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #609555

NightCrawler

Posted Thursday, November 27, 2008 7:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 27, 2008 8:33 AM
Points: 6, Visits: 49

I am really sorry for the delay.

Environment is... everyday a set of databases are created(sales business). i.e. at the end of the day I have to delete these databases(ofcourse after saving to other disc) For that I am using the above mentioned script. Apart from this, I have to update these databases in another database name"DateAgain".

I apologize for the confusion. This is the new task given to me. And I am completely confused from my task point of view.

Post #609805

Tim Mitchell

Posted Thursday, November 27, 2008 8:30 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:11 PM
Points: 1,033, Visits: 2,593

Are the database names always the same from one day to the next? If so, you could use a For Each Loop and create a static list of database names to drop at the end of the day.

hth,
Tim

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
twitter.com/Tim_Mitchell

Post #609852

RBarryYoung

Posted Thursday, November 27, 2008 10:44 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

*sigh*

Again, this statement:

I have to update these databases in another database name"DateAgain".

makes no sense. You cannot "Update" one database to another (or "on" another, or "in" another, etc.). There is no such operation in SQL and this phrase does not mean anything.

Please explain.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #609921

« Prev Topic | Next Topic »

Permissions