I'm trying out the sys.sql_expression_dependencies view in
SQL2008 to track dependencies of our database objects.  The
ultimate purpose of this is to be able to generate a list
of DB objects in the order in which they need to be applied

In Sql Server 2005, I am trying to get the columns from a table and their
type.  I also have a UDT set as login1 that is a varchar(30).  It is showing
up for all of the columns that are varchars, regardless of how many
characters it is set to.

Is there a way to find out how many connections a particular Login or dbName
has?
Also, how many connections a hostname has?
I know that sp_who will give me a list of connections of but I am trying to

I've been hitting my head against the wall for three days now trying to
figure out why I get the error:
22001 [Microsoft][ODBC SQL Server Driver]String data, right truncation
(same error occurs with SQL Server 2005 and 2000)

Hi team,
  I would like to know where can I post a question about deploying reports
inside SQL Server? I could not be able to find any report forum...
Thanks,

Hi! I have a table called Rendering. This table have the
column BLOB. I rendering all Microsoft word file to this
table. I have no experience with SQL Server 2000.
My question is ?? How I can search a text inside the word

Using SQL 7, i need execute a query to eliminate 11 millions of lines and
works fine.
The problem is the space on disk. Is not much and to execute a query the log
file grows up to 16 Gb.

I am still digging old sql code, sometime I see one select query use 11
joins or even more.
I got some impression that is not good idea to join more than 6 tables (nor
more than 6 indexes on one table --separate question). Since I have been

This error happen when I tried to insert a value too long in a varchar
column:
(insert "123456" in a column varchar(3))
Is there a way to tell the server to truncate the value and insert

I have some xml that I pass in to a proc which I create a table from.
DECLARE @UserAssignedRoles
   TABLE (
        RoleId int,

I can't find what wrong with the step1 below.  I create a job to run and
select Type: TRansact-SQL Script using xp_cmdshell to execute the dynamic
sequel because but it does not work.  Which is not return any messages back
to the log file but when I change to select Operating ...

Hi I have the following problem:
The data  set obtained from a stored proc proc1 with input parameter
@partnum is:
projectno   partno

First, thanks for all answered my previous questions.
I have a data table which holds customers data. I am afraid overtime this
data table will grow too many rows (user might not want to maintain it). I
am thinking create one table per customer with identical table schema when

Is it possible to use CTE inside of a scalar UDF?
Thanks

I have a stored procedure as follows:
alter procedure prr_temp_source_partnum_out
@part_num varchar(50)
--,@projectno varchar(11) output