Phil Parkin (7/7/2016)

Just to totally rule out a permissions issue, can you temporarily change the SQL Agent logon credentials to be yours, rerun the job & then verify (again from...

The All Executions report, overview page looks fine. Parameters Used list looks good and the UNC path name to the flat file is correct.

The folder I am iterating over is a project parameter and works fine (and is a UNC path that is permissioned to my user account and the SQL Server Agent...

Thanks for the reply Hugo, no the database is in READ_ONLY mode, i.e. as you said with the ALTER DATABASE statement.

Thanks but that requires manually adding each of the 400 packages to a Project first. I'm looking for something automated.

FileStore. They're all in a single directory and are run using C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe. Each package has a package configuration...

I might be able to answer my own question if I can find a SQL Audit filter predicate list. So I can do something like WHERE server_principal_name like etc.. Can...

Hi Ed, thanks for the reply.

Yes, I've been doing some testing today on Windows Server 2012 R2 and SQL Server 2014 CTP2 (until RTM arrives next week) 🙂

Even though I...

paul.knibbs (1/14/2014)

Jeff Moden (1/13/2014)

But you're not asked to specify an SA password during setup if...

Thanks Keith I know that. I'm wondering how the password is generated. i.e. is it secure enough? I'm wondering if I have to set my own "good" password for security...

I worked it out. Can be done with /SKIPRULES=RebootRequiredCheck

Thanks John, I'm looking for a reference to editions, not versions. Still can't find it...:w00t:

Thanks I completely agree. What I am after, is a statement from Microsoft in the documentation or otherwise. I am having a discussion with a vendor and I need to...

It's not a homework question, but I knew in the back of my mind that it could be solved without using RBAR. Thanks Fitz and Dwain!

Thanks that does provide the correct result but my hunch is that it can be solved in one statement using RANK and OVER statements. There you go,...