fn_getfiledetails - a replacement for xp_getfiledetails
As the undocumented SQL Server 2000 function xp_getfiledetails is not existent any more in 2005 or later i needed a replacement...
2010-06-14 (first published: 2010-05-07)
2,945 reads
- Interests: IT (obviously), Sci Fi, Fantasy, WingTzun
Blogs
Daily Coping 28 Sep 2022
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
SQL Server In Place Upgrades
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Daily Coping 27 Sep 2022
By Steve Jones
Today’s coping tip is take your time. Make space to just breathe and be...
Forums
SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
SQL Master Data Services 2019 - Website keeps prompting for login
I have two SQL 2019 servers running Master Data Services which are continually prompting...
Add more columns to output
$msg = Get-Content 'C:\miscjunk\SQL_Servers.txt' | ForEach-Object {New-Object 'Microsoft.SqlServer.Management.Smo.Server' $_} | Select-Object -Expand Databases |...
Ask SSC