How about this :

Create Function dbo.udf_Get_Nth_DayNo_After

(  @Start_DateTime AS datetime

 , @End_DateTime AS datetime = '9999-12-31'

 , @SearchDayNr as tinyint  = 1

 , @nth as tinyint = 1

 , @hh_time as char(2)  =...

Lets assume speed is the issue and the FK-cannot be touched over here and

Sheilesh Paliwal cannot wait until the normal maintenance time.

Maybe...

maybe you'll find your answer overhere : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=127910

Check the connection objects to the server who's sa-pwd you've changed in your dts-packages !

After you altered the sa-password, did you stop/start that server's sqlagent ?

In EM :

Tools / Options / advanced :

you can set : - Login timeout

                   - Query timeout

                   - packet size

Create the PK in line with the create table statement.

create table #tmpMytable (col_id integer not null primary key

                , col2 datetime not null default getdate()

                , .... )

or

create...

Can you have them using a view ?

if yes, provide a view like this :

Create myschema.myview

as

select mycol1,..

  from myschema.mytable (NOLOCK)

This way they will not lock the rows...

as you have noticed NULL <> ' '

If there is no symantic difference for your schema and apps, avoid the NULL.

Thanks for the good advice Offcourse one has to choose a wife who enjoys the bike as well

400 to go

Now the weather is verry nice overhere (25°C, no clouds) so the bike is calling !

busy, busy, busy

I try to handle my daily portion of SSC, but don't always reach my...

Hi Frank,

Nice to have you back

Maybe even smsmon might help me a bit.

yep, yep, yep

Use a temporary table variable

use pubs

set nocount on

declare @Usernames varchar(5000)

set @Usernames = 'me,him,she,them,Karin'

declare @TblUserNames...

On our clustered instances, every once in a while the linked servers just give up

In our case that is not deadly because the...

could be something like this :

CREATE TRIGGER TrIU_T_Mytable ON dbo.Mytable

FOR INSERT, UPDATE

AS

   IF MyEmailColumn is NOT null

      begin

-- must be unique where not null

  If exists (select * from dbo.Mytable...