Think this will be a change to the database and so get logged and sent to the destination.

Better to restore a nackup taken after the change and re-establish log shipping.

Usually goes something like

select s<space>

<delete the word>

s<space>

<delete the word>

s<space>

<delete the word>

s<right arrow>

The for anything within 15 mins I'll correct it on the first attempt. After a 15 min gap brain...

Previously your clustered index was unique and the leaf level would be the data page.

Now you have the date as a clustered index.

The unique index will implicitely include the date...

For those of us who are in the habit of using s and i for column names it's a bit of a pain.

It's an expression. Probably the error is due to the values in the variables when it tries to evaluate the expression to produce the statement.

It's probably sleeping because it can't do anything - waiting for something tpo complete?

Could be that it's doing things in short bursts and when you get the snapshot it's sleeping...

A clustered index isn't necessarily unique.

If it is unique then it will need to include the partitioning column.

Means that your id will no longer have a unique constraint but id,...

Just tested it and in 2008 the partitioning column is added to the clustered index automatically

Unique indexes need to include the partitioning column so everything will be done just on...

Haven't tested this lately but I did an article a while ago

http://www.simple-talk.com/sql/database-administration/partitioned-tables-in-sql-server-2005/

The partitioning column was included in the clustered index automatically which can have odd effects.

It would be worth testing...

select item, date, quantity, tot = (select sum(quantity) from tbl t2 where t.item = t2.item and t2.date <= t.date)

from tbl t

order by item, date

That will give the daily totals so...

s.column <> ''

What do you want to happen if the column is null?

I agree with you about nulls being useful but you have to think about the users of a...

Are you sure you didn't do a test run of the job first which left it disabled?

I wouldn't do this in a trigger.

Use the trigger to insert into a table then have a scheduled job which polls the table and does the processing when an entry...

Not really sure what you want but maybe

select specific_schema, specific_name, ROUTINE_DEFINITION

from INFORMATION_SCHEMA.ROUTINES

where ROUTINE_TYPE = 'FUNCTION'

and data_type = 'TABLE'

sdabiri881 (11/10/2010)

---

Sorry, I have added the #Staging Table that the #Results table is pulling from for the OrganizationName field. Hope this makes sense. Thank you for your assistance...