Problem solve

Microsoft SQL Server Database Development

• Conversion error in SQL Server business objects

  While working with business objects in SQL Server I am getting the error "conversion of char data type to datetime data type resulted in an out of range datetime value." What is the problem? Continue Reading

• Syntax error in SQL Server script

  I'm currently working on table partitioning. I'm struggling with using this " SELECT MAX(NAME) from sys.filegroups WHERE NAME NOT LIKE 'PRIMARY' " in order to get the last used Filegroup. Now this works just fine, but when I run the following script... Continue Reading

• Conversion of char data type error

  I received this error: "XP and VS2003 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." The same page under Server 2003 works well. I need to continue developing under XP, what can I do? Continue Reading

• Schedule batch jobs in sequence in SQL Server 2000

  How do you schedule batch jobs in SQL Server 2005 to run in sequence? Is there a way do this other than using DB Maintenance? Continue Reading

• Updating triggers in SQL Server

  By working with virtual tables in SQL Server triggers, you can manipulate executions for any rows in a table that were affected in the operation. Continue Reading

• SQL Server features to identify rows in a table

  Features available in SQL Server to identify rows in a table are comparable to those offered by Oracle, such as Rownum and Rowcount.Continue Reading

• Common DBMS table and column name restrictions

  SQL Server 2000 DBMS table and column name restrictions are detailed by expert Joe ToscanoContinue Reading

• Generating multiple flat files from a single flat file source

  Generating multiple flat files from a single flat file source could be done by first creating a DTS package with Custom Active Script task.Continue Reading

• Retrieving the first two rows in a table

  SQL Server Development expert Greg Low explains how to retrieve the first two rows in a table in SQL Server 2000.Continue Reading