Ushanka

Renaming what certificate? Can you list the steps?

Yes.

(2) Logins that are members of sysadmin and do not have...

John Mitchell-245523 (6/3/2013)

---

But dbo is a user...

You could add a Script Task to the FeLC before the FTP Task and send the variable holding the file name in as a ReadOnlyVariable. In the Script Task fire...

I use PowerShell for this kind of thing and not through T-SQL either, it's a lot more flexible that way. If you look into the script further you'll see some...

KoldCoffee (5/30/2013)

---

That worked. Thanks Phil. I was trying to accomplish before unpivot.

In my dataset I sometimes have rows, where all 12 of the 12 rows that I am unpivoting...

The SQL Server in-built Extended Properties are great, but, they're a little cumbersome to work with using only T-SQL. redgate SQL Doc[/url] is a nice tool that helps you interact...

Command line tools that allow you to interact with SQL Server like sqlcmd.exe and bcp.exe would qualify as clients tools, as would the PowerShell snap-ins that to allow us to...

Very good point. I was sticking to "data changes" in the original post. It might be worth re-assessing the parameters of the original request.

I was thinking about this more and a differential could come out high as well as low. If you only update one INT field on a record the whole 8K...

I could see a differential coming out a little low if the same pages are updated multiple times in that 24 hour period but it will probably get you close.

There...

When the Login is a member of sysadmin this happens regardless of whether...

When logged in as this user, what do you get when you run:

SELECT *

FROM sys.tables;

With which? I think you already understand the standard way to do this. Create 25 Flat File Connection Managers and configure them to handle your 25 Flat Files. Create a...