Viewing 15 posts - 1,501 through 1,515 (of 6,400 total)
September 1, 2017 at 2:27 am
Do you have a directory D:\Databases\Data on the server your restoring to?
If not you will need to create that directory or use MOVE to specify the file paths...
August 31, 2017 at 5:39 am
Data and based on that data your output?
Read the first link in my signature
August 31, 2017 at 4:42 am
Thanks Thomas, yes been trying to use DBCC PAGE to try and work my way back to the offending row with no luck.
Thanks also Gail, yes that is...
August 31, 2017 at 4:37 am
The latest versions of visual studio have a schema compare tool with the option to deploy the differences.
August 31, 2017 at 3:34 am
You would need to do a sort of subquery to get the minimum priority value for each id and doc type, something like this
August 30, 2017 at 9:11 am
Sample data and expected outcome?
SELECT * FROM TAB1 t1 INNER JOIN TAB2 t2 ON t1.cust_no = t2.cust_no WHERE t2.bill_date < DATEADD(year,-3,getdate())
August 30, 2017 at 3:45 am
Web supports the Import and Export Wizard, I've not played with Web edition, but in the others you can save a wizard package as a job and run it when...
August 30, 2017 at 3:00 am
IIRC, SQL Clone from Red-Gate can create a clone of a DB from a backup file, pretty much like Virtual DB used to do
August 30, 2017 at 1:04 am
Stay away from sys.sysbrickfiles, it is used by sys.sysaltfiles and they are marked for depreciation and are intended for backwards compatibility.
The documentation for sys.sysbrickfiles says you can only get...
August 29, 2017 at 7:21 am
Sounds like you need a string splitter, which splits on TAB, from which you can select the first and last value.
Take a look at the DelimitedSplit8k / DelimitedSplit4k...
August 29, 2017 at 6:37 am
August 29, 2017 at 6:23 am
August 29, 2017 at 6:07 am
Do you have things like VSS enabled on that drive or backup software which uses VSS? Maybe install something like TreeSize or WinDirStat to see what is using the space...
August 29, 2017 at 2:25 am
Viewing 15 posts - 1,501 through 1,515 (of 6,400 total)