Developer Newsgroups: SQL Server Tools

Management Studio Autmoation

Joe - 12 Nov 2005 4:26 PM - 4 messages

Does Management Studio have a Macro Language or Automation object I can attach to through .Net to automate some repetitive tasks through the GUI? My biggest complaint about Management Studio is the inability to open a .sql file without respecifying my connection information each time. ...

Questions on registering server in SSMSE

Jason - 12 Nov 2005 12:24 AM - 1 message

I have installed SQL Server Management Studio Express with SQL Server 2005 Express. However, I find that every time I invoke SSMSE, I am asked to connect to a Database. I would like to know is it the expected behaviour ? ...

Mgmt Studio not supporting 7.0?

Johnny Ortega - 11 Nov 2005 10:53 PM - 4 messages

I tried using Mgmt Studio RTM to connect to SQL Server 7.0 instance and received this: "This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2005 and SQL Server 2000 servers (ConnectionDlg)" ...

SQL Server Management Studio locks up on long queries

roncli - 11 Nov 2005 9:15 PM - 1 message

In any query that has to run for more than several seconds (at least on a SQL Server 2000 database), the RTM Management Studio appears to be locking up. I did some Google and newsgroups searching, but couldn't find any solution to ...

SQL2005 Mgt Studio - script DROP before CREATE?

Dave - 11 Nov 2005 1:26 PM - 4 messages

In SS2000 you could set up the scripting options to check for existence and then issue a DROP statement for before a CREATE statement. How is this accomplished in Mgt Studio for 2005? ...

The Data Miner: SQL Server Data Mining Newsletter (November 2005)

Raman Iyer [MS] - 11 Nov 2005 2:43 AM - 1 message

the data miner SQL Server Data Mining News November 2005 ...

Property QuotedIdentifierStatus is not available

Rajah - 10 Nov 2005 2:02 PM - 2 messages

I'm using the release version of SQL Server 2005 tools (Microsoft SQL Server Management Studio 9.00.1399.00) and .NET Framework 2.0 (2.0.50727.42) on Windows XP SP2. My desire was to use the new tools against my existing SQL 2000 servers ...

SQL Profiler doesn't luanch correctly

Chris Newby - 9 Nov 2005 10:09 PM - 3 messages

In the past I've been able to use SQL Profiler without any problems on this machine within this network. Recently, however, whenever I try to start Profiler, a task item shows up in the task bar, but GUI never actually ...

SQL 2005 Managemet Studio ...Unicode?

Rich - 9 Nov 2005 9:33 PM - 5 messages

Hello, I was playing with SQL 2005 Management Studio and opened a proc for editing then saved that file to my desktop. I noticed when I tried to open it in notepad that the document had been saved as a Unicdoe encoded file. I was ...

2005 Management Studio -- Reformats my source!

ZippyThePinhead - 9 Nov 2005 7:16 PM - 4 messages

Minor issues that are driving me crazy about this tool: 1. I type in a new view and format it the way it makes sense to me. I hit the Save button, and SqlMS decides it wants to format it a completely ...

SSMS Shortcut behavior

Adam Wiedenhaefer - 9 Nov 2005 6:33 PM - 4 messages

I'm using RTM for SQL 2005 and have noticed a weird and REALLY annoying issue. When I get an errors when running an ad-hoc sql statement or a batch, I sometimes copy and paste all the errors to the window so I can remember ...

Enterprise Manager Design Tables

Jim Bunton - 9 Nov 2005 6:17 PM - 1 message

Yesterday I would sware:- I used Data Transformation Services to Import tables from Ms Access Data Transformation Services converted memo Fields in Access into nText in teh SQL Server Table I then use Enterprise Manager > Design Tables to convert nText Fields to VarChar(nn) ...

dtswiz sqlserver2005

Anonymous - 9 Nov 2005 1:21 PM - 4 messages

Is there somthing like dtswiz (from sqlserver 2000) in sqlserver 2005? I want to import a tab separated file into a table. ...

tool for stored proc. (written in oracle/sql) execution?

B Deepak - 9 Nov 2005 8:40 AM - 2 messages

Hi, Can somebody suggest a tool with which I can compare the result obtained after execution of stored procedure in oracle and sql? Basically, I have migrated my stored procedure written in sql 2000 to oracle. Now I want to check whether result obtained after execution of ...

2005 Management Studio: Jobs Details (summary page)

TomT - 9 Nov 2005 5:17 AM - 3 messages

I'm missing the info I got from EM on jobs, in the summary page, e.g. when a job was last run, success/failure, scheduled, enabled, etc. I don't see any way to add these columns on the summary page in Managment ...

DBCC LOG

Quinn - 9 Nov 2005 2:42 AM - 2 messages

Are there any documentation available on how to read the DBCC LOG output? ...

SQL 2005 tools and SQL 2000 replication

DanW - 8 Nov 2005 6:03 PM - 1 message

I uninstalled SQL 2005 in favor of SQL 2000. Too many interface issues, and the final deciding facter is the tools seemed to mess up the publications on a SQL 2000 server! I am in the process of deleting all of the subscriptions ...

Data conversion error using bulk insert with bcp generated format file

damezumari - 8 Nov 2005 4:43 PM - 1 message

I am using vb.net 2003 and windows 2000. This is my format file created with the command prompt: bcp pubs..eaccount format nul -fauthors.bcp -c -t"," -T -S 8.0 12 1 SQLCHAR 0 50 "," 1 ...

sql server 2000 installation

Nada Sherief - 8 Nov 2005 2:10 AM - 1 message

hello, 1-I want a detailed step by step tutorial for installing SQL server 2000. 2- I want to install two SQL servers 2000 on the same machine, how could i do that? (i mean will there be any change in the installation to the second ...

SQl server 2000 vertical fragmentation

Nada Sherief - 8 Nov 2005 2:08 AM - 1 message

hello i want someone to help me in solving a problem in sql server 2000 considering that i have a table named PROJ(JNO,JNAME,BUDGET,LOC) where JNO is the primary key of this table also this table is related to another one, where the other table has a foreign ...

Licensing and Installation of Client Tools Only for MSSQL 2000

gpzucker - 7 Nov 2005 8:19 PM - 3 messages

Does each workstation installation of the Microsoft SQL Server 2000 Standard Edition "client tools," i.e. Enterprise Manager, Query Analyzer, Profiler, require a separate CAL/license, etc.? This is strictly for administrative purposes only -- we want to install the "client tools" on the workstations of ...

SQL server 2000 fragmentation

Nada Sherief - 7 Nov 2005 8:11 PM - 1 message

hi, i want someone to help me in solving a problem in sql server 2000 considering that i have a table named PROJ(JNO,JNAME,BUDGET,LOC) where JNO is the primary key of this table also this table is related to another one, where the other table has a foreign ...

Installing Mangement Studio only

RQGal - 7 Nov 2005 4:46 PM - 1 message

Is there a way that I can install only Management Studio and not the rest of the features incorporated with it - such as Profiler, Replication Monitor, the Database Tuning Advisor etc.... I want to allow developers to use Management studio but not any of the accessory tools. Is my only option to ...

Good documentation tool

parasada - 7 Nov 2005 8:30 AM - 2 messages

hi all, if anybody could direct me to a free DB documentation tool for SQL2K that'll be great. Since we're running out of budget (usual year end crunch, blah blah!), we cannot budget for buying any new tool...if anyone also knows diff ...

Was 'Create Stored Procedure' wizard droped from SQL Server 2005

Shimon Sim - 6 Nov 2005 11:21 PM - 10 messages

I just started looking in management studio for SQL Server 2005 and can't find SP wizard. I Used it a lot even though it was a little pain to remove all the numbers that it attached to parameters. Is there something else I can use to automatically create simple SPs? ...

Tools "user friendly"

Christian Ista - 6 Nov 2005 3:17 PM - 4 messages

Hello, I use Oracle in general. We use tools like PL/SQL Developer ([link]) or Toad (quest.com) Are there some tools like this for SQL Server because, the tools provide by ...

looking for some performance monitoring tools

Hassan - 6 Nov 2005 6:33 AM - 4 messages

We currently use Sitescope in house and was wondering if there were better monitoring/alerting tools out there. Thanks ...