Hrm, still seems upset about those tics:EXEC master..xp_cmdshell 'bcp "SELECT A.TABLE_NAME, A.COLUMN_NAME, (SELECT CASE WHEN A.CHARACTER_MAXIMUM_LENGTH IS NOT NULL THEN A.DATA_TYPE + ''('' + CONVERT(VARCHAR(3),A.CHARACTER_MAXIMUM_LENGTH) + '')'' ELSE A.DATA_TYPE END) AS DATA_TYPE, (SELECT TC.CONSTRAINT_TYPE FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU ON TC.CONSTRAINT_SCHEMA = KCU.CONSTRAINT_SCHEMA AND TC.CONSTRAINT_NAME = KCU.CONSTRAINT_NAME WHERE TC.TABLE_SCHEMA = ''DBO'' AND TC.CONSTRAINT_TYPE IN (''PRIMARY KEY'',''UNIQUE'') AND TC.TABLE_NAME = A.TABLE_NAME AND KCU.COLUMN_NAME = A.COLUMN_NAME AS KEYS FROM INFORMATION_SCHEMA.COLUMNS A WHERE A.TABLE_NAME IN (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE @MASK AND TABLE_NAME NOT LIKE ''%CHANGES%'') ORDER BY TABLE_NAME" QUERYOUT "\\hostname\testing\SCHEMA01.TXT" -Uuser -Ppwd -c -ec:\error.txt'Msg 102, Level 15, State 1, Line 14Incorrect syntax near '('.Msg 102, Level 15, State 1, Line 14Incorrect syntax near 'DBO'.