if you have to do this via bcp and not SSIS, then there are two ways that i can think of.

one exports a global temp table, and the other uses...

i'm very eak on this, never implemented it, but i thought there was a "Force Encyption" property on the server that could do that; otherwise it's an optional client connection...

a view is just a stored SQL statement. it gets run or rerun on demand whenever you select from it.

if you think about how indexes work, you can't put an...

yep that's what i figured; my model that i posted last will do what you are asking, but of course you have to adapt it.

I don't think you ever posted...

in SSMS, you just put everything between single quotes, lines and all: you might need to find and replace single quotes with two single quotes

DECLARE @sql varchar(max)

set @sql = '

CREATE...

there's afew posts out there that describe how the driver scans the first 8 rows to determine the data type;usually you can set the extended property "IMEX" of provider to...

do a PRINT @sql before you EXEC(@sql); that gives you the statement so you can run it independantly;

look at the costruction in the middle where you inserted EXECUTE:

...EXECUTE USE ......

check your join criteria as well... any chance something could be invalid, like JOIN Table2 T2 t1.ID = t1.ID (when it should be t1.id = t2.id?)

since this is express, can you find the link to SSMS and right click...run as administrator? does that get you in so you can disable the trigger?

Logon failed for login [server name/instance] due to trigger execution.

that says right there that A logon trigger has been put on the server and it is specifically rolling back your...

ahh i see it:

you need EXEC in there: can just have the proc name.,

...unused]) EXECUTE '+ @db_name+'..sp_spaceused ...

what you pasted was missing a lot...the table1 definition, three variables and more.

i think your insert needs to be inside the @sql variable.

SET @sql = ' insert into [master].[dbo].[Table_MetaData]([name],[rows],[reserved],[data],[index_sze],[unused]) '+...

ok, to do that, i think you'll just want to wrap a grouping query , and join that to the original table...

it might look scary, but it's one way...

just break it down into it's peices:

SELECT

NEWID(),--returns a varchar-ish something like D93D157E-3749-4A26-8410-859B237CE7FF

CHECKSUM(NEWID()), --returns a bigint like 1339413509 or -1323543251

ABS(CHECKSUM(NEWID())), --makes sure it's positive like 1585842432

RAND(CHECKSUM(NEWID())) --returns a value between...

you could try using the built in Schema Changes Report in SSMS;

instead of a specific database, right click ont he server itself and browse to schema changes history

look for the...