I think you need to be a little more specific about what it is you are trying to do. Are you looking for columns with just a single space and...

There are no definitive rules on how you should size the database log file. If I may bore you with my past, back in 1993 I was sent off to...

Have a look at using sys.fn_my_permissions, e.g.

execute as user = 'put your username here'

select*

fromsys.fn_my_permissions(NULL,'DATABASE')

revert

go

This link may help:

http://msdn.microsoft.com/en-us/library/ms176097.aspx

Try sp_helprotect. It accepts a number of parameters one of which is @username.

Mike

Presumably, this is the distribution agent applying a snapshot? At my subscribers I don't create the foreign keys. I'm happy that if all is well at the publisher then all...

No problem. Glad it's fixed.

Regards,

Mike

In Enterprise Manager

Highlight the name of the publisher

click on Tools on the menu bar

Move the mouse to Replication > and over to Configure Publishing, Subscribers, and Distribution then click

Dialog box...

You can view the full command by running sp_browsereplcmds on your distribution server since the GUI probably does truncate the command. Something like this should work:

USE distribution

GO

DECLARE@iPublisherIdint,

@iPublisherDatabaseIdint

SELECT@iPublisherId = srvid

FROMmaster..sysservers

WHEREsrvname= ''...

I know this seems crazy and apologies if you have already tried this but in the call to sp_addsubscription change @article = 'nbdocdeletedrecords' to @article = 'all'. I haven't got...

Try

DECLARE @sql varchar(255),

@db varchar(32)

SET @db = 'Test'

SET @sql = 'ALTER DATABASE ' + @db + ' SET...

The distribution agent cleanup job removes rows from msrepl_transactions and msrepl_commands which have either been replicated or are beyond the retention period so it won't have cleared out the distribution...

The “action if name in use” option controls the behaviour of the snapshot agent. In my situation (transactional push subscriptions) I’m lucky because my publishers are simply logging servers situated...

Dzordz,

What you are doing is absolutely standard stuff. I have over 300 publishers publishing data to one subscriber. Without being able to see your set up it's difficult to give...

You need to assign a column name to @ar in

select actper, idcontract,@ar, 'client' as category from tblsperfclient

union select actper, idcontract,@ar, 'Dos' from tblsARAgedDOS --AR

union select actper, idcontract,@ar, 'Doe' from...

This is often a login problem. Presumably you have logged on to your Subscriber and have been able to open a Query Analyser session to your distributor using the login...