Here is me 'giving...

Sure. Copy the text from the results grid, paste it into SSMS and execute it.

omarlopez7 (3/6/2015)

---

you can replace this part of the query

"Last_Status_DT >= '2013-10-25'

AND Last_Status_DT < '2013-10-29';"

For this one

"Last_Status_DT between '2013-10-25' and '2013-10-29';"

And...

See if this gives you what you need.

if object_id('dbo.tab1', 'U') is not null

drop table dbo.tab1

create table dbo.tab1

(

a int primary key

,b text

...

rolinoberto (3/6/2015)

---

Hi to every ones,

I am new to this forum and to SQL world.

I need your help to find a solution for my headache, my question is:

I am using SQL...

Ron, you should try this out in on a test server.

There is no problem at all in overriding the connection string of a connection manager using an environment. No parametrization...

Nevyn, the idea of having multiple environments in the same SSISDB instance for Dev/QA/Prod etc makes me shudder.

There is too much risk of running a package with the wrong env...

Does my version work?

declare @temp table (ID int);

declare @i int = 1;

while (@i < 1000)

begin

insert into @temp

values (@i);

...

This will not work. Compatibility mode affects...

Please tell us where you heard that it was possible.

ramyours2003 (3/5/2015)

---

I heard it is possible to restore the SQL 2014 db backup to lower version of sql server (2012,2008r2), can any one one sent me the syntax of...

Hi Jeff, have a quick read here and you'll see that the answer is 'yes'.

If you can find a DOS command to do it (DOS rename supports wildcards, I think), you should be able to use an Execute Process task to run it.

Well done.

Circular references are really bad news with DB projects.

As no one has responded, I will assume that I have not missed anything.

It's a grotty workaround because all of my CLR functions get dropped, created and schema-moved every...