ATTENTION: I've decided to put the upgrade on hold due to a compatibility issue of our server environment with the latest CS installer package. CS 2008 now requires SQL Server 2005 as the backend DB but our database server currenlty has SQL Server 2000 installed on it. I'll resume the upgrade once I figure out when Telligent is releasing a patch to the schema compatibility issue. For now, we will continue to use the old version of CS while waiting for the said patch. If you have any questions about this process, please don't hesitate to post them on our forums and I'll answer them as soon as I can. Thanks for your patience and support guys! I'll let you know as soon as this is resolved. -
Keith Rull
Browse Site by Tags
Showing related tags and posts accross the entire site.
All Tags »
sql server (RSS)
-
I was asked by a friend of mine on how to create a trigger that would trace the changes that a user did to a table. So i checked my bookmarks and give him this link http://www.nigelrivett.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html Hope to Get some of your opinions or maybe improvements on...
-
Here's an update to my blog entry 3 years ago regarding the same topic: ---Calculates the first day of the previous month SELECT DATEADD (mm, DATEDIFF (m, 0, GETDATE ()) - 1, 0) AS [First day of the previous month ] ---Calculates the first day of current month SELECT DATEADD (mm, DATEDIFF (m, 0,...
-
[This 3-part series was written by Douglas Reilly who died early 2007. The articles were written in February to June of 2006.] This is the Part I of the series: The Value of Conferences And here is the Part II : The Benefit of Foru m Finally, Part III : Importance of Books and the Constant Change Author...
-
Its been months since i have'nt posted anything haha. I was addicted to photography indeed. Http://HumpreyCogay.BlogSpot.Com Any way i want to share one of my problems then. I've been coding SQL Querries for SQL Server for several years now, but working for the bank we use AS400 DB2 as a main...
-
[Description from website:] The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft...
-
Suppose that you need to populate record set from a stored procedure. This is how it's being done: CREATE PROC NameList AS SET NOCOUNT ON SELECT Emp_FNAME, Emp_LNAME From Emp_Table SELECT FName, LName From Table_of_Names RETURN When you execute this Stored Proc, it gives you something like this:...
-
Here's a contact just in case you're looking for jobs (Pampanga Area). Michael "Mike" Hotek is a Microsoft Book Author and Technology Practitioner. I was just glad he has a company in the Philippines: Mike Hotek President FilAm Software Technology, Inc. mike.hotek@filamsoftware.com...
-
My New Year's Resolution List: 1. Prepare For The MCTS-SQL Server 2005 Certification (70-431) 1.a Self-Paced Training (Training Kit + Videos Lessons) 2. Prepare For The OCA Exam (1Z0-042) 2.a Review Oracle 10g Architecture and Administration 2.b Attend Class For the Oracle 10g Backup and Recovery...
-
I wrote an article a few years ago using SQL SMO and just realized today that I can also list SQL Severs without importing an additional assembly to my project ( Microsoft.SqlServer.Management.Smo ) by using the SqlDataSourceEnumerator class . SqlDataSourceEnumerator is a class that provides a mechanism...
-
Hi Raphael, You can get a breakdown about the featureset of each SQL 2005 release here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Basically, SQL Server Express is file based and much similar to how you use MS Access. SQL 2005 on the other hand is an entry level database server...