Developer Newsgroups: SQL Server Tools

Match your Design site's data schema and SQL statement to Application site

MatchSQL - 20 Jan 2007 3:43 PM - 1 message

Match your Design site's data schema and SQL statement to Application site between MSSQL 2000 , SQLServer 2005 , SQL Server 2005 EXPRESS [link] ...

In query analyser, how to expand row length in result pane?

Iter - 19 Jan 2007 9:04 PM - 3 messages

Hi guys, I have statement which I need to get result that includes long result. So the row was truncate and cannot display the entire row. How can expand the row length in the result pane? Thanks. ...

If, Then statement that results in other if, then statements

CPROULXM - 19 Jan 2007 8:40 PM - 6 messages

I need a formula or something that will do the following: If cell1 = 5, then use this set of if, then statements If cell1 = 6, then use this set of if, then statements, etc. I know it may not be possible to use a formula because you can only nestup ...

SSIS and polling

SalamElias - 19 Jan 2007 8:34 PM - 7 messages

Is there or does SSIS has a mechanism or a task that allows montoting the arrival of a file in a directory which wiould be the start point for launching the package, something like filewatcher in .Net. Second question, can I architecte a package that monitors modifications in ...

xml viewer

Chuck P - 18 Jan 2007 8:47 PM - 6 messages

If I am in 05 Query Designer and I display a column that has xml in it, all I get is a grayed out field (cell is readonly). I could of sworn that during a sql class we got an underlined field and if you clicked on it you got the xml ...

Exporting Data from SQL Server 2005 to Oracle 10

Paul W - 18 Jan 2007 4:50 PM - 1 message

I am attempting to use the SQL Server Export Data tool to export data from SQL Server 2005 to an Oracle 10g database. I have already used this successfully to export to a SQL Server 2000 database. My problem is that on the step of the wizard where you select the tables to ...

beware: SQL2005 management studio not 2000 compatible

Leon McCalla - 18 Jan 2007 3:08 AM - 2 messages

using 2005 management studio i made changes to an 8 step job on SQL 2000 server. I inserted a new step into position 8 and then tried to save it. SQL2005 management told me that some feature was not supported on SQL 2000 ...

Recovery of a corrupted Database due to power failure

Hari - 18 Jan 2007 3:01 AM - 1 message

Hi, Iam looking for some tools or methods to recover a corrupted mdf file (SQL -MSDE 2000)..please help me and I have tried the following : 1. used osql to open the master database and run the DBCC checkdb with ...

Recovery of a corrupted Database due to power failure

Hari - 18 Jan 2007 3:00 AM - 1 message

Hi, Iam looking for some tools or methods to recover a corrupted mdf file (SQL -MSDE 2000)..please help me and I have tried the following : 1. used osql to open the master database and run the DBCC checkdb with ...

Management Studio scripts for SQL 2000

Darren - 17 Jan 2007 4:20 PM - 3 messages

When I use the generate scripts task in Management Studio to create tables for a SQL 2000 target, the scripts do not run in SQL 2000. I selected SQL 2000 compatibility mode. The scripts work fine on a 2000 database ...

Deleteing SQL Aent Jobs in SQL2005

Chris Wood - 17 Jan 2007 3:36 PM - 3 messages

Hi, I have a situation where I had created a maintenance plan and edited the resulting job. I had to delete the maintenance plan and job. In SQL2000 I would delete the job first then the maintenance plan. I tried this is ...

Benchmarking Tools

Sameer - 16 Jan 2007 8:10 PM - 2 messages

Hello Does anyone know of any benchmarking tools to perform load testing and performance benchmarking on SQL 2005 and SQL 2000 on 32-bit and 64-bit? I was looking at Benchmark Factory from Quest Software but it does not ...

Sql Management Studio - Script Db creates objects out of ourder

Andrew Robinson - 16 Jan 2007 7:09 PM - 3 messages

Don't know if this is the best place to post this but I have a db with about 100 tables and a number of views and sprocs. When scripting the entire db using SMS, a number of the views and sprocs are created before their ...

Migrate from Sybase SQLAnywhere

Rhea - 15 Jan 2007 10:06 PM - 2 messages

I have to convert Sybase SQLAnywhere 8.3 databases to SQL Server 2005 databases. Does SQL Server 2005 come with tools to do this conversion? Thanks. ...

Little Lock Symbols

Candyman - 15 Jan 2007 6:15 PM - 14 messages

WE are new to SQL Server 2005. My team memebers and I have the same login-in as a group. One member developed some stored procedure code that I am trying to review , but there are thse little lock symbols on the file icon. how can ...

SQL - Fast LOCALHOST , Slow IP

Juano - 15 Jan 2007 10:48 AM - 9 messages

We have developed an application that use .NET 2.0 and in the same server are installed the SQL server. The problem is that when i use "LOCALHOST" on the application everething works fine, but when i chage it to the IP number the application works VERY SLOOOW. ...