Thread: Need script to test SQL Server functionality

> Hi, Are you saying you will develop the script? quote: Originally posted by april198474 quote: Originally posted by jodelvalle Hi, Can somebody point me on the right direction? I need a script that will test SQL Server functionality (Create DB, create tb, insert, delete, select, etc.) I want to run the script after any major SQL update (SP,etc.). Any help will be appreciated. PS. I am new to SQL. Thanks. JD I will develop a program to...

> quote: Originally posted by jodelvalle Hi, Can somebody point me on the right direction? I need a script that will test SQL Server functionality (Create DB, create tb, insert, delete, select, etc.) I want to run the script after any major SQL update (SP,etc.). Any help will be appreciated. PS. I am new to SQL. Thanks. JD I will develop a program to check the result too. _____________________ april198474 www.comm100.com

> Hi, Your script will need to be specific to your database. I can't see any point in verifying that a CREATE TABLE statement will work after a service pack install. MS's quality control is not THAT bad.... If it was me, I would have a dev/UAT database set up with all db objects and DTS package (import/export routines) and then use a testing application to execute some key processes and check the results. It's not a trivial...

> Have you thought of using PowerShell and SMO? Ryan P. Casey • www.R-P-C-Group.com