Developer Newsgroups: SQL Server Tools

Database Schema Documentation Tool?

Greg Hess - 2 Dec 2006 3:52 AM - 7 messages

I am looking for a database documentation tool/script that I can run against a particular database to generate a document of all the tables, columns, and relationships in the database. I have seen a data dictionary that lists the ...

SMSS - script to new window uses sp_executesql?!

KJ - 1 Dec 2006 2:52 PM - 18 messages

Is there any way to get the old "script to new window as" instead of the new style that uses: EXEC dbo.sp_executesql @statement = N'ALTER PROCEDURE [dbo].[usp_GetSeri... I can't believe this is the only way to script a proc to a query ...

SQL2000 and SQL2005 export speed

Matt - 1 Dec 2006 11:09 AM - 1 message

Hello, this is what I'm trying to do: I have a database source2000 that I used to copy on the same sql2k (or other sql2k) server to dest2000 with Enterprise Manager import/export. Then I exported the source2000 in sql2k to source2005 in SQLServer ...

Assisted Editor

GaryDean - 30 Nov 2006 9:46 PM - 4 messages

I have a book that refers to the "SQL Server Assisted Editor" in management Studio. but when I right click on the Stored Procedure node or anything else I can't get the Assisted Editor. Where is it? ...

ANN: SQL Studio Data Compare 2006 (version 2.5) Release

Plamen Ratchev - 29 Nov 2006 10:25 PM - 1 message

Hello, Tangra, Inc. is pleased to announce the release of the new version of SQL Studio Data Compare - 2.5. This new version includes the following updates: - Target database backup option before executing scripts - Row filtering using a custom WHERE clause ...

ANN: Advanced Data Generator 2.0 released!

Martijn Tonies - 29 Nov 2006 1:05 PM - 1 message

Dear ladies and gentlemen, Upscene Productions is happy to announce the next major version of their test data generator tool: "Advanced Data Generator 2" A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, ...

Redistribute SQLServer2005_SSMSEE.msi?

Troy Wolbrink - 28 Nov 2006 7:20 PM - 6 messages

In my application installer, I'm planning on including SQL Server 2005 Express. Can I also include the SQL Server Management Studio Express (on the installation CD)? Or MUST the user obtain this from Microsoft directly? --Troy ...

DB Maintenance Planner - Jobs not running

WCM - 28 Nov 2006 7:06 PM - 5 messages

I set up 12 DB maintenance jobs on 3 separate DB's through the DB Maintenance Planner - each job has a daily time to run. All the jobs ran last night EXCEPT: MSDB db trans log backup / MSDB db Integrity Checks ...

import/export

Art - 28 Nov 2006 3:42 PM - 2 messages

Hello all, I've installed the SSIS component and i'm trying to import data into an existing table. I can't find an option, via the import/export wizard, to direct the import to a specific table. What happens currently, is a new ...

SQL 2005 Scripts Problem

Anatoly Kurilin - 27 Nov 2006 9:01 PM - 3 messages

Hi, used to have no problems with generating database scrips in version 2000, but now in version 2005, these scripts actually do not work! I mean I run them to modify objects on the another SQL 2005 database but nothing ...

Database Maintenance Planner

WCM - 27 Nov 2006 8:06 PM - 3 messages

RE: Sql Server 2000 I am using the EM DB Maintenance Planner to set up maintenance for several db's. In the dialog box I have checked 'yes' to 'Reorganize Data and Index Pages' and 'Check DB Integrity', and also 'yes' to 'Perform these Checks ...

SSMS Clipboard

Mike Caputo - 27 Nov 2006 4:05 PM - 3 messages

I frequently have to copy fairly large datasets from an SSMS result set into Excel. This works fine, except that it seems each time I do a copy/paste, the copied data remains in memory - but not visible on the clipboard. So if ...

error importing data from Access to SQL Server

Mattias - 27 Nov 2006 9:37 AM - 10 messages

Hi I am trying to import of data from my Access 2003 tables in to SQL Server 2005, via SQL Server Management Studio (Import and export wizard). All accesstables have been imported with no errors except for this last one "Transaktionsrader" ...

Scripting Object Permissions

JT - 26 Nov 2006 3:52 PM - 4 messages

Hi all, I am wondering if there is an option I can set in SSMS (2005) that will allow me to specify that I want to script object permissions when I generate a create script by right clicking an object in Object Explorer. I know that ...