SELECT schema_name(o.schema_id) + '.' + name AS published_object, o.type_desc

FROM sys.objects o

WHERE o.is_schema_published = 1

or o.is_published = 1

-----------------------------------------------
--marcello miorelli
--adding the schema to the articles
-----------------------------------------------
  SELECT art.artid,
         table_name      = OBJECT_SCHEMA_NAME(art.OBJID) +...

• This reply was modified 2 years, 3 months ago by  jjradha.
• This reply was modified 2 years, 3 months ago by  jjradha. Reason: struggling with the formatting

I have solved this problem, without using external programs.

I have posted my stored procedure on the link below, it backups a SSAS database from a SQL Server server.

How can I...

Hi Theo,

I am successfully backing up SSAS databases following you idea.

It was definitely not straight forward, I had a few issues

as you can see here

and also here

But in my...

I have been currently using the following script to check if the identity column in my tables exist, and if so, is not for replication.

hope it helps

marcelo

SELECT OBJECT_SCHEMA_NAME(p.object_id) AS [Schema]

...

I have a very similar issue.

I am developing a monitoring tool,

And there is an incident I cannot monitor.

One of my users logged into an application to insert data into the...

Hi Martin,

have you tried to have a look at what shows up on

select * from distribution..MSReplication_Monitordata?

what is the status of your distribution?

it is a bit vague but that's where...

hi gents,

has this been sorted?

I have got the same error.

Message: Field size too large

thanks and regards

marcelo

merge replication

sql server 2005 64 bits

Message: The process could not bulk copy into table '"dbo"."MSmerge_contents"'.

2012-10-10...

hi there,

same error here,

it happens pretty often actually.

sometimes it soves itself out though.

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge...

Hi Steve,

I am having the same problem, would like to shrink my MSDB database in 2 of my production servers.

Apparently it has something to do with the log shipping I...

Exactly, that is another thing I was planning to do but I am not sure if the reindexing work works in bulks, if it does, then fine.

If not, then I...

delete from [webinterim1].[interim_KRISHNA].[dbo].[sales2]

insert into [webinterim1].[interim_KRISHNA].[dbo].[sales2]

select top 10 *

from [MM-SQL-002].webdb.dbo.SALES

webinterim1 = server (linked server)

interim_KRISHNA = database

MM-SQL-002 = LOCAL SERVER

webdb =...

This is how I had to do it.

It definetely works!!!!

USE msdb

EXEC sp_start_job @job_name = 'SHRINK TRANS-LOG SAS3800'

Regards

Marcelo Miorelli