Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score agrument tuncated in execution plan .. how do I get the whole argu
Lars - 22 Jan 2005 8:57 PM - 2 messages
Hello, I tried analysing a query using the execution plan provided by the query analyser. But when I move the mouse pointer onto some queryitems it seems that the argument used by the query part is tuncated. Even using SET ...
Score Unable to view or edit Database Diagrams in Enterprise Manager
David Williams - 21 Jan 2005 5:57 PM - 9 messages
I am no longer able to view or edit existing database diagrams from Enterprise Manager. I can create new diagrams and save them and can later edit them fine. I have a few older diagrams that were created some time ago ...
Score Profiler logging 'SP:Starting' hundreds of times for one SP
Stu Carter - 21 Jan 2005 3:04 PM - 3 messages
Hi, ENV: Windows 2003, SQL 2000 SP1, ADO.Net 1.1 We are invoking a stored procedure from .Net code (Windows service) once. However, when we trace it using SQL Profiler, it reports hundreds of identical SP:Starting and SP:Completed events.  All of which have 0 duration ...
Score Import into SQL Server Oracle Database from Export File (SQL*Loader)
K Kelly - 21 Jan 2005 2:42 PM - 4 messages
I need to import an Oracle Database into SQL Server 2000. I know this can be done easily using DTS but I do not have access to the Oracle Database, I only have an Oracle Database Export File. The Export file has been generated using SQL*Loader. ...
Score ISQL vs OSQL
Do Park via SQLMonster.com - 20 Jan 2005 3:55 PM - 2 messages
Hello I use SQL Server 2000. I always use Query Analyzer to run scripts, so I don't know OSQL and ISQL. I have some questions.   1. What is difference between ISQL and OSQL?   2. Which one is better?( this question is silly.) ...
Score query analazer limiting 256 characters row data
TreeView Custom - 20 Jan 2005 3:17 PM - 2 messages
hi i am using below query select distinct 1 as tag,null as parent ,categoryid  as [products1!2!categoryid],productname as [products1!1!productname] from products1  for xml explicit but the query return more than 256 characters that i was not able to view in ...
Score scheduling SQL Profiler
Arnaud Demol - 20 Jan 2005 12:15 PM - 4 messages
Hi all, Is that possible to schedule a SQL Profiler session (without to keep a windows session) ? If yes, how ? Thank's. Arnaud ...
Score Prevent automatic joins when adding tables?
Will Hughes - 20 Jan 2005 8:21 AM - 2 messages
Hi, Is it possible to configure Enterprise Manager to NOT automatically add joins when adding a table using the GUI tool? Or is there a better GUI tool for building sql.  I'm doing some rather large joins with dozens of tables and doing the sql manually has gotten a bit ...
Score Profiler Filtering recommendation on Locks and Deadlocks
Robert Richards via SQLMonster.com - 19 Jan 2005 5:07 PM - 4 messages
I came across a template for diagnosing potential locks and deadlocks. It recommended the following events and data columns. Since I have never analyzed a lock or deadlock from Profiler (I am afraid I would not recognize a lock or deadlock being reported in Profiler unless it stopped and said so), my questions are: ...
Score Problems saving tables with EM
Rafa® - 19 Jan 2005 4:45 PM - 2 messages
Me and my clients are having some problems, trying to save some table changes in Enterprise Manager... The error looks like the following: 'ANDAMENTO' table - Unable to create index 'IX_anda_dh_inclusao'.  ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state ...
Score Problems with T-SQL Debugger and Query Analyzer
Rafa® - 19 Jan 2005 4:43 PM - 2 messages
I'm receiving this error message on the majority of machines, from my developers, trying to debug T-SQL Stored Procedures (including my machine)... Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger ...
Score SQLMail and Outlook 2003
Betty [User] - 19 Jan 2005 4:31 PM - 6 messages
Can confirm if SQLMail and Outlook 2003 will work with Outlook 2003 closed. Outlook 98 and Outlook 2000 work, Outlook XP/2002 does not, but I have found very little info on Outlook 2003 (including the INF: How to setup SQL Mail, ...
Score MySQL Profiling Application
Tudor Sofron - 19 Jan 2005 8:21 AM - 1 message
Hi all, well...I admit it's pretty weird to ask this here :-)...but some programmers from the Linux team asked me if I don't know a profiling application for Mysql, something like Profiler. Does anybody have an idea? I've searched google for 'Mysql profiling ...
Score Any free tools for accessing and managing ISP SQL account?
xfile - 19 Jan 2005 2:59 AM - 6 messages
Hi: Very new to MS SQL, but our ISP provides us with a SQL account which we want to use. But the question is we don't know if there is any free tools (e.g. DbaMgr 2K) that we can use to access and/or administrate to our SQL account as ...
Score SQL Profiler Filters
Derek Ruesch - 18 Jan 2005 6:45 PM - 9 messages
I have a SQL Profiler trace that has the following filters applied: Application Name  Not Like  SQL Profiler TextData  Not Like  SELECT I want this trace to not include SQL Profiler events and SQL "Select" statements. ...
Score Permissions required to restore a database
Diana - 18 Jan 2005 6:14 PM - 2 messages
Hi, I need to restore a database to a new server.  What are the minimum permissions will I need to perform this task? Thanks, Diana ...
Score Performance monitor
Bryan Schmidt - 18 Jan 2005 5:05 PM - 3 messages
Hi All, I have an SQL server with two instances (default and stage).  I have performance montior objects available for stage but the default objects are gone and I have no way to generate performance stats for the default ...
Score [ANN] Altova DiffDog - the dedicated differencing utility for developers & power users
Altova Announcements - 18 Jan 2005 3:17 PM - 1 message
Altova Unveils DiffDog(tm) 2005 ------------------------------- This week, Altova added a new dedicated differencing utility to its award-winning product line. DiffDog 2005 is a powerful, easy-to-use synchronization tool that facilitates the comparison and merging of files, folders, and directories for application developers and power users. ...
Score Duplicate Text data
coromokes - 18 Jan 2005 2:21 PM - 2 messages
Anyone have a method for identifiying dupes in a text field? ...
Score Query Analyzer and EM display different results
Phil Cook - 18 Jan 2005 11:51 AM - 5 messages
When I retrieve a 'float' type value in QA it sometimes displays as 2768.8400000000001 but when viewing the table in EM it shows as 2768.84, which I believe to be the correct value. What causes this? MSSQL 2000 ...
Score differences between ORACLE and MS SQL
evagelos - 17 Jan 2005 11:26 PM - 4 messages
i want to create some queerys in MS-SQL 1) this queery in ORACLE-SQL works fine , in MS-SQL? SELECT     code_card, card_date + 31 FROM        card i searce and find out that i must use "DATEADD ( datepart , number, date )" ...
Score Diagrams - Enterprise Manager
Amanda - 17 Jan 2005 8:29 PM - 1 message
I have a problem adding diagrams in my database. I add the tables, save the diagram but when I try to edit it SQL SERVER Enterprise Manager shows me the following message: "[MS Design Tools] - The Database Object no longer exists." ...
Score How to import fixed-width text file in MS SQL 2000?
Tom - 17 Jan 2005 7:08 PM - 2 messages
Hello, Is there a simple answer to this simple question? How to import fixed-width text file? I know the width of the columns but there are so many that I don't want redefine them. I have already a table build for that data with the necessary ...
Score TSQL Backup Syntax
Michael - 17 Jan 2005 4:05 PM - 3 messages
Hi, I was just wondering could someone tell me what the TO  DISK = N part of the statement below is doing ? TO  DISK = N'C:\Test SQL Backups\Diff Backups\Northwind\NorthwindDiff1200.bak' Thanks ...
Score pss diag
Pradeep Kutty - 17 Jan 2005 3:21 PM - 3 messages
Hi All, I need to know whether we can run the psssqldiag through command prompt and collect the information? If so how? Thanks in advance, Prad ...
Score .NET version of DB Hammer
Justin - 17 Jan 2005 1:30 PM - 2 messages
Where can I get .net version of DB Hammer? J Justin ...
Score Query Builder Tool
DavidM - 17 Jan 2005 1:50 AM - 4 messages
Hello -- does anyone know of any good tools to create queries for SQL Server?  I'm currently using Query Analzyer, but would like something a bit more QUI oriented similar to what Access has -- where I can insert tables ...
Score Have you heard of DB Ghost?
mark baekdal - 16 Jan 2005 8:19 AM - 2 messages
This is what the last user had say about DB Ghost: "I consider myself a (demanding) power user and this tool has really grown on me…maybe it’s because it’s the missing piece of the puzzle to finally take ...
Next »