Want to know the latest news and articles posted on SQLTeam.com Forums - Latest posts?
Then subscribe to their feed now! You can receive their updates by email, via mobile or on your personal news page on this website.
See what they recently published below.
Website title: SQLTeam.com Forums
Is this your feed? Claim it!
Hi
hope this helps
Failed = file already exists
Is DBCC process running.
Verify existing _MSSQL_DBCC9 file.
unused, stale snapshot.
Back up or rename the stale file.
Delete it
Check SQL Server service account permissions.
Rerun DBCC CHECKDB.
If Msg 5030 persists, check active sessions and loc...
It looks like master.mdf_MSSQL_DBCC9 is a leftover file from a previous DBCC CHECKDB snapshot.
I wouldn't delete it directly. First, check if any database snapshot is currently using the file. If it's not in use, you can stop SQL Server, take a backup/copy of the file, and then remove or rename it before running DBCC CHECKDB again.
The error Msg 5170 indicates t...
Yep you can do this with a simple UPDATE and REPLACE:
UPDATE dbo.videofiles SET filename = REPLACE(filename, 'Z:\video\', 'X:\video\') WHERE filename LIKE 'Z:\video\%';I’d run the SELECT first with the same REPLACE() just to make sure the paths look right before updating hundreds of thousands of rows.
python REGEX will be "2 words" code
hi mateen
$Employees = @( @{ EmpCode = "E001"; LastShift = "A" } @{ EmpCode = "E002"; LastShift = "C" } @{ EmpCode = "E003"; LastShift = "B" } ) $Rotation = @('A','C','B') foreach ($Emp in $Employees) { $s = $Rotation.IndexOf($Emp.LastShift) Write-Host "`nEmployee: $($Emp.EmpCode)" 1..6 | % { Write-Host "Week $_ = $($Rotation[($s + $_ - 1) % 3])" } } Employee: E...