Developer Newsgroups: SQL Server Tools

Management Studio Query results in grid not wrapping

JoJo3 - 3 Feb 2007 2:13 PM - 6 messages

Hi - I have 2 questions concerning the grid query results in Management Studio: 1. How can I get the data to wrap in a cell? If it is long, it just shows part of the data with '...' at the end. ...

Help scripting all stored procedures in SQL 2005.

Nomad - 2 Feb 2007 2:15 PM - 2 messages

Hi, I understand how to script a single stored procedure, and how to script all stored procedures into a single file, but I was wondering if it is possible to script all stored procedures so that they are scripted into individual ...

Error when trying to save or write to table

Steve L - 2 Feb 2007 10:16 AM - 3 messages

Hi, I am doing a tuning exercise on a SQL 2K5 instance, I am encountering a problem when Profiler goes to create a table. I have profiled Profiler and have extracted the following code CREATE TABLE [dbo].[con1] ([RowNumber] int IDENTITY(0,1) PRIMARY KEY, ...

bcp -x and "Invalid Field index."

bcp Yea, you know me. - 1 Feb 2007 9:41 PM - 2 messages

Hey, I am using bcp to try to create my xml file formate off from a table that has about 477 fields. I am getting the following error: F:\f\COFS>bcp cofsETL.dbo.FNIApplication format nul -T -c -x -f ...

Err saving DTS package on SQL2K SP4/Build 2187

DisgruntledTechGuy - 1 Feb 2007 4:13 PM - 1 message

Hello, I am running into a very strange issue on all servers running this distribution of SQL2K when saving DTS packages. Note that none of the servers have SQL2K5 running on them (so [link] is NOT applicable). Also, regardless ...

5 Day Backup Maintenance Plan Help?

Richard K - 1 Feb 2007 1:00 AM - 5 messages

I am just getting used to SQL 2005 coming from SQL 2000 and can't figure something out. In SQL 2000 I can go into the wizard and create a maintenance plan to do a backup every night keeping 5 day's worth of (.bak) backup files, ...

Why I can't change collation w/ Query Analyzer, but can do that w/

William Cai - 31 Jan 2007 8:20 AM - 6 messages

Hi list, I'm curious whty I can't change collation with Query Analyzer, but can do that with Enterprise Manager. Below is what I did, 1. Create a table lockp in which only one column exists, and the comlumn is ...

Tools fail unless all SQL2005 installed on c: drive

Jmc - 29 Jan 2007 10:12 PM - 2 messages

We have done about a dozen installs of SQL2005 in labs and in production and found that the tools work only if every component is installed on C:. On several production servers, we need to have the database on a large drive ...

automating SSMS reports

M Noreen - 29 Jan 2007 5:30 PM - 6 messages

Is there a way to automate some of the reports available in Sql Server Mgmt Studio? I really like several of them, such as the Schema Changes History, and think they would be helpful from a "compliance" perspective. So, I've ...

SQL Server Management Studio - long names in tabs

Wayne Erfling - 29 Jan 2007 2:20 PM - 7 messages

GlacierIs there any way to change the way query and file names are rendered in the tabs? When I use the program, it starts each tab name with the fully-qualified domain name (fqdn) of the server and then only shows about 10 characters from the .sql filename (it shortens the fqdn on the right and the filename on the left). ...