Developer Newsgroups: SQL Server Tools

anyone using Quest Tools for SQL monitoring..

Hassan - 14 Jul 2006 9:50 PM - 1 message

And if so, can you shed some light on it ? We really want an enterprise level tool and believe Quest may have it. ...

Stored Procedures in Integration Services

Gerhard - 14 Jul 2006 8:40 PM - 18 messages

I am new to using version 2005, and want to set up an integration service that takes the results of a stored procedure and exports it to a .csv file. I can set the OLD DB source to use the Stored Procedure as an SQL Command, ...

sqldiag in SQL Server 2005

Vikram Vamshi - 14 Jul 2006 6:31 PM - 2 messages

Hi All, Is there any place I can get more documentation on the the sqldiag tool that is bundled with sql2k5? It looks like it is versy similar to the pssdiag tool. Is the documenation for pssdiag also applicable for sqldiag as well? ...

Cannot filter members in Management Studio Browsing a Cube

Marc - 14 Jul 2006 4:03 PM - 6 messages

Dear all When I want to filter members of a Dimension in Analysis Services in Management Studio, whith the Property UniqueName and the operator Contains, I ceceive the following error message: Query(1, 83) The '[INSTR]' function does not exist ...

Need Help finding ssis packages

John - 13 Jul 2006 6:24 PM - 2 messages

Ok, I created an ssis package and saved it inside of sql server. However, I can't figure out how I can open up packages saved to sql server. I found out I could save a package to a file system and then open it up later. It gives ...

Cannot open folder in SSIS after installing the cumulative hotfix

Marc - 12 Jul 2006 10:03 PM - 4 messages

Dear all I have installed the Cumulative hotfix package (build 2153) for SQL Server 2005 SP1. This works fine on a 32bit machine. On a x64- based operating system I have problems. I followed the install order as instructed in the KB ...

Changing SA Password in SQL Server 2005

steve - 12 Jul 2006 6:10 PM - 3 messages

Hello, All Is there a way to change the sa password in SQL 2005 without knowing the existing password? I tried everything I can find online to change the password but nothing works. This is on my test server so I am opened to anything. ...

reporting services 2005 - distributing pdf showing conditional graphs

koopmans - 11 Jul 2006 11:23 PM - 1 message

Within one report I offer the user one basic graph and multiple optional graphs. The optional graphs will be shown when the user clicks the +-symbol of that specific graph. Standard the values are being set to false to prevent information overload towards the user. This has simply been ...

SQL server compare utility

mecn - 11 Jul 2006 5:55 PM - 5 messages

hi, I am looking for a program or utility that it could compare sql server table schema, views, triggers and sps? not sure which program is better. Suggestions please. Thanks ...

SharePoint and Reporting Services

Joe - 11 Jul 2006 4:21 PM - 1 message

I have seen and understand the articles about how to configure one IIS to host both SharePoint and Reporting Services. Isn't it better to have a different machine host the Reporting Services - or am I misunderstanding how RS works. Maybe all the number crunching and data ...

Database Documentation

Rick - 11 Jul 2006 7:32 AM - 3 messages

Hi, Could i please ask your advise about how i best document my databases. I have a need to provide handover documentation of my database schemas and also of my intergration services packages. What do you guys currently do? I have seen a number of products that ...

Announcing a new SQL Comparison tool - get your unlimited free copy

yoni - 10 Jul 2006 9:36 PM - 1 message

Nob Hill Software, maker of several popular SQL Server tools, now have their own SQL Server schema comparison tool. It is Superior to other tools on the market in several ways; You can download your own copy at Since this tool is new, we are mainly looking for user feedback. ...

licensing

Joe - 10 Jul 2006 9:27 PM - 2 messages

We have licenses to load SQL2005 on all our machines. It appears to load BIDS as well - so this means all our users are free to use BIDS to design reports? ...

Sql 2005 can't update maintenance plans?

frostbb - 10 Jul 2006 3:28 PM - 8 messages

Dan English posted the message below on Jan 24. Looks like the thread has been expired from the microsoft.public.sqlserver.server news group. I'm experiencing the same problem. Haven't had any luck finding further mention of this issue with my Google ...