In my (Quick) tests yesterday,in such a case, clearly the non leaves of NC Index were bigger than Cluster's.

But Leaves of NC were always smaller.

In another quick test, I managed...

/* Depends what the key is. If it's bigger than the clustering key or the index is unique, sure. If it's unique (ie the clustering key isn't needed at the...

Select * from sysprocesses where spid = @@spid

This one help you provide the details about the current connection..

check the results returned and add them to ur trigger..

Not possible without triggers / defaults.

SQL2008, CDC gives some options but not capture hostname.

And CDC is also way too expensive to be placed on production.

/* Offline, no. If your system is 24/7, then rebuild the indexes that you can online, if they need rebuilding, and only the ones that have to be rebuilt offline...

provide the most important queries and table structure..

Hi,

You will get that error if you use SQL 2k to check a SQL 2k5 file.

Can we know which version u r using..

Regards,

S.V.Nagaraj

I installed sp2 and its working fine..

Thanks brian and clive

Hi Brian,

Thanks for the reply . I cant find the option Reports when right click on

databases. Is it a 2008 option?

I am using 2005 standard edition.

Regards,

S.V.Nagaraj

Syscomments table's text column contains the script of sps,triggers and functions..

That may be partially smthng that u r looking for..

Hi,

Login is accessed thro a Windows Group. Rights are granted to a Windows Domain group on both the local and target server.

There is no permission denied for these tables.

Xyz is...

Err typo..

Even if u throw a few possiblities on when I get such a errror it will be useful to me

Hi Marsh,

Err..Currently I cant check it..but will let you know if can get hold of the domain admin to

do it or check it in anyother way..

Even If you thro'...

Hi Marsh,

Thanks for your efforts.

My responses inline.

I would just like to clarify a few points:-

1) When you say “delegation settings r done” does that mean you are using the Linked...

typo..

Problem occured when we moved from SQL to Windows authentication