What's your question?

As we do not know where you are from, we do...

Tim ffitch (1/21/2016)

---

Phil Parkin (1/21/2016)

---

Tim ffitch (1/21/2016)

---

I can see where this would be useful for multiple environments on the same server. When dealing with multiple servers then it would be...

I love a good understatement.

I get very irritated when we run out...

Tim ffitch (1/21/2016)

---

I can see where this would be useful for multiple environments on the same server. When dealing with multiple servers then it would be better to create your...

Eirikur Eiriksson (1/20/2016)

---

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb...

Asterix.

Asterisk.

😀

🙂 glad I could help

No problem, thanks for posting back.

I tried this in Excel 2010 and, whether the date is a 'proper' date or just a date entered as text, it...

Great. A connection in SSIS can be defined at either the package level (which you know about) or the project level.

All packages within an SSIS...

You need to remove the GO after 'use MSDB'.

PSB (1/19/2016)

---

Hi,

I am trying to run a SSIS package as a job which copies data from sql view into a csv file using Execute process Task to a location...

Something like this?

select name, CaseDate, ct = count(1)

from tbl

group by name, CaseDate

I cannot...

--Create the role

create role myApp authorization dbo;

go

--Create users in the db

--Add members to the role

alter role myApp

add member [domain\user];

--etc

--Grant permissions to the role

grant exec on schema::mySchema to myApp

--etc etc