SQL-DBA-01 (12/12/2016)

---

Hi Experts,

If I need to list out all the SSIS packages under the Integration services catalog folder how to get the details by writing simple T SQL and...

Thanks, Tim. It's reassuring to know that I...

alicesql (12/9/2016)

---

I have an SSIS package that has an Execute SQL task to

SELECT SUBSTRING(MAX([InvoiceDate]),1,2) as Monthsql

FROM BJmm (Table has a string date field per recipient requirement)

The Sql Source...

alex.sqldba (12/9/2016)

---

Aye. Well, ive been experimenting.

If I set the Transaction Option to 'required' rather than supported, I get an error about being unable to start a distributed transaction.

Edit: This is...

I had always assumed that the whole thing was a single implicit transaction. I'm not...

alex.sqldba (12/9/2016)

---

Hiya, thanks! I like this approach of using the delete/output as an SSIS Source.

However.

I am using the ADO.NET provider. And it's working fine, except in one particular occurrence: Should...

alex.sqldba (12/8/2016)

---

Evening All,

I have an archive routine that runs every night, it inserts some rows and then performs a delete. Basic stuff.

I have had to move the archive database to...

You need to make the updates conditional. Add something like

WHERE a.load_id <> q.load_id or a.load_id is null

to both queries.

You still haven't explained why.

Lowell, that's a neat trick!

Next step would be some refinement to return the actual SQL needed, ready for cut & paste. This sort of thing (borrowing your code):

IF OBJECT_ID('tempdb..#temp', 'U')...

I think you are out of luck. There is no magic 'reduce the size of files without shrinking them' command.

First thing I'd suggest is removing this line:

INNER JOIN dbo.Drops D ON J.JobID = D.JOBID

As it is no...

padmakumark26 (12/8/2016)

---

With user which have default schema we can access object without specifying schema name right ?

Like select * from table .

But i cannot access like that it is...

I...

Maybe you can use an external SMTP provider. Have a look here[/url].