Is there a transaction log backup or differential backup running hourly? Perhaps there is also be some IT-related process outside the server that's running on a schedule...

What jobs run...

I think your reply is solid. "In theory they are not..." Sounds like a response from someone who has "read" a lot but is lacking experience in "doing" a...

I have to ask "why" you would want to do this?

If you haven't done so already, Install Office 2007 Data Connectivity Components (http://www.microsoft.com/download/en/confirmation.aspx?id=23734) for the 64-bit

There are many ways to do this, you could use a CTE and UNION ALL the counts between the different ACTL_PROC_CD codes. Also, assuming your SQL Server isn't case...

Did you try the free software I recommended? It's does what you are asking...

That was my thought Jeff 😉 But without knowing "why" or "how" it got that way...

What is the server 64/32 bit?

In either case, make sure the version matches the office install

BTW, DBA swears up and down they didn't alter the proc, just ran sp_recompile (they did alter the proc later, so I can't look at a modify date on the...

You can do this via TSQL or download the Idera SQL Permissions Extractor (makes it a lot easier)

You can get a decent TSQL script here:

http://stackoverflow.com/questions/5983676/t-sql-copy-logins-users-roles-permissions-etc

http://support.microsoft.com/kb/918992

I'm not sure where you got your "drill" information, but in my opinion that'd be the minimum. Ideally, ask the question "how much data am I willing to lose?"...

IMHO, knowledge is good, but experience is better (and most often trumps it) - things from articles/books/etc can be learned, but I believe applied learning from an actual experiences is...

rajemessage 14195 (3/19/2014)

---

We are considering set base apporch for new devlopment

but following is quite complicated SP, which i can not change now.

So...

No I don't think you can tell SSIS how to do this - but if I understand you correctly (you want to throttle the SSIS to do its thing, without...

Good catch. Are you certain you uploaded the exact copy of the working code in Production? As a test, open up the RDL file XML, add the missing...