for that, where the column name is dynamic, i think you have to switch to dynamic SQL, wher eyou build a commadn and execute it instead.

a rough example:

DECLARE @cmd...

i wasn't sure of your use case, so here's three examples:

alias = {calculation}

{calculation}AS Alias

CalculatedColumn As {calculation}

SELECT Month1 = convert( varchar(10),GETDATE(),110)

SELECT convert( varchar(10),GETDATE(),110) AS Month1

create table #temp (ID int identity(1,1)...

every time I've gotten the old binary script not found error, it was because a script task was syntactically incorrect; i edited it, and forgot a semi colon, or deleted...

Like Eric, i use virtualbox;

i've got two laptops, my original with 8 gig of ram, which does pretty good with two virtuals running,and slows down beyond that;

i've got an...

I have a linked server on every sql instance that also has SSAS installed on the same box.

i can query the linked server for some of those attributes.

--#################################################################################################

--Create our Standard...

part of my Script Out Database mail settings script found here:

http://www.sqlservercentral.com/Forums/Topic982618-391-1.aspx

is a comment block to drop both the profile and the accounts.

grab that script, run it to produce a script,and...

redgate version 8 doesn't connect to 2012, but the updated versions of Schema Compare 11 handles 2012 and 2014 just fine; i'd look to see if your license includes upgrades,...

this is usually frowned upon, because the unique string generated can (and eventually Will) end up being an offensive word. there's no need to show a string, when a number...

i believe SQL Server 2008 R2 Express edition will limit itself to using 1 gig of ram max, regardless of the amount of ram available on the host...

this is a real stretch, but maybe the a nother dba or the network team changed the service account, and that account doesn't have permissions to the share the way...

can you add a logging fucntionality, that dumps some details to a log table as it completes each substep? then you can run it three or four times, and review...

that error would be pure syntax. you don't have a it's

INSERT INTO TableName(ColumnList) VALUES ...

or INSERT INTO TableName(ColumnList) SELECT ...

you've mixed values with columns, so ti fails.

INSERT INTO subs...

sqlcmd, bcp and bulk insert can import flat text files only, but the delimiters a can be anything; comma seperated, tabl seperated or pipe character seperated are probably the most...

is there a possibility that the filename @BackupFile has a space in it?

this would be valid:

DEL \\adas16.clients.advance.local\wip$\AvionteAP_Template_893.bak /Q

but something like would fail:

DEL \\adas16.clients.advance.local\wip$\AvionteAP - Full03-25-2015.bak /Q

can you change your code...

i have a couple of tables like that in a vendor database; with a single column index on the PK;

the funny thing is, that NC index gets used a lot...