Monthly Archives: August 2019

Objects exposing columns with CLR types are not allowed in distributed queries

Posted on August 30, 2019 by chanmingman

This post shows you how to resolve the error below when you query the Microsoft SQL Server database. When you query a database using SQL statement then you hit the error below. The query: SELECT * FROM [Linked Server].[Database].[dbo].[ someView] … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server Create Views using Linked Server

Posted on August 28, 2019 by chanmingman

This post shows you how to create a SQL Server View using Linked Server. Say I have a linked server created through port 9988, 192.168.125.116,9988. In the linked server I have a view name MyView_v. In order to create a … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

SharePoint How to Tag documents

Posted on August 24, 2019 by chanmingman

This post has a video showing you how to Tag the documents in SharePoint. The Tag and Notes in SharePoint has obsolete. Watch the video below if you want to Tag a document in SharePoint. https://youtu.be/8C36WZreRqQ Resource: https://www.kalmstrom.com/Tips/SharePoint-Online-Course/Categorization-Enterprise-Keywords.htm

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged | Leave a comment

Oracle Oracle.DataAccess.Client.OracleException ORA-01843: not a valid month

Posted on August 16, 2019 by chanmingman

This post shows how to resolve the error “Oracle.DataAccess.Client.OracleException ORA-01843: not a valid month” when using C# to insert or update the data with date. In my below statement I have SS_COMPLETED is a date column. I want to update … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged , | 2 Comments

CREATE FILE encountered operating system error 5(Access is denied.)

Posted on August 10, 2019 by chanmingman

This post is showing you how to resolve the following error. This error has happened to me when I was trying to Attach a database. CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server find a column name in databases

Posted on August 8, 2019 by chanmingman

The post gives a common useful SQL statement that finding a column name in databases. I always looking for it again and again, so I decided on to put this statement into the blog. The example below is to find … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | 1 Comment

Find Long Running SQL Server Queries Using SQL Profiler

Posted on August 5, 2019 by chanmingman

This post shows you how to achieve the steps in this article https://www.mssqltips.com/sqlservertip/4401/find-long-running-sql-server-queries-using-profiler/. What this video is doing is find the sql queries that are running longer than 10 seconds. We choose the event SP_StartCompleted and SP_Completed. We filter by … Continue reading →

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

SQL Server 6.0 documentation

Posted on August 2, 2019 by chanmingman

This is a short SQL Server 6.0 documentation I found in Internet so I just keep a copy and share it. https://1drv.ms/b/s!Aje-DdIVpfjSgiht9NahsmhAldEq?e=LIIQEk

Posted in Community, Computers and Internet, Data Platform | Tagged | Leave a comment

70-229 SQL2000 Design

Posted on August 2, 2019 by chanmingman

This is a book that I use for my MCSD back then. Should be legal to share it today. https://1drv.ms/u/s!Aje-DdIVpfjSgiWHJSVTi67I3kd1?e=n346V7

Posted in Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment