tag:blogger.com,1999:blog-1332923898193291004.comments2023-12-09T11:22:35.048+01:00SQLAdminNielsGrovehttp://www.blogger.com/profile/02098378173525245170noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-1332923898193291004.post-70422713004394842242020-10-26T08:46:37.508+01:002020-10-26T08:46:37.508+01:00@Leigh Lepelle: You could use the pipe operators &...@Leigh Lepelle: You could use the pipe operators '>' or '>>'. Or you could pipe the output to Out-File CmdLet.NielsGrovehttps://www.blogger.com/profile/02098378173525245170noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-1823306733521178472020-10-11T19:13:48.089+02:002020-10-11T19:13:48.089+02:00Works perfect.
Could you suggest a method to outpu...Works perfect.<br />Could you suggest a method to output to text file?Leigh Lepellehttps://www.blogger.com/profile/02692126081393186625noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-52947666372955013452017-09-25T13:10:00.444+02:002017-09-25T13:10:00.444+02:00@El Buhleini : Yes, but you can easily have some c...@El Buhleini : Yes, but you can easily have some challenges with GPO's. You might have to hack the solution to fit your environment. Usually I start by working locally exclusive on the C-drive, and work out of the workstation to a fileshare from there.<br />Thank you so much for your comment - and happy hacking'!<br />SincerelyNielsGrovehttps://www.blogger.com/profile/02098378173525245170noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-21536107071259159372017-09-19T13:56:40.760+02:002017-09-19T13:56:40.760+02:00Hi,
I tried your solution, but it doesn't sta...Hi,<br /><br />I tried your solution, but it doesn't start the Launch ps script. Does this still work?<br />Thanks!El buhleinihttps://www.blogger.com/profile/12846148804251970484noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-42263043002736292652017-03-30T18:20:15.982+02:002017-03-30T18:20:15.982+02:00Very nice template Niels.
Maybe it could include ...Very nice template Niels.<br /><br />Maybe it could include ".SYNOPSIS" in the initial description?<br /><br />Jakob Bindslethttps://www.blogger.com/profile/15991115017499294057noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-46167588268057748002017-01-28T02:26:10.702+01:002017-01-28T02:26:10.702+01:00guys, try -format o guys, try -format o Anonymoushttps://www.blogger.com/profile/16748284780085183350noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-85964523141969401582016-10-25T00:46:03.112+02:002016-10-25T00:46:03.112+02:00Still looking for a PowerShell way to test the con...Still looking for a PowerShell way to test the configuration but here is one to set it.<br />https://github.com/johannesprinz/Powershell/blob/master/Modules/WinDev/Functions/Set-SQLAlias.ps1<br />Note this is the first cut, may expand it to take in server name if required later.Johanneshttps://www.blogger.com/profile/08421785096317614420noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-80181877397948876682016-10-06T10:06:18.578+02:002016-10-06T10:06:18.578+02:00Thanx! Very useful :-)
Thanx! Very useful :-)<br />Anonymoushttps://www.blogger.com/profile/04815505627483752464noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-72554501232723160462016-03-15T09:48:49.363+01:002016-03-15T09:48:49.363+01:00Many thanks for sharing this, it has solved the pr...Many thanks for sharing this, it has solved the problem with backing up our database, without having to change the service account being used by SQL server. i have found another helpful post see here: <a href="http://sqltechtips.blogspot.in/2015/12/backup-error-15105.html" rel="nofollow">http://sqltechtips.blogspot.in/2015/12/backup-error-15105.html</a>Blogging About SQL Tips & Trickshttps://www.blogger.com/profile/06724448991354361991noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-84989040220124167192014-09-25T11:18:51.700+02:002014-09-25T11:18:51.700+02:00@Arley: It is correct that the .NET formatting can...@Arley: It is correct that the .NET formatting can be done by ISO 8601 with -s, but I wanted more decimals. I am sorry that I did not write that requirement in the blog entry.NielsGrovehttps://www.blogger.com/profile/02098378173525245170noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-75426897135554963222014-09-17T13:49:56.729+02:002014-09-17T13:49:56.729+02:00I think .Net/PowerShell can give you everything yo...I think .Net/PowerShell can give you everything you want natively. See this article:<br /><br />http://technet.microsoft.com/en-us/library/ee692801.aspx<br /><br />The only caution I would add is that the -z format will FORMAT the output as Zulu time but the VALUE of the output is still local time, not Zulu!Anonymoushttps://www.blogger.com/profile/10630856958229726908noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-67736120701205952092014-03-11T00:26:28.341+01:002014-03-11T00:26:28.341+01:00This became very useful in a WAP/SMA deployment we...This became very useful in a WAP/SMA deployment we're doing. Thanks for posting the code!Anonymoushttps://www.blogger.com/profile/05117196990666865326noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-34898067698954500052013-11-17T16:13:03.167+01:002013-11-17T16:13:03.167+01:00Nice information. I also used PS to automate execu...Nice information. I also used PS to automate execution and charting of resultant data:<br /><br />http://tinyurl.com/og2c4kmAnonymoushttps://www.blogger.com/profile/08941750103832166299noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-25608313295361628302013-07-02T12:23:17.779+02:002013-07-02T12:23:17.779+02:00Nice post very helpful
dbakingsNice post very helpful<br /><br /><a href="http://dbakings.com/sqldatabase/SQLDMLCommands.aspx" rel="nofollow">dbakings</a>Anonymoushttps://www.blogger.com/profile/14178155909391788234noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-45233921774982468622013-07-02T12:22:49.988+02:002013-07-02T12:22:49.988+02:00Nice post very helpful
dbakingsNice post very helpful<br /><br /><a href="http://dbakings.com/sqldatabase/SQLDMLCommands.aspx" rel="nofollow">dbakings</a>Anonymoushttps://www.blogger.com/profile/14178155909391788234noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-46488320507082020292013-04-04T18:49:43.350+02:002013-04-04T18:49:43.350+02:00If you set a value greater than 60 for 'recove...If you set a value greater than 60 for 'recovery interval', it throws the same error <br /><br />http://sequelserver.blogspot.ca/2013/04/sql-server-2008-maintenance-plan-error.htmlAneeshhttps://www.blogger.com/profile/14630205472188972293noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-25363997333235063682013-03-24T19:18:39.029+01:002013-03-24T19:18:39.029+01:00Neil - Thanks for this post. I combined it with a...Neil - Thanks for this post. I combined it with a script by Jonathan Kehayias found here (http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/03/01/getting-partition-offset-information-with-powershell.aspx) and some basic code I had for a fairly comprehensive server audit script.Unknownhttps://www.blogger.com/profile/05543270670571013282noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-9912658289506523352013-03-21T14:58:25.506+01:002013-03-21T14:58:25.506+01:00brilliantbrilliantjoehttps://www.blogger.com/profile/00741589720749843770noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-76686066262788120002013-02-27T12:23:41.066+01:002013-02-27T12:23:41.066+01:00There is a failure in the parse script. Threads is...There is a failure in the parse script. Threads is only "d" but should be "d+", as it can be greater than 9.Manuelhttps://www.blogger.com/profile/14374633995052963499noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-57713188393062612332012-09-28T15:48:57.213+02:002012-09-28T15:48:57.213+02:00I spend some time getting the " and ' rig...I spend some time getting the " and ' right...<br /><br />Yea...you and me both. Luckily I found how you did it after failing for an hour. It was driving me CRAZY.Adam Mikolajhttps://www.blogger.com/profile/13057241657465527608noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-45143773344777333692012-05-25T11:47:32.285+02:002012-05-25T11:47:32.285+02:00The problem just came up on another server. This t...The problem just came up on another server. This time on a SQL Server 2008 Std. Ed. (x64) installation.<br />Again setting the I/O affinity to all (auto) solves the problem.NielsGrovehttps://www.blogger.com/profile/02098378173525245170noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-10401277727255340042011-09-27T20:24:04.326+02:002011-09-27T20:24:04.326+02:00It looks like the fix is: Move to a 64-bit OS on y...It looks like the fix is: Move to a 64-bit OS on your workstation.<br />Since I switched from Windows XP x86 to Windows 7 x64 I have not seen the error. The hardware was the same, only was the memory upgraded from 4 GB to 8 GB.NielsGrovehttps://www.blogger.com/profile/02098378173525245170noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-91063874435660244642011-05-17T06:48:30.814+02:002011-05-17T06:48:30.814+02:00Hey i am still getting the error
System.IO.FileLo...Hey i am still getting the error<br /><br />System.IO.FileLoadException: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050) See Microsoft Knowledge Base article 949080 for more information.<br /><br />I checked the version of the DLL in GAC its the same version as pointed in sys.assemblies.<br />I am using SQL Server 2008 R2<br /><br />Any fix for these??? <br /><br />http://kalashnikovtechnoblogs.blogspot.comDhaval Shahhttps://www.blogger.com/profile/06389122730937758437noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-61852594626801231082011-05-09T14:35:00.430+02:002011-05-09T14:35:00.430+02:00I have the same problem. Restarted the maintenacne...I have the same problem. Restarted the maintenacne plan and ran to good EOJ. The post you referred to discusses the problem with SQL Server 2005.<br /><br />H. Ross Reed Sr DBA OCCSQLSERVGUYhttps://www.blogger.com/profile/12428318419987910222noreply@blogger.comtag:blogger.com,1999:blog-1332923898193291004.post-41580363533002137452010-09-15T09:27:57.812+02:002010-09-15T09:27:57.812+02:00Yes, it also very useful to change authentication ...Yes, it also very useful to change authentication mode in SQL Server by using SQL code.<br /><br />- Raoul<br /><br />Web: http://guide-line.com/<br />Blog: http://guide-line.com/archives/category/raouls-cornerAnonymoushttps://www.blogger.com/profile/05894614873921352957noreply@blogger.com