definitely, use something that will create a proper filename, and handle ending slashes

the below returns "C:\NewFolder\20172018"
$filename = "20172018"
$file= "C:\NewFolder"+$filename
you mosdt likely need the file and...

the naming thing is caused by using the sp_rename command; there are a few questions of the day on the same issue.

when you use sp_rename on a view/procedure/function,...

can't you add a windows group a user,  grant it db_datareader then set the database to read only?
then you can add the 1000 users to the user group, and...

it's a two step process;
you have to associate the files at windows, and then tell SSMS that you want to edit those extensions as if they were sql code.
create...

i am under the impression that each Invoke-sql command opens a connection, does the work, and closes the connection.
so you need all the commands in a single script, and not individual, multiple...

the labs.
practicing them multiple times, line by line.
every one of them.

I've been teaching a class for our local SQL Server User Group that does nothing...

you should only have to cast the comparison with a collate statement;
this worked for me, does this help?

i used 128 for the length, since a object name...

I am always so afraid of using a shot gun approach without definitive testing and eyeballing for correctness, because a find/replace could nail partial words /strings.
I would use either SSMS...

I would also suggest the SET NOCOUNT ON,  that used to be a staple of my old classic ASP pages; I would bet that is what is affecting you.
you...

i would think getting rid of the trigger, and creating a simple TSQL job that runs every hour would be better and easier.

a script like this would do...

gotcha, i think the issue is the cross database query call.

then normal individual who enters the data is not in the [msdb] SQLAgentOperatorRole or SQLAgentUserRole, which arethe roles...

have you set a proxy up on the job that is going to do the work?
that's pretty essential for anything that touches stuff outside of SQL server, like command...