Jeff

declare @t varchar(max) = cast(replicate('1', 8000) as varchar(max)) + char(13) + char(10) + replicate('2', 8000) + char(13) + char(10) + replicate('3', 8000) + char(13) + char(10) +'z'

Another...

version - Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64) Dec 28 2017 15:03:48 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200:...

I continue to periodically get only the last column returned for a table definition. I thought that putting the last CASE ELSE in the "Get the columns, their definitions and...

The master, NewDB, and OldDB are all SQL_Latin1_General_CP1_CI_AS.

I restored my template database (this is the one that we restore to setup new sites) and the header said it was...

OK, think this has it working for all of my databases now. Put the string concatenation returned from ELSE into a SELECT - ELSE (SELECT .................. ). Got the idea...

Sorry, I should have mentioned this in the original post. I got the latest from http://www.stormrage.com/SQLStuff/sp_GetDDL_Latest.txt V314. I also tried the version that returns a table (DDLa??)....

I am getting only the last column returned when i call sp_getddl with a tablename.

create table aaa (field1 varchar(1), field2 varchar(2), field3 varchar(3))

exec sp_getddl 'aaa'

If I comment out the...

test

Do each of the sql files execute fully before the next one starts to run?

won't you get an error if you try to kill system processes?

I am a little confused. What would be an example of the procs purpose and what it would return?

Realize ths is an old post. But it showed up first when I was reseraching my issue. So thought that I would post my answer.

OK. got this to work...

This worked for me. I did change 'SP_CONFIGURE 'Ole Automation Procedures', 1' to 'EXEC SP_CONFIGURE 'Ole Automation Procedures', 1' and changed the SELECT statement to 'select top 1 @File =...

What version Powershell do you need to have for TRY CATCH? I have version 1 and it would not run this.

How do you "Put the stored procedure under a shortcut. "?