Jayanth_Kurup (9/20/2015)

---

Phil Parkin (9/18/2015)

---

Jayanth_Kurup (9/18/2015)

---

VS or SSDT uses a version of the database schema to perform the comparison and not the actual database target itself. Its more of an extension...

The last row of what? What...

Jayanth_Kurup (9/18/2015)

---

VS or SSDT uses a version of the database schema to perform the comparison and not the actual database target itself. Its more of an extension of Data Tier...

Chris Wooding (9/18/2015)

---

We're using Visual Studio 2013 SSDT to generate deployment scripts for database changes and have found some strange behaviour.

The project has the following;

[ModifiedBy] CHAR (8)...

Beat me to it.

What I would also suggest is that you always schema-qualify your DB objects:

select dbo.ufnGetAccountingEndDate();

Steve Jones - SSC Editor (9/17/2015)

---

Brandie Tarvin (9/17/2015)

---

A few weeks back, we were talking about password managers. Someone mentioned LastPass and I've been looking into it. But the odd thing...

Ok. Does your @sql begin with a use db statement? If not, please reread our original responses.

AarionSSQL (9/17/2015)

---

Hi All,

I am trying to use variables to generate the command:

USE DATABASE

GO

Code below:

DECLARE @DBName_Schema varchar(500)

SET @DBName = 'Test'

EXEC ('USE ' + @DBName )

GO

It does not seem...

BWFC (9/17/2015)

---

Phil Parkin (9/17/2015)

---

I'm with you, Jeff. Using the threat of leaving, directly or indirectly, as a means to increase your salary feels ethically wrong and akin to bribery. If...

I'm with you, Jeff. Using the threat of leaving, directly or indirectly, as a means to increase your salary feels ethically wrong and akin to bribery. If you're leaving, leave,...

Not at all. Devenv.com can be used...

nick.latocha (9/16/2015)

---

Thanks Phil. No issue really - I'm working on getting files in the SVN.

All our packages are run via dtexc on a dedicated server - so trying to...

Please expand the sample data query which I provided, to illustrate...

nick.latocha (9/16/2015)

---

In Visual Studio (BIDS) after you build your project you end up with two dtsx files. One in the solution root and one in the bin folder. Does anyone...

Here's some setup SQL for anyone who wants to try this.

Hint: please do this in future when you submit forum questions 🙂

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

drop table...