the dt_? stored procedures are not related to replication but are used to integrate with MS Visual Source Safe.

As Service Patchs might assume that these procedures exists and the installatiuon...

If your schema is:

create table TBL_Y

(field1 char(1) not null

,field2 char(1) not null

, constraint TBL_Y_P primary key (field1, field2)

)

go

create table TBL_X

(field1 char(1) not null

,field2 char(1) not null

, Name1 varchar(255) not null

,...

There is a work-around for mapping global variables that is at http://www.sqldts.com/default.aspx?234.

Basically, the steps are:

1. Have a dummy sql statement that is on one line that has the desired variables....

There are two methods of limit the resources used by a SQL statment. From BOL:

Using SET QUERY_GOVERNOR_COST_LIMIT applies to the current connection only and lasts the duration of the...

When a table column is defined with a case insensitive collation but you want comparisons to use a different collation, the desired collation can be specified within the SQL. ...

There not enough information to determine exactly what is needed. Can you post the primary key of the table ?

Assummimg you want the top 10 Sources and then the...

SQL Server does not support arrays.

One altenative is to pass XML (see SQL Server Books on Line for parsing XML in stored procedures)

See also "Arrays and Lists in SQL Server"...

This is not true for SQL Server but is true for some other RDBMS such as Sybase's SQL Anywhere.

It is not good practice to ALWAYS create an index on the...

Alternatively, sp_execresultset is a system procedure that executes the result set of a SQL statement.

exec dbo.sp_execresultset @cmd =

'select ''GRANT ALL ON ''

+ QUOTENAME( table_schema) + ''.'' + QUOTENAME...

To get Monday's date giving the number of weeks since the beginning of the yearm, try

Declare@Weeksinteger

,@YearStartdatetime

set@Weeks= 37

set@YearStart= '2003-01-01'

selectMondayOfWeek = WeekDate

+CASE DATEPART(dw, WeekDate)

WHEN 1 then +1-- Sun

WHEN 2 then 0-- Mon

WHEN...

If by registered servers, you mean registered with Enterprise Manager, use RegEdit to export from registry key HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

and then import into the other workstation.

Under SQL Server, integrity constraints are checked when the action is performed not when the commit is performed.

Some other RDBMS do support an option that some integrity contstraints can be...

Joe Celko just this month published a solution for inventory which could be adapted to Payment allocations.

See http://www.dbazine.com/ofinterest/oi-articles/celko32

Is the C drive on the database server ? All reference to relative paths are from the point of view of the SQL Server not from where the stored...

You trigger is coded in a complicated and procedural manner where a single statement that does the update whenever the dependent values change would be simplier.

Try this:

CREATE TRIGGER Dollars ON...