• February 16, 2007 16 Feb'07

    DTS package designed to overwrite extract.xls

    I have a DTS package that produces an output file called extract.xls. Every time the package runs, the output is appended to the extract.xls file. How can I design the DTS package to overwrite or delete the extract.xls file, before the output is ...  Continue Reading

  • February 16, 2007 16 Feb'07

    Update table rows in SQL Server 2000

    How can I update the first row of a group? I have a table like this structure: col1 col2 1 row1 * 2 row1 3 row1 4 row2 * 5 row2 6 row2 I want to update the col1 field of the record with *. ...  Continue Reading

  • February 16, 2007 16 Feb'07

    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

  • February 16, 2007 16 Feb'07

    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

  • February 16, 2007 16 Feb'07

    Calling a stored procedure remotely

    I'm using an ASP (Active Server Page) to call a stored procedure on a remote SQL Server. It's not executing, instead it's stalling. When my Web server and SQL Server are on the same machine I don't have this problem. What step am I missing to get ...  Continue Reading

  • February 16, 2007 16 Feb'07

    Utility to dump SQL Server Express database as text file

    I want to dump my SQL Server Express database as a SQL Server text file including "create table and index statements, and "insert into ... statements for all tables." Postgres has such a utility called pg_dump. Any ideas?  Continue Reading

  • February 13, 2007 13 Feb'07

    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

  • February 13, 2007 13 Feb'07

    Installing two instances of SQL Server 2005 on same server

    Can you install two instances of SQL Server 2005 on the same server?  Continue Reading

  • February 07, 2007 07 Feb'07

    Problems and justified use of cursors

    The use of cursors in T-SQL should traditionally be avoided when possible, as they are a procedural feature and performace penalties tend to be a problem. However, this excerpt outlines situations in which cursors are acceptable, and even necessary.  Continue Reading

  • February 07, 2007 07 Feb'07

    Database mirroring witness in SQL Server 2005

    Database mirroring in SQL Server 2005 will increase your system's availability by allowing a quick and automatic failover. This feature involves three SQL Server instances: the principal, mirror and witness. Edgewood Solutions' Greg Robidoux answers...  Continue Reading

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close