This works in Sql 2008 and above but fails in SQL 2005.

Instead of dropping and adding subscriptions, we may also alter the SP_MSins_<ArticleName> sp, in the subscribers by adding a condition at the start of SP, to check if the record...

the question is abot types of index structures but not about the types of indexes.

select * from mytable where rownum >=10 and rownum <= 20

The above query is fine only when rownum is a column in your table or...

hi sameer,

nice question.... you r question it self has the answwer..

The actual question asked is

A Primary Key is always enforced by a clustered index at creation?

which is not always...

Hi Nandini,

this is an internamtional forum and most of the members doesn't know about our great USA (United Streets of Ameerpet) :-). But for sure it will...

Okay..thank you...:-D

We have three types of dml triggers,

AFTER Triggers, INSTEAD OF Triggers & CLR Triggers

i am refferning to the below question posted,

What is the output of the following code (disregarding "X row(s) affected"):

CREATE TABLE TriggerTest (Value int)

GO

INSERT INTO TriggerTest VALUES (1)

GO

CREATE TRIGGER tr_TriggerTest ...

The above error occurs when ever you pass a negative value to the substring function.

EX:-

select substring('asdf',1,-1)

Server: Msg 536, Level 16, State 3, Line 1

Invalid length parameter passed to the...