It's not possible because sqlcmd vars and t-sql vars are evaluated independently in different and disparate steps of the execution of a sqlcmd script. This example illustrates:

-- run in SSMS...

dankwart menor (5/19/2011)

---

What I mean is that there are tables that reference dbo.products via foreign key at the moment. If I rename the table (using sp_rename), the foreign keys will...

dankwart menor (5/19/2011)

---

Thanks for the snippet,

It's about what I tried when I hit the problem that the existing references to the table dbo.product now have to reference a view in...

A view named dbo.products with three INSTEAD OF triggers on it (one for INSERT, one for UPDATE and one for DELETE) may be what you are after.

Here is a code...

amenjonathan (5/19/2011)

---

One of my users is having an issue connecting to any of our SQL instances via name in SSMS, but she can connect fine via IP. She can ping...

So much for the .NET object underneath SSIS bubbling up the actual error message from the failed network call. Thanks for posting back...hopefully it helps someone else.

PS nod towards the...

Wow, that's neat! I have seen the error you originally posted on different forum sites but don't ever remember seeing a resolution where the original poster traced it back to...

Wait, glad you got it sorted, but what was a firewall issue? What did you do about the original SSIS error? Or are you sticking with some existing process?

Are you seriously wanting to run 2GB datasets through SSIS as a part of a regularly scheduled job or are we talking about a migration here? If that ODBC driver...

Sorry to hear that.

This may sound wonky and will be a bit slower than direct connections from SSIS but given the situation I figured I would throw some mud at...

Jin Kazama (5/18/2011)

---

ah yes works like that, silly me.

thanks for that. i guess there is no possibility for pattern matching, things like suggesting miss spelled words etc. but the suggest...

Grant Fritchey (5/18/2011)

---

There is no gui from SQL Server. It's worse than that. If you launch from SSMS, you're going to have a brain dead version of PowerShell. Better to...

It's kind of a corner-case but I did not want to bother stating the obvious about not adding trailing spaces in the first place 😎

Did you read my post?

It was...

It does seem like a bug but in terms of T-SQL code SQL Server does not seem to mind. It appears you can safely rename it to remove the trailing...

What, no mention of ISE? Imperative for PS development.

Located at %SystemRoot%\system32\WindowsPowerShell\v1.0\powershell_ise.exe on my system. Even though it says v1.0 it actually runs against the PS 2.0 runtime. The PS dev...