Glad to help. You should be fine!

just use client code to get the results from the stored procedure or use OPENROWSET.

Here you go:

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/17/10-0-plan-cache-flush.aspx

Any restores, lately?

Cheers,

NEWID() is used to general GUID values which are supposed to be globally unique values.

It is normally used in tables that Identify records using such values.

The use of it on...

Karthik,

The problem with what I posted is that regardless is a full table scan. Nolock will minimize the impact on others by not creating a shared lock in the entire...

not very performant but you could try:

select top 5 *

from [your table] with (nolock)

order by newid()

What *ususally* happens for batch inserts is that client side gets the limits and prepare the inserts there.

If the need arises to do it on the server side we...

Once againg you lack of knowledge is revealed.

DDL changes are supported in SQL Server 2005 replication.

Please can you just stop "trying" to guess stuff.

Once again you are showing inexperience. If a single database fails over and you have a "view" pointing to another of the set what would you think happens ?

Please refer...

np

I know the feeling. Sorry you have to have PKs or use Merge but Merge is probably too intrusive for PS

If you have decided to remove replication settings try:

sp_removedbreplication @dbname = 'dbname'

On the publisher database.

Cheers,

These are the steps:

1. EXEC sp_MSenum_replication_agents @type = 1

from there extract snapshot Job name that belongs to the publisher_db you are interested

2. EXEC msdb.dbo.sp_start_job @job_name = @SnapshotJobName --...

SQL Server Transactional replicattion *requires* primary keys, Period.

You could try to use DB mirroring but I am not sure it fullfil your needs, Do you need the replica as a...

1. try: dbcc sqlperf(logspace) to figure out how much free space you have on the log.

2. TRUNCATE_ONLY is deprecated in 2005 so you have to backup the log. If...