I'm trying to save a SP into the DB but it's asking me for a location.  I'm
doing this in SQL Mgmt Studio.  This is my first SP from Mgmt Studio.  I
don't want the SP to be a file.  I want it in the DB.

I am creating a stored procedure that will search my products database.
The user will enter the search term and select whether they want ALL
words or ANY words.
Based on this selection I use either FREETEXTTABLE or CONTAINSTABLE.

Can I have TRY...CATCH in a UDF
I am getting syntax errors and have no idea what is causing them.
Also, it did not like my SET NOCOUNT ON statement
SET ANSI_NULLS ON

As a learning exercise I decided to try to model out a system that would
accept golf tee time reservations from a website.  Didn't take long to
realize that this was a more involved undertaking than I was up to.  However,
the preliminary questions wrote down are intriguing, at ...

Hi.  I've got a select statement that uses an aggregate clause nested inside
of a subquery.   For my own edification (as well as taking advantage of any
available performance boosts that come with it), I'd like to know how to
rewrite it so it doesn't have a subquery.   Here's the ...

I have my sproc all coded and working, however, my boss does not like that it
uses a cursor. What I need to do is to read a table (joined with several
other tables) and for each record perform multiple checks (by referring to
other tables) and then if (multiple) certain ...

Using SMO in SQL Server 2005 and Visual Studio 2005:  I would like to
get a collection of defaults that are defined for all tables in a
database.
I see the following data type:

I remember once apon a time I had some code that would fix up the sysdepends
table. Basically it would go through every stored proc/view/function etc,
get their help text and execute it (with an alter statement). I did this in
C# but the code is now the property of my former ...

Hi I have a view as the following: This view has SalesPerson as a alias name.
(PROJ.Last_Name + ' ' + PROJ.First_Name AS SalesPerson)
Now I need to test a prototype procedure and then extend the concept to the
real one.

I want to dynamically build and execute some DDL statements.
For example I want to cycle through all the databases listing in a table
where each of these databases have the same schema.
Then I want to build a view in one database that is the union of the data

Somewhere around the 50th time the method shown below is called a
TransactionAbortedException is thrown.
The inner exception is "The requested operation cannot be completed because
the connection has been broken".

Sorry for the cross post.  I originally posted this in the wrong NG.
I've been working on setting up a package to simply append data into a table
residing in a 2005 db.
(I've even tried importing the flat file from management studio)

Hello;
I am designing a large Sql Server 2008 Database system that would
include Distributed Views.  The system would consist of a growing list
of Linked Sql Servers, where each server has it's own database, but

I have the data like this
Declare @var        nvarchar(max)
Declare @type        nvarchar(max)
Declare @Fields        nvarchar(max)

Does anyone knows if there is a way to grant users view stored procedures.  
I am using SQL 2005.  Thanks in advance.
I got an errors and not sure if it's the correct syntax:
GRANT VIEW DEFINITION ON SCHENA:dbo TO [CompDomain\BizTlkAdmin]