DevPinoy.org

A Filipino Developers Community

Sign in | Join | Help

July 2008 - αρχάριος

αρχάριος

Home
Contact

Syndication

Recent Posts

Tags

My Blog List

Archives

Sort by: Most Recent | Most Viewed | Most Commented

How To: Rename SQL Server 2005 Database Using TSQL

For some reasons, DBA's need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes. Here we are going to rename our Database named "Bad_Ass_DB" into "Best_Practice_DB". This is how Database...

Published 07-10-2008 1:26 AM by marl

Filed under: SQL Server 2005 Rename Database, how to rename a SQL Server Database
How To: Create Dynamic File System Directory Inside TSQL

I have created a Backup Script to backup all the databases in our SQL Server 2005. I want to keep old backups for sometime for some reason; so I want to create subdirectory with the run date as the name of the folder to separate the set of backups by...

Published 07-14-2008 9:24 AM by marl

Filed under: Execute DOS Command in TSQL, how to enable dos command execution in sql server 2005, shell command in sql server 2005, xp_cmdshell

Copyright DevPinoy 2005-2008