Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score Quest for Monitoring
Hassan - 10 Jun 2006 8:36 PM - 2 messages
Can anyone comment on the use of Quest for monitoring SQL Servers ? Is it worth the spend ? Thanks ...
Score Font in SQL pane in 2005
DWalker - 9 Jun 2006 8:40 PM - 13 messages
SQL 2005's management studio, in the query designer, typically shows 4 panes just like the old Enterprise Manager: Diagram, Criteria, SQL, and Results. I was hoping that with SQL 2005 I would finally be able to change the font ...
Score How to call Stored Procedure from SSIS package
JP - 9 Jun 2006 10:55 AM - 2 messages
Hi, How to make a call to the stored procedure from the SSIS package and utilitize the output value(return value) Thanks ...
Score adventureworks??
PJ6 - 8 Jun 2006 10:03 PM - 2 messages
I'm setting up a connection string to my SQL Server 2005 localhost using integrated security... and when I get to look at the list of databases I can connect to, I get AdventureWorks, AdventureWorksDW, and the system databases (master, etc). Where are my own databases? Am I somehow looking at another ...
Score SQL Server 2005 Express Edition :: Connection Limit
Muhittin Kara - 8 Jun 2006 9:58 PM - 2 messages
MSDE has a connection limit (as far as i remember, you can't open more than 20 connections at the same time) but other editions of SQL 2000 has no limit for opening connections. Is there a limit for how many connections can be ...
Score I need to extract .pdf/.doc/.xls documents from an sql 2000 table.
Chris.lee.johnston@gmail.com - 8 Jun 2006 9:31 PM - 6 messages
I have a table in sql 2000 where I can see all the file names ex. how-to-restore-cisci-3700.doc. The table is over 40mb in size. All other tables less than 1mb. I am fairly sure that the files are stored ...
Score ANN: myLittleAdmin for SQL Server 2005 released
el.c. - myLittleTools.net - 8 Jun 2006 10:07 AM - 1 message
June 8th, 2006 Company: myLittleTools.net Contact: Elian Chrebor Email: el***@mylittletools.net Paris, France myLittleTools is very proud to announce myLittleAdmin for SQL Server 2005 myLittleAdmin for SQL Server 2005 is the first web-based management tool specially designed for MS SQL Server 2005. ...
Score [2005] SSMS - Setting tab size for query windows?
Jeff Johnson - 7 Jun 2006 9:36 PM - 3 messages
Tools | Options | Text Editor for SSMS offers two distinct sets of options: Plain Text and XML. Since T-SQL isn't XML, I assumed that query windows would be governed by the settings for Plain Text. However, I set my tab and ...
Score Copy Database Wizard - what would you improve?
Oscar Naim [MSFT] - 7 Jun 2006 9:32 PM - 8 messages
Hi all, We are very interested in hearing from our users what are the top 10 issues currently present in the SQL Server 2005 "Copy Database Wizard" that you would like to see fixed/implemented (i.e. current problems and/or missing ...
Score Implementing Version Control on Database Scripts
Frank J. Reashore - 7 Jun 2006 5:55 PM - 2 messages
Hello All, I am looking for best practises, procedures, dos-don'ts, and tools for implementing version control on a database development project. Three items need to be tracked: 1) code (stored procedures and user-defined functions) 2) database schema ...
Score DTEXEC command line error
JP - 7 Jun 2006 3:06 PM - 1 message
Hi I get the following error when i run the SSIS package from the DTEXEC command line utility. Any specific reason for this error? Thanks in advance Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit ...
Score Great time in France
Holiday101france - 7 Jun 2006 2:31 PM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>Hello</P> <P>I had a fantastic time in France, hope to visit again soon.</P> ...
Score SQL 2005 SQLDIAG usage
Bill Blakey - 6 Jun 2006 8:52 PM - 2 messages
It appears that SqlDiag.exe has changed quite a bit from SQL 2000.  I'm trying to run an instance of SqlDiag (as a task not a service) for a SQL Express named instance (\BILL).  Here's my command issued from the ...
Score Maintenance Plan error
Helias Fatouros - 6 Jun 2006 2:01 PM - 1 message
Hi, Windows 2003 Enterprise SP1 SQL SERVER 2005 SP1 When i try to create a Maintenance plan i get the following error : ============================================= Maintenance Plan Wizard Progress - Creating maintenance plan "uuuuu" (Success) - Adding tasks to the maintenance plan (Success) - Adding scheduling options (Success) ...
Score ANN: Advanced Data Generator 1.6.2 released
Martijn Tonies - 6 Jun 2006 7:02 AM - 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.2) A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, ...
Score Calculating required space for making object partitioned
Alexander Abdoullaev - 5 Jun 2006 4:02 PM - 1 message
Hello! How can I calculate the space required in each filegroup from partition scheme to make some table or index partitioned ? For example, I have table1. The size of this table is 500 KB. Also I have partition scheme PS1 maps on two filegroups PRIMARY, SECONDARY and partition ...
Score 50 and more servers, 200 and more datyabases, HOW TO list USERS ?
Eric DonBanziani - 5 Jun 2006 3:41 PM - 5 messages
Hi everybody, I have more than 50 servers. Each server have 1 to 20 or more databases. All databases are SQL SERVER 2000 SP3 / SP4. Does anyone knows a script or a tool to list each DATABASE users ? It's borrying to use Enterprise Manager, connect each server, each database, ...
Score transfer database between two servers which don't want to talk
Alan Baljeu - 5 Jun 2006 3:35 PM - 5 messages
All I want is to trasfer the data in one SQL server 2000 installation to another.  Unfortunately, I can't get them to talk due to these computers existing in different domains, and assorted related obstacles.  I can ...
Score SQL 2005 Server Management Studio
Don Potts - 5 Jun 2006 3:24 PM - 2 messages
Hi, How do you edit grid results from a SELECT query?  It appears the new tool is missing the capability to edit and delete records from the results grid. SQL Server 2000 Enterprises Manager allows editing of grid results. ...
Next »