Hi There are many tools out there some free and some not that offer a codesnippet facility. For some reasons in the company I work for they dont want to install or buy any third party stuff. I need to work with just sql server 2008. Is there a way to modify the templates so that when you choose create new SP it loads the custom sp. In a...
Say, I have a script nicely formatted in SSMS and it's annotated with all kinds of comments in different languages. But when I copy and paste this nice thingy into Word with syntax highlighted I will get a syntax-highlighted message with those comments garbled, as if reading the source text with one code page and pasting it using another...
I'm trying to find all references to an object in an SQL Server database. How can I quickly search? SQL Server Management Studio does not seem to do it. I use http://www.red-gate.com/products/SQL_Search/ but I'd like to find the "official" Microsoft solution to this. Is it in another product? For example, when I do a mass search in vis...
How can I see all disk usage of all my databases on a given SQL Server in one single query. I have around 15 different databases on my server and I want to see which one is using the maximum disk space. I know I can see reports of Disk Usage per database in SSMS or logon to the server and see the size of MDF/LDF files but this seems li...
Hello everyone, I am new to SQL Server 2008 Full Text index function. I am learning from this tutorial, http://www.codeproject.com/KB/database/SQLServer2K8FullTextSearh.aspx. I am using SQL Server 2008 Enterprise. In the first step of the tutorial, it is mentioned that I need to "Create a Full-Text Catalog", but I did not find the New ...
I have to restore various SQL server databases several times a day (for development purposes). In SSMS interface it takes forever and it is even longer to type RESTORE DATABASE command with all it's paths. Ideally I would like to double-click a BAK file right in Windows Explorer and run something to restore it. Any way to achieve this...
The stored procedure scripts that SQL Server Management Studio 2005 generates for me are like: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[APY_SP_ACH_Transmit_Finish]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' ... print...
I have something minor, yet very odd happening in SQL Server Management Studio 2005. I have 2 database catalogs which are essentially identical. There is a Market table with a foreign key to other several other tables for example the "Project" table has a MarketID column with an FK reference from dbo.Market. in both db catalogs the Marke...
I'm running SQL Server Management Studio 2008 against a SQL Server 2005 back-end. SSMS just exhibited a behavior I have never seen before. I don't know if this is something new in SSMS 2008 or just a function of something else. Basically, what happened in that I added some new columns to an existing table. After adding those columns,...
How can I just display the filename only in the tab? Currently I'm getting the full path in the tab. ...
I've noticed that when viewing query results in a grid in SQL Server Management Studio, it often causes resource locking on the server, preventing other queries from running. Why does this happen, when I'm only opening the table for viewing and not for editing? Disconnecting the query window from the server releases the resources. I assu...
I'm writing a fairly long running script, which prints progress messages as it goes. However, SQL Server Management Studio by default shows the resultset tab, not the messages tab, so the user will have to click the messages tab after starting the script to see the progress as it happens. Is there a way for my script to tell SSMS to s...
I have a column in a table of +15000 entries - I want to duplicate that entire column while retaining it's values and name it differently. I'm using Microsoft SQL Server Management Studio. How do I go about that? Thanks. ...
Hi, I am using SQL server 2008. If I am working on the Management Studio's query analyser, and I go ahead and create a new table or view, then the SSMS does not see the newly created object for intellisense. What do I do to make SSMS see and autosuggest from the newly created tables/views too? ...
I have a column called <locations>, I want to find all matching values (ex: Canada) and replace with a different value (ex: Mexico). How do I go about that? Thanks. ...
Why does SSMS (MS SQL Server Management Studio) continue to increase the appending numbers to windows and queries even if I open a new one after closing all previous? For ex., the window header of a newly created query is shown as "SQL query6. sql - localhost.databasename (ComputerName\Administrator (52))". How one can reuse these "help...
Hello. Has anyone ever been able to get the Task List feature in SQL Server 2008 to work. Apparently you are meant to be able to use a comment tag and then TODO, HACK etc as a pointer to that bit of code from the task list. i.e. -- TODO: testing task list /* TODO: testing task list */ If anyone can tell me what I'm missing in ...
I want to know if any tools exist to explore the data in a relational database, and to drill through master-detail relationships. I already know how to view the data in a single table, and I know how to construct SQL queries that JOIN tables. However, to get N-levels deep, I have to write a SQL statement, find the ID of the item I'm in...
I SSMS (2008R2) menu Tools --> Options --> Designers --> Table and Database Designers --> "Warn on null primary keys" I played checking and unchecking this checkbox but could not detect the differences. What is it for? My related questions, probably: NULL permitted in Primary Key - why and in which DBMS? Why to use “not null pr...
In sql server management studio, data type- money, when I enter an amount with a decimal it automatically adds on zeros to fill up to the hundredths. How can I determine the amount of spaces after the decimal? ...