Developer Newsgroups: SQL Server Tools

Management Studio Save Changes Dialog

Fred Sawtelle - 26 Oct 2007 9:34 PM - 6 messages

Can anyone tell me how to get Sql Server Management Studio to stop asking me if I want to save changes every time I shut it down? There was an option to stop that in Query Analyzer: "Do not prompt for unsaved files on closure." ...

Install Sql server 2005 managment tools on Windows Vista Home prem

sameer - 25 Oct 2007 9:22 PM - 3 messages

Hi, Operating system : windows vista home premium Sql sever 2005 Express edition I was able to successflly install sql server 2005 express edition on this OS but when i installing the managment studio for sql server 2005 ( the one that ...

Parameterizing an SSIS package

PhilHibbs - 25 Oct 2007 9:54 AM - 3 messages

I have created an SSIS package, but I need to be able to hand it over to someone else to run on a server whose name I don't know, and I don't know the database, user, or password either. If this was a ...

Diagram Tool Causes Strange Write Table Behavior

Garth Wells - 25 Oct 2007 3:42 AM - 2 messages

I'm creating a series of database diagrams for a database that has ~ 200 tables. The tables are segmented by module, so instead of having one massive diagram I am creating a diagram per module. All I'm doing is creating a new diagram, selecting all the tables ...

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server

DR - 25 Oct 2007 2:40 AM - 1 message

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I ...

An error has occured in a script on this page...

Stephen Howe - 24 Oct 2007 1:23 PM - 3 messages

Hi Running SQL Server 2000, SP4 Every time I start up Enterprise Manager, choose server, click on a database - what should be displayed is some overview of the size of the database and other statistics. But instead I get a dialog box from Internet Explorer that says ...

Sql Agent Connection problem

Greg - 23 Oct 2007 3:06 PM - 1 message

Hi, I'm running SQL 2005. My maintenance jobs have stopped running. If I open an existing job I noticed that it can no longer make a connection. When I click on the new connection , i can find the sql server and enter all the ...

Square Brackets

JW - 22 Oct 2007 8:24 PM - 11 messages

Does anyone know how to get rid of the square brackets when generating code in SSMS (besides manual search a replace every time!)? Is there a configuration setting that I can chage to get rid of this abhorrent default!!!! ...

SP2 introduced reduced connections in SSMS

Chris Wood - 22 Oct 2007 8:18 PM - 3 messages

Hi, In SP2 it was determined to reduce the number of connections that a second or subsquent query would use the connection properties of the current connection context. If you had a quey open in msdb then if you opened an sql ...

debugging in sql server 2005

Wendy Elizabeth - 22 Oct 2007 6:50 PM - 2 messages

Can you 'step' through code in sql server 2005 express like you can in visual studio.net 2005? I want to be able to debug code on my own workstation since my company does not have a 'test' sql server for me to use. ...

Last Modified Date of table, queries, views, sprocs

SilkCityFlorida - 22 Oct 2007 5:15 PM - 12 messages

I am working in SQL Server 2005, SQL Management Studio. I have made a number of changes over the last week in my test database, and now need to migrate those changes to a production DB. How do I get a list of what tables, views, ...

Where are x86 tools on x64 disks?

Craig - 22 Oct 2007 1:36 PM - 2 messages

We have the x64 edition of sql 2005 standard, and I would like to install the management studio on my x86 workstation. Can this be done without having to purchase the x86 server? Which would be totally a waste, but possibly part of Microsoft's GOTCHA plan. ...