Hi friend,

Do you have 64 bit sql server 2008 and sql server 2000 on 32 Bit ?

Then you need to create a stored procedure in master database of...

Hi Ravi ,

you are right , DMVs are virtual view it does not have its own data. it has limited data access.

Some DMVs takes data directly from query Plan Cache....

Hello Mak ,

I think you had restored the database by this procedure :

1- Take instance offline

2- Move mdf ,ndf and ldf files to target server

3- Reattach these files to restore...

HI Noman,

In distribution database you can run sp_browsereplcmnds with different parameters:

this sp takes data from MSrepl_commands table which is present in distribution DB for transactional replication.

MSDN link is

http://msdn.microsoft.com/en-us/library/aa239422(SQL.80).aspx

and for...

SA password changes is fully dependent upon your dependency on Login .

if you are using SA login in Replication ( changed login on Subscriber end), linked server ...

Dear KMPASS ,

It can be solved by very good article for all string related query

with the help of Tally table:

Wriiten by Jeff Moden

http://www.sqlservercentral.com/articles/T-SQL/62867/

features are:

Stepping Through Characters,

do the "Split".

One Final...

please use stored procedure like this to avoid this warning

create proc nameofSP

as

SET ANSI_WARNINGS off

your code

SET ANSI_WARNINGS ON