Ah, so you want to do the load in 4-hour batches – in a loop?

Use a query as the source for your data (and not just a table).

select ...

from ...

where DateModified > dateadd(hour,-1,getdate())

Select DbName, LatestBackupDate = Max(BackupDate)

from table

group by DbName

We have...

You're not the first, and won't be the last, to get caught by this.

MS should make all declarations of Varchar without size a syntax error, in my opinion.

Because I believe the poster was asking whether...

Uwe Ricken (11/26/2014)

---

Hi Faraz,

you can use DBCC IND if you use SQL Server < 2012 or sys.dm_db_database_page_allocation for SQL Server >= 2012.

This will give you a list of allocated pages.

To...

It would be useful to know a bit more about the dbo.systemsequences table.

Does this hold 'next id for table x' values only, or is there more to it than that?...

Chris Harshman (11/25/2014)

---

in SSIS 2008 we use FMTONLY in the ADO.Net Source task's SQL command text:

SET FMTONLY OFF;

EXEC SomeProcedureNameHere;

does this method still work in SSIS 2012/2014? Microsoft says it...

Sounds like a new dance move!!

Anyhow, I think we need to see the query which generated this error. I am suspecting that there's an implicit...

tmac3217 (11/25/2014)

---

We've run into some goofy metadata issues even with 2008. To work around them, we add the following as the first query within all of our stored procedures:

[font="Courier...

English translation, anyone? 🙂

Actually, that reminds me.

Here is a quote from BOL:

Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in a future release of SQL Server. Avoid using SET ROWCOUNT...

Try comparing the execution plans for each. If they are the same, you have your answer.

OK, I think I understand what you want. But what is your question?

--Edit: Jack's on to something. Use an asynchronous Script Component for this.