Using Powershell 3, I had the same problem but ended up doing this:

$UnicodeFileName = $ScriptPath + "\UnicodeFileContent.sql"

$FileContent = Get-Content $FileName

$FileContent | Out-File -FilePath $UnicodeFileName -Encoding Unicode

Invoke-Sqlcmd -ServerInstance $SqlServer -Database...

Jet-Ski (10/24/2012)

---

We actually had this just yesterday. Someone deleted 100 records from our CRM, told us about it 30 minutes later. We did a point in time restore, but lost...

Since we support legacy systems and a full on 50 developpers that are redoing all of our systems by phases, we need two sets of development environments. That brings us...

I've been working at the same place (14 years now) since getting out of school and it's what what you might call a big small company or a small big...

I would have mentionned it. It's a great movie. But it was my understanding that the thread was supposed to be...

I enjoyed John Carter. Never read the books but it was great to watch.

I really enjoyed Cowboys & Aliens. I don't know if it was in 2011 but anyway, it's...

Lol very funny 😉 I really enjoy the community od SQLServerCentral.

I meant, of course, a...

Thanks for all the ideas. I'll try them.

Some gave me a laugh or two 😉

It's a good solution to use replication but it's very easy to get lost in it.

If you go down that road, my two suggestions are to keep a graphical schema...

Well well, that list is exactly my job right now, minus the cloud thing. I also support the legacy systems which my company is in the works of replacing over...

The state column could be changing but I don't see why it would. No process is making it offline or in emergency and there is no recovery process at that...

Well, since I added the keyword STATIC in my DECLARE CURSOR, the problem didn't occur. So I'm gonna implement this change on all my servers.

If anyone knows why the resultset...

I didn't find anything in any of the windows events logs or the SQL Server logs.

As you suggested, I added a bunch of outputs to trace the loop. I'll get...

Jas pointed me towards an option of RS Scripter on the Report tab called Server Parameters override report which will preserve the values set on the Report Server and override...

I did what Luke suggested and indeed, the RS Scripter tool (and the "Modify->Save" function in the "Properties->General" of the Reports Manager) don't seem to care about the changes made...