Browse by Tags

Working with DateTime data types in SQL Server, guidelines and explanations!
26 August 08 09:08 AM | ssqa.net | 1 comment(s)

Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it...

Filed under: sql server, users, global, datatype, datetime, guidelines

Get ready for SQL Server 2008 RTM release!
11 July 08 04:05 PM | ssqa.net | with no comments

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 will be on the August price list. This means that customers and...

Filed under: sql server, 2008, 2005, users, launch, windows server, visual studio, itpro, rtm, rc0, developer

SQL Server 2005 Replication: What are the Schemas and how they are replicated?
15 February 08 09:28 AM | ssqa.net | with no comments

You may be aware SCHEMA carries 2 different meaning within SQL Server 2005 version that were introduced, first one is the definition of an object (object.schema) and next one is owner of an object (user.schema). In the first case replication copies the...

Filed under: sql server, server, users, permissions, replication, object, security, stored procedure, schema