Blog Posts on microsoft sql server
Percent:
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. by Fryan's Digital World on Apr 30, 2012While deploying a web service app to a remote web server of one our client. The saving process returns the following error: "Web service return error: Error while saving XML manifest.SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM an...
How To Reset Username SA Password In SQL Server by Fryan's Digital World on Feb 6, 2012We had this problem for almost a week now with one of our SQL 2008 servers. The SA password on it keeps on changing and ti'll now we don't know why and how. We already performed virus removal and etc but still no luck. The problem becomes worst becau...
Compact Database Corruption in MS SQL Server by Computer Technology Blog on Dec 13, 2011The concept of Database corruption still remains obscure in the minds of many database users and the very idea to deal with it would go in vain, if you do not plan out a perfect strategy at the right time. Most often, SQL database users come across...
Describing Microsoft SQL Server table structure by ColdBuffer Blog on Jun 17, 2011In order to work effectively with an existing database, it is a must for developers to know the structure of the database objects they are working with. Database Management Systems provide different ways on how to do it. This post focuses on describi...
Easily Execute SQL Query Without Knowing The Syntax by Fryan's Digital World on Jun 10, 2011Structured Query Language or SQL is a standard language for accessing databases. You can use it to access and manipulate data in MySQL, Oracle, SQL Server and etc. Before, learning SQL is required if you have to deal with complex database queries. Bu...
Singer IT Reunion at La Mesa Eco Park by Mga Kwentong ma Alamat on May 9, 2011I told you Singer wasn't just a place of work but also a place to create friendship. I have actually made lots of them and I am thankful for these gifts. Though personally speaking my Singer experiences were not all about a bed of roses. Matter-of-...
Decrypt Encrypted SQL Stored Procedures, Triggers and Functions With SQL Decryptor by Fryan's Digital World on Apr 29, 2011MS SQL Server 2000 and later versions have the capability to encrypt database objects codes to protect them from unauthorized access which I discussed in my last article. To revert the encryption, you'll have to restore it from your unencrypted backu...
Encrypt Stored Procedures, Triggers And Functions In SQL Server by Fryan's Digital World on Apr 26, 2011It may seems unbelievable but the reality is, there are still database programmers that are not aware that it is possible to encrypt sensitive codes in Microsoft SQL Server. Letting unauthorized or ordinary users to see what rules running your databa...
How To Change SQL Server 2008 Database Read Only Status To Read/Write by Fryan's Digital World on Apr 21, 2011I have downloaded an opensource inventory system and I wanted to try it out in my local machine. Upon attaching the SQL 2008 database, I noticed that the database status is showing Read-Only. How do I change this to Read/Write state so it can be upda...
Create New SQL Server Log File Without Server Restart by Fryan's Digital World on Dec 29, 2010If your a database admin and regularly check SQL logs, you may have noticed that SQL Server creates a new file log each time it restart. Fresh logs is helpful when troubleshooting problems so may need to deliberately create a new one for such special...
