Viewing 15 posts - 4,531 through 4,545 (of 49,571 total)
Go to the computer named MIPRD, open Task Manager and look for PID 15844 (assuming the app is still running)
October 13, 2015 at 2:43 am
Table definitions, index definitions and execution plan please.
October 13, 2015 at 2:40 am
Run the installer, select the option to change or remove features, follow the dialogs. Make sure you select the correct instance to remove.
You can back up the master database. Providing...
October 12, 2015 at 9:34 am
GilaMonster (10/12/2015)
it is tied to its source database and cannot be moved anywhere, cannot be backed up, cannot be detached and is meaningless without its source database.
October 12, 2015 at 9:28 am
Most DDL can't be parameterised. The way to do this is your original statement.
October 12, 2015 at 9:16 am
DECLARE @sSQL NVarchar(4000) = ''
SELECT @sSQL = @sSQL + 'ALTER LOGIN ' + '[' + name + '] ' + ' WITH CHECK_EXPIRATION = OFF; '
FROM sys.sql_logins
WHERE is_policy_checked = 1
...
October 12, 2015 at 8:51 am
How am I supposed to give you the results you want when the data you provide couldn't possibly generate those results? I can't read your mind, I can't see your...
October 12, 2015 at 7:03 am
Where does this row come from?
2015-10-11,null,null,null,46800,50400
The only mission which Ali has with those times has a date of '2015-09-11', so why does it end up in the expected results with...
October 12, 2015 at 6:34 am
Ok, but your required results you say
from 2015-10-04 to 2015-10-11 for john
There's no John in your sample data.
Please ensure that the sample data is correct for the expected results...
October 12, 2015 at 6:20 am
Table definitions as CREATE TABLE statements please, and some sample data in the form of INSERT statements. Please ensure that the sample data is correct for the expected results you've...
October 12, 2015 at 4:16 am
nadersam (10/12/2015)
GilaMonster (10/12/2015)
October 12, 2015 at 4:11 am
vmit02 (10/11/2015)
The backups are occurring every 15 minutes but note that the last two listed have a gap in the LSNs even though they are consecutive backups.
Either you've misplaced a...
October 12, 2015 at 3:26 am
Jeff suggested temp tables. Be careful with table variables, because they don't have statistics, the row estimations are miles off usually and they can (and do) result in really bad...
October 12, 2015 at 3:24 am
I think that requires an uninstall-reinstall
October 12, 2015 at 2:47 am
Viewing 15 posts - 4,531 through 4,545 (of 49,571 total)