Take a look at this thread for the log shipping QOD.

In my opinion after put it in standby mode If you set it to dbo only and kill all connections...

UDP Port is used to determine the instances and listeneing ports but if you hardcode that on an alias you don't need UDP

potucekj : the User SID live in the master datatabase. For an explanation on why to run that? check This  out 

HTH

Select

 Job

 , histDate as SaleDates

 , (Select Min(T1.histDate)

    From dbo.Hist_Table T1

    Where T.Job = T1.Job

   and T1.histCode =10

    and T.histDate < T1.histDate ) as CancelDate

From

 dbo.Hist_Table T...

yes you can:

Create Table TEST (Row int, Data varchar(60))

GO

INSERT INTO TEST VALUES (1, 'a')

INSERT INTO TEST VALUES (2, 'ab')

INSERT INTO TEST VALUES (3, 'abc')

INSERT INTO TEST VALUES (4, 'abcd')

INSERT INTO...

Again another bad question. If you use standby mode instead of recovery  it works it is true that if someone is connected to it the restore process fail... so what?...

suppose you have a Calendar table with Working days Marked as 1 and Weekends and company holidays marked as 0

EX:

Create table Calendar (Dte Datetime, Workday tinyint)

Populate that table with 2...

One of the advantages that sp give and is not very often appreciated is that they can ISOLATE the application from the backend structure AND business rules so the changes on...

It is NOT EM who does that it just happens indirectly.

Those ports are used by NBT or netbios over tcp/ip it is all because of the NAME resolution mechanism. To minimize...

I've had BAD experiences with this.

If an index is to be used for one of the columns on the where clause, sometimes that expression is evaluated FIRST so the chain evaluation...

 change the Update Statement to :

UPDATE tblPN       

SET <A href="mailtoN=@NewPN">PN=@NewPN, Cage=@NewCage

WHERE tblPN.PN = @OldPN And tblPN.Cage = @OldCage

I always recommend to read this. Then You customize it to your solution

HTH

SELECT @newfield=i.prefix, @oldfield=c.prefix

FROM inserted i

INNER JOIN dbo.WPPI_Main_Load_Globals c ON i.ODBC = c.ODBC

change it to

SELECT @newfield=i.prefix, @oldfield=d.prefix

FROM inserted i

INNER JOIN deleted d ON i.ODBC = d.ODBC

-- I am assuming ODBC is pk

BTW...

I had a deja vu:

I posted something here. Check it out.

 BTW I still believe a Table is the way to go

declare @str as varchar(100)

set @str ='''c:m:0603r:mn '' '','' '' c:m:0703r:mn'''

SELECT @str , Replace(@str,''' '','' ''',''',''')