Backup a database
This procedure when executed with the correct parameters, backs up a database in the specified directory pathUsage :exec USP_BACKUPDATABASE databasename, directory_path
2002-03-12
574 reads
Script to export Stored Procedures
This procedure when executed with the correct parameters, exports all stored procedures from a database into different .SQL files in the path specified.Usage :exec USP_PRINT_PROCS username, password, servername, databasename, directory path
2002-03-12
444 reads
Blogs
Book Review: Lights Out
By Steve Jones
I have always been interested in GE since I was a kid. My best...
A Successful Blogger on Making the Switch
By todd-32417
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...
Login Timeouts
I was recently approached at work about a company that was seeing tons of...
Forums
Oracle: ORA-01843: not a valid month
Hi I have the following query which works fine in Oracle SQL Developer. When...
SQL Server internal variable with DML type
Can you advice how to retrieve the DML type a query is running? Does...
How to Convert Oracle SQL to T-SQL
Hello Community, I have been given a challenge of converting the following SQL code...
Ask SSC