Please will you configure the job step that runs the package to output to a file, and then post the contents of the file. Don't forget to obfuscate any...

I don't know whether it's possible through the GUI, but you can generate your own scripts from sys.database_permissions. It's a little bit of work for you to do, but...

I see. I didn't realise that was referred to as "indirect configuration". But anyway, "not working" is not a good way to describe any problem. What happens...

What are the exact statements you're running, and what error message are you getting? Feel free to obfuscate security details before posting.

John

Stop applications and anything else that may connect to SQL Server

Stop the SQL Server service

Edit the startup parameters for the SQL Server service to add -m

Start the SQL Server service

From...

That's because you didn't put a space before the "-m". But in any case, you don't need that option for sqlcmd, just for sqlservr. You should only need...

Are you saying you want to give access to every user in the domain? I'm not sure it's a great idea from a security point of view, but if...

Oh, I see what you're saying - you haven't even been able to log in to make the changes. Make sure that no other services are connecting to the...

If you edited the startup parameters in SQL Server Configuration Manager to add the -m, you need to edit again to remove it before you restart.

John

Probably because you haven't specified the config file. Check out the documentation for dtexec - it'll show you what switch to use to point it to your configuration.

John

... but if I had to guess, I'd say you have numeric data stored in a varchar column. In test, all values in that column can be converted to...

I think log shipping started off as Enterprise only, back in the day, although it was possible to roll your own in Standard.

John

The only way I can think of is to execute sp_who2 when a potentially parallel query is running. If any SPIDs have eight rows, then your change has been...

Excellent. So that you're not drip-feeding information to us, please follow Phil's advice and post full table DDL and sample data.

Thanks

John

Edit - although I still don't think you've got...

So you want the student's attendance record for the class he or she is currently in? I'm not sure that's possible, because you don't appear to have anything linking...