Agreed. The above are Security groups not user accounts. Did I miss any permissions?

I certainly am trying to keep it as simple as possible. I want to use these groups across all of our environments. That said, this would included all...

Lutz,

Very creative. Good work!

Todd-

That is good to know. I always use master..xp_cmdshell to archive/rename/delete files... I would prefer to do everything from the package...

I have a .pdf practice test. If you're interested PM me.

I would recommend taking SQL 2008 exams.

http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx?#tab2

Yes, I understand it copied volume to volume. Just curious if there are any GOTCHA's they fail to mention.

How about this? Same issue?

select *,mycolumn=

CASE

WHEN mycolumn= 'PSI' THEN 10001911

WHEN mycolumn= 'PPO' THEN 10001912

WHEN mycolumn= 'PP1' THEN 10001910

WHEN mycolumn= 'NOT' THEN 10001909

WHEN mycolumn= 'MIN' THEN 10001908

WHEN...

can you post an example?

I want to backup the structure of the tables and not the data. How can I have the script be dynamic in the sense when new tables are created...

What about the new objects that get created?

I would like to use SQL and not a third party tool. Is scripting objects possible in SSIS?

Sorry Paul! How do I put it in a code window?

These are the columns you specified in your previous post...

SELECT STARTUP_TIME, SHUTDOWN_TIME FROM TBL_PC_AUDIT

Did you alter the table schema?

Here is a Function that works nicely.... Enjoy...

CREATE FUNCTION PROPERCASE

(

--The string to be converted to proper case

@input varchar(8000)

)

--This function returns the proper case string of varchar type

RETURNS varchar(8000)

AS

BEGIN

IF @input...