SQL Server Tools

Say you have a ft catalog containing one ft index. What is the difference between re-building the catalog, and doing a full re-population of the index ? BOL is unclear to me on this distinction. Thanks, Steve ...

Hi We have a table in the db that we suspect is corrupt. There are only about 40 or so records in there. What is the way to completely recreate this table so it is all clean? We also need the data that is already in the table after ...

When I have the Solution Explorer open, right click on 'Queries' and select 'New Query', it opens a blank tab.  How can I get the diagram, criteria, sql and results pane to show up in this window?  I always use those panes. ...

Is there any way to move the temp file that is create by Profiler (used for the datagrid scrolling screen) from the C: drive?  Our C drive is not large enough to allow a long Profiler session, since the Profiler temp file ends ...

does anyone know how to make SSMS _STOP_ removing Select * from my sql statements? Seriously-- WTF M$? ...

GlacierIn SQL Server Management Studio (SSMS), the animation when the subordinate windows (Object Explorer, Solution Explorer) are hidden is driving me NUTS! Is there any way to speed it up or turn it off?  It's really impacting my producitivity. ...

Hi, My SQL2005 SP2 server has problems with the Configuration Tools after it was upgraded using Microsoft Upgrade. Can I fix the tools on their own somehow? My problem is using a Windows local admin account I cannot see the SQLServer ...

Is it possible to have a dockable file browser in SQL Server Management Studio?  I can make an external tool that opens explorer, but it's a separate window. Another thing I have tried is to make the intergrated web browser's ...

Hi, We're going to be trialing this software in the next few days. I have been looking for reviews and have been unable to find much of anything independent. I would appreciate any input from users. I saw someone using it ...

I am receiving the folowing error when trying to use the stored procedure debugger in query analyzer: [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on [machinename] (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and ...

Hi I have the below script to create DSN for SQL Server. The problem is this does not include a username and password option for SQL Server authentication. Could someone please guide me how to add the username and password option for authentication to this script? ...