Developer Newsgroups: SQL Server Tools

Legacy DTS packages.

Chattabaugh - 27 Jan 2006 5:15 PM - 1 message

I am using SSMS to manage several 2000 servers that have DTS packages on them. When trying to Open, Migrate, Export, Delete, etc the DTS packages from within SSMS, I am not seeing any of the versions for the package. I can see ...

BI Dev Studio - unable to make connections

Ben Walling - 27 Jan 2006 1:03 PM - 1 message

While attempting to add a datasource from within BI Development Studio, I cannot enumerate databases for any server. If I type the database name and click 'Test Connection', I get the error message: Test connection failed because of an error in initializing provider. ...

ANN: Advanced Data Generator 1.6.0 released!

Martijn Tonies - 27 Jan 2006 12:44 PM - 1 message

Dear ladies and gentlemen, Upscene Productions is happy to announce a new version of the database developer tool: "Advanced Data Generator" (version 1.6.0) A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, ...

load postscript files in SQL 2000

Jack - 27 Jan 2006 7:29 AM - 3 messages

We are having a website that generates postscript files when an order is placed on it. These files are placed in a folder on the network. I have been told to Load the postscript files into an existing sql database ...

building a web site

admin - 27 Jan 2006 1:32 AM - 1 message

I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at [link] where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. ...

Going from osql to sqlcmd (MSDE to SqlExpress?)

oracle - 26 Jan 2006 11:35 PM - 2 messages

I am familiar with loading a DB so that it will work under MSDE. This is the command I use: osql -S ServerName\InstanceName -E -i ScriptName.sql So now I uninstalled MSDE and am using SqlExpress instead. To do the ...

SSMS Query Editor... Vs Query Analyser

trsv@yahoo.com - 26 Jan 2006 10:29 PM - 7 messages

When already connected to a database, if you open a .SQL file, SSMS prompts for database connection again, where as in Query Analyser if you open a .SQL file it will simply bring the text into the editor. ...

Connections no longer recognize (local)

Al Cadalzo - 26 Jan 2006 9:05 PM - 1 message

After upgrading to SQL2005, my legacy DTS packages do not recognize '(local)' in Source or Destination connections. In SSMS my connection recognizes '(local)' and it says '(local)' in Object Explorer. I can connect queries fine by using '(local)'. However, when using 3rd party tools such ...

Server Polling with SQL 2005 Management Studio

Chuck Banthos - 26 Jan 2006 6:58 PM - 1 message

In SQL 2000 Enterprise Manager (under Tools/Options), you can control Server State Polling (turning it on or off; setting the polling interval). Is there an equivalent in Management Studio?? ...

SSMA v2 project compatability with v1?

RBarryYoung - 26 Jan 2006 4:56 PM - 1 message

Can anyone confirm if SSMA(Sql Server Migration Assistant) v1 Workspaces can be used or converted for use by v2.0? I have been trying to figure this out all morning, but I cannot find anything about it in the doc or on-line. ...

MS Reporting, Oracle

Ulf - 26 Jan 2006 11:30 AM - 4 messages

Hi, when I try to run a select-statement to an oracle database (10.1.03) with a parameter from the SQL-area in MS Reporting I get a message like: 'The provider can not determine parameter information and setParameterInfo' ...

Listing prepared statements...

Mark - 26 Jan 2006 5:40 AM - 4 messages

Hi... I've noticed when using Microsoft SQL Profiler, when prepared statements are in use, yields only such information as "sp_execute 3, 12, 34" etc. This contrasts with using stored procedures, whereby I get the entire "Select" statement in the profiler output. ...

SSMS Unable to display user properties when dbname is null

Bill Curnow - 25 Jan 2006 10:18 PM - 4 messages

I have a SQL user on a 2K server that has an invalid default database (dbname in syslogins is NULL). I have both Enterprise Manager (EM) and SQL Studio Management Studio (SSMS) installed. I can set this attribute ...

Why is SQL Server 2005 Management Studio so slow?

Ade - 25 Jan 2006 10:15 PM - 7 messages

I am in the process of evaluating SQL Server 2005 (Developer Edition) on a Windows 2000 SP4 member server in a Windows NT domain with three domain controllers (not active directory). I have installed both operating system and SQL server software from scratch and succeeded at the second attempt. ...

What's the recommended way for me to keep two databases in sync?

0to60 - 25 Jan 2006 3:33 PM - 6 messages

I have a database that captures real time production data that I'm trying to keep lean 'n mean. We don't want our analysts querying this db all day. So, we've decided to have a second db that we will keep in sync with the ...

Restore using Mgmt Studio only recognises first dump in backup device

Sukhdev S - 25 Jan 2006 12:08 PM - 3 messages

Using SQL Server 2005. (Tested on Developer edition running on XPSP2 & Enterprise Eval running on Windows 2003 SP1) 1. Create a backup device Device1 2. Backup AdventureWorks to Device1 3. Backup OtherDB2 to Device1 with NO Init 4. Try to restore the OtherDB2 using Management studio. ...

DTS Designer error

vsiat - 25 Jan 2006 10:13 AM - 7 messages

when I open a DTS package (or create a new one) I get the error: DTS Designer error The system cannot find the file specified then the package opens, but there are no objects in the "tasks" pane (the "connection" pane looks ok). All the task objects in the package show up ...

DTS Documentation Generator

mchernyshov - 25 Jan 2006 3:45 AM - 1 message

There is a nice DTS Documentation generator called DTS Documenter: [link] It will document Data Steps, Data Tasks, fields mappings and even the Package call tree. ...

Uninstall Reporting Services 2000

Sandra - 24 Jan 2006 10:49 PM - 1 message

Hi! I need your help? Can anybody answer me, please? The situation is the following... I have two Servers with Windows 2003... In one of then, I had installed SQL Server 2000 and in the other I have Reporting Services 2000... Now in the ...

Connection

Pure Heart - 24 Jan 2006 10:00 AM - 3 messages

Hi when i design a report using SQL 2005 and try to run it in production mode with setting the servertarget rul property of the project to http://localhost i get an error that it cant connect to the local host, but when i click the ...

restrict user access

beachboy - 24 Jan 2006 4:33 AM - 1 message

how can i set the user access level for sql 2000 server? i want to restrict the user only can query/add table/ drop table/ modify data/import & export data but don't allow them to view other services such as "Management, ...

Cannot create diagrams in SQLSERVER 2005

Juan Dent - 24 Jan 2006 1:04 AM - 4 messages

Hi, Every time I click on the Database Diagram node in object explorer in SQL Server Management Studio, I get a message: Database diagram support objects cannot be installed because this database does not have a valid owner. ... I have checked the owner and it coincides with my logon name in my domain ...

visual basic transformation script

atx - 23 Jan 2006 9:52 PM - 1 message

Hi, someone send me a visual basic transformation script to tarnsform some data in sql 2000 server, but I don't know how to run that script. It would be very kind of you, if you can tell me step by step how to run (with which ...

SQL Send Mail stop working with: failed with mail error 0x80004005

Aldair - 23 Jan 2006 9:32 PM - 3 messages

Helo group: I was using a SQL Srvr 2000 in a Win 2003 box. I had configured the SQLMail and everything was working, but now IÂ´m receiving this message: xp_sendmail: failed with mail error 0x80004005 when I try to send an e-mail. ...

transferring data from Foxpro .dbf to SQL 2005

Tony - 23 Jan 2006 6:32 PM - 2 messages

Hi, Does anyone know of a quick method to data from a Foxpro database to SQL 2005. Tony. ...

logging activity

Rafal W. - 23 Jan 2006 2:02 PM - 2 messages

I have following problem, one of our SQL2000 databases is being feed every night from external CRM system by mean of ODBC DSN data source, most of the time is working fine but sometimes we have an instance there not all of the ...

aint.exe_Fail)ã€‚

Thanks - 23 Jan 2006 1:54 AM - 3 messages

sqlmaint.exe Failã€‚ [SQLSTATE 42000] (Error 22029). Step Fail. EXECUTE master.dbo.xp_sqlmaint N'-PlanID 23BD4667-2869-44F7-B4EF-FEB78F1B6400 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "C:\DB Backup" -CrBkSubDir -BkExt "BAK"' SQL version 2000 Please give me idea! ...

Web Data Administrator

David Lozzi - 22 Jan 2006 4:08 AM - 2 messages

Howdy, I've downloaded the Microsoft SQL Server Web Data Administrator. When it opens, Desired Port is blank and disabled, and then IIS is selected. I assume this is correct? I click start, a new window appears. I tried Windows ...