Developer Newsgroups: SQL Server Tools

When is intellisense to be added to SQL 2005

PeterT - 9 Dec 2005 3:40 PM - 5 messages

Can any body let me know when Intellisense is to be added to SQL 2005? I am stil in shock having found out that it does not support it. ...

Management Studio support for Foundation Server Source Control

PeterT - 9 Dec 2005 3:28 PM - 4 messages

Does the SQL 2005 Management Studio support source Control from Team Foundation Server. All the documentation refers to VSS. I have the TFS client installed and is working with Visual Studio but is not a visable option in SQL Management Studio. ...

Add existing database to a Project

David - 9 Dec 2005 3:32 AM - 2 messages

I have an existing database with many procedures that has been managed ad hoc in the past. I would like now with SSMS to move the database into a project with an alter script for each object and maintain the project in source ...

SQL Man. Stu and can't commit change in open table view

Wayne Clarke - 8 Dec 2005 8:56 PM - 1 message

When I open a simple lookup table to update a value in a development environment it fails. What happens is when I change the value a red exclaimation point pops up and if i move from the changed row to a new one it ...

Scripting options in new SSMS

Gerhard Pretorius - 8 Dec 2005 3:10 PM - 7 messages

I am a little stunned by Microsoft removing the scripting options in the new SSMS. All our teams developement is driven by scripting objects (view and procs) with the drop and create and including the permissions..... Not to mention the table indexes and primary keys.. ...

Query Analyzer "Script to.." Function and alter table

hromankokap - 8 Dec 2005 3:00 PM - 2 messages

I'm trying to figure out why Query Analyzer for SQL 2000 SP4 disables (greys out) the Alter option in the "Script Object to..." command in the object browser for user tables even when you are connected as a db admin (Windows) ...

Strange Value in enterprise manager! nvarchar displays: <binary>

immes - 8 Dec 2005 11:07 AM - 6 messages

Hi All, Im running Windows XP Sp2 and Sql Server 2000 Sp3a. My problem is that if I have a field in a Table that is nvarchar or nchar (Unicode) the Enterprise Manager displays in the colums for this fields the text ...

Unable to open SQL Server Management Studio Express CTP

wheelerc6 - 7 Dec 2005 11:07 PM - 14 messages

I have installed the .Net Framework 2.0 and the MSXML 6.0 Parser and then the SQL Server Management Studio Express CTP app but when I go to the icon and click on it to open the app the hour glass displays for a split second and ...

How do I repair a corrupted table - SQL2000

POP3.demon.co.uk - 7 Dec 2005 4:23 PM - 2 messages

We are using a third party erp system that uses MSSQL We have over the years created additional tables. One of these 'bespoke' tables appears to be corrupted and I am stuffed! I cannot access it using the select statement, or even via MS Access (ODBC ...

ANN: Database Workbench 2.8.0 released

Martijn Tonies - 7 Dec 2005 9:57 AM - 1 message

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.0 has been released today! Download a trial at: [link] What's new?: [link] ...

Management Studio: DB Context: Script Opens a new connection - How do I get script to reuse the conn

Chuck Hawkins - 6 Dec 2005 6:47 PM - 4 messages

I just partially discovered how to work around something that was driving me crazy. When I was opening up a script to apply to a database, the Query Windows was always opening a new connection to the Master Database. I want Query ...

Maintenance plans

jaylou - 6 Dec 2005 2:39 PM - 3 messages

I am not sure if this is the correct forum, but here goes. can anyone tell my what account (SQL Agent or SQL Server) runs Maintenance plans? I always thought it was the Agent that ran all jobs on the server. I ...

Capturing a query result from a sqlcmd script execution

MGBloomfield - 6 Dec 2005 1:01 PM - 6 messages

We have a Build Automation process that creates a database, installs all the tables, primary keys, column defaults, stored procedures, webpages, DAL, etc. Then, with a batch file, the Build Automation executes test cases on the SQL Server database. It does this, within the batch file, by calling: ...

Microsoft TPC-H Toolkit

Sinan - 6 Dec 2005 4:33 AM - 1 message

Hi, Can anyone provide pointers to SQL Server specific TPC-H tools? In the latest TPC-H report there is a reference to "Microsoft TPC-H kit" Can someone let me know how I can obtain that or any other SQL-Server specific tools ...

Profiler and cursors

DavidCur - 5 Dec 2005 7:43 PM - 3 messages

Hi, I've been asked to track how many times a number of tables get selected from, as a baseline for some application caching development going on. I thought this would be easy enough, as they don't need exact numbers, just ...

db size

rvegas - 5 Dec 2005 7:37 PM - 3 messages

how can i find out the allocated, file and transaction log size of a databases without going to the properties page? thanx ...

MSE

William F. O'Neill - 4 Dec 2005 8:41 PM - 1 message

Am attempting to use SQL Server 2005 EXPRESS on WINXP. Have successfully downloaded SQL Server 2005 Express and Maintenance Studio Express. No errors were received duing the installation of either program. However, when I click on the icon for MSE, the hard disk spins for about a minute, ...