Developer Newsgroups: SQL Server Tools

SQL Server 2005 Diagram to Image

Rich - 19 Oct 2007 11:28 PM - 2 messages

Is there any way other than using Visio or any of the other expensive products to capture a picture of a database diagram? I'd like to put side by side different database diagrams and put them on a wall. Preferable with all ...

Sql Server 2005 Profiler - Connections Climbing

Richard - 19 Oct 2007 4:07 PM - 1 message

Hi Folks, I have an odd problem on my production system. We're running Sql Server 2005 Standard Edtn 64 bit in an Active-Passive clustered configuration. The system has 64 GB of RAM with 50 GB allocated for Sql. ...

SQLDMO with VB6

MylesJ - 18 Oct 2007 11:39 PM - 5 messages

I'm trying to distribute SQLDMO with my VB6 app, which connects to SQL Server 2005 Express. I'm using InstallShield to make my installer. I used the MS article 326613 to get a list of the files I need to distribute. I added those ...

SQL Profiler won't allow a developer to login

Jason - 18 Oct 2007 10:14 PM - 15 messages

Hi, I have a SQL Server that is causing some issues when devleopers attempt to load SQL profiler. I am an admin on the server and have no problems at all. I have read many articles about granting permission to "Alter Trace" but I ...

ANN: MS SQL Maestro 7.10 released

Vadim Vinokur - 18 Oct 2007 9:17 AM - 1 message

Hi! SQL Maestro Group announces the release of MS SQL Maestro 7.10, a complete admin and development tool for SQL Server 7/2000/2005/2008. The new version is immediately available at [link] ...

SQL Server Client Tools Free to Distribute?

charlie99 - 17 Oct 2007 10:39 PM - 1 message

I am running SQL Server 2000 Enterprise with per processor licenses. Can I freely distribute the Enterprise Manager and\or the Query Analyzer within my organization? TIA Charlie Database Administrator ...

Bcp problem (2005), previously posted to microsoft.public.sqlserver.programming

Mike C# - 17 Oct 2007 5:43 PM - 4 messages

This is a repost, I accidentally posted to .programming by mistake (it's been a long day already). Thanks. ------------- Having an issue with bcp on 2005, but brain is fried today for some reason. Any help appreciated. Here's the deal: ...

Sharing templates

Alex - 17 Oct 2007 2:53 PM - 1 message

We would like to create custom folders in template explorere and add our own custom templates. Is there a way to point the folder and the templates to a shared folder? I tried adding the folders manually and then creating a new template. I then ...

SQL2k Profiler: load big trace file into table, on small system ?

Steve M - 17 Oct 2007 7:08 AM - 10 messages

I am in a SQL2k environment, and am working on a machine with maybe 500 MB of free space on its C:\ drive, where the SQL2k binaries are installed. I have some profiler files I generated on another box, some up to 2.5 GB in ...

File Age to delete in sql 2005

tnt - 16 Oct 2007 5:07 PM - 3 messages

Guys, I am new to this version. We set our file age to delete after 5 days, but it is not doing it. We used the maitenance plan to backup the data/transacation. I checked "Delete files based oon the age of the file at task run time". Do ...

BCP and CSV - my conclusions

PhilHibbs - 16 Oct 2007 1:04 PM - 6 messages

There have been several threads here on reading/writing CSV files using BCP, and I suspect that they will continue to crop up for ever. The conclusion that I have come to is that you might, if you are persistent and lucky, be able to get something working. Be prepared, ...

isql.exe

Ashwathdama - 16 Oct 2007 10:20 AM - 4 messages

Hi, In our organisation we are migrating from SQL Server 2000 to 2005. we have more number of dos based batch files created using isql.exe file. Since sql server 2005 doesn't support isql.exe those batch files ...

BCP with a query in a file, or SQLCMD outputting tab-delimited?

PhilHibbs - 16 Oct 2007 9:27 AM - 12 messages

I need to do a few simple tab-delimited extracts from MS SQL Server 2005. The extracts are going to be relatively simple table joins, but still the SQL for the query could be a few hundred characters long so ...

SQL Server 2000 EM vs. SQL Server 2005 MS

MZeeshan - 15 Oct 2007 8:55 PM - 8 messages

One of the key differences we immediately noticed after upgrading to SQL Server 2005 is the greatness of SQL Server 2000 EM -- its simplicity of design, ease of use and the concept 'less is more' For instance, if one wants to see the execution status of different jobs, ...

Grid for data

Kaitsu - 14 Oct 2007 7:30 AM - 1 message

Any experience of grid-component for database. I need to get data out of database. Scripts for that i can make, problem is I have no component where to put data. I will continue my searching and learning and all ...