-
Converting UTC to local time
ProblemValues in the database are stored as UTC date and time in a simple datetime format. You want to see data time values in the local time.SolutionUse the following code to convert UTC date/time to local:CREATE TABLE #table (date_UTC datetime)/* Pop…
-
Use sp_replrestart to fix “The process could not execute ‘sp_repldone/sp_replcounters’” error
This error is generally raised by the log reader agent while running transactional replications. The error indicates that distributor and subscribe databases has data that may be more recent than data in the publisher database (the agent compares lates…
Toronto, Ontario, Canada
Eastern Time Zone
info@maximconsulting.ca
Month: December 2016
Archive
Categorise
- aggregation
- audit
- average
- backup
- baseline
- cell value overwrite
- certification
- compliance
- cube
- data driven subscriptions
- data export
- datetime
- de-normalize
- graph
- hierarchy
- local time
- MCSE
- MDX
- Microsoft
- parent-child
- recovery
- restore
- rounding
- script table data
- Small cell value suppression
- ssas
- ssrs
- statistical functions
- stipline
- UTC
