Well. Now that you mention it. 🙂

What is the corresponding object/property for the data file(s)?

Brett

Thanks opc.three,

That did it! I used your code snippet and installed the package you suggested and did the trick.

Thanks again,

Brett

I ran this with my info but am still having a problem. Here is the exact script I'm running (copy of yours with names changed):

Add-Type -AssemblyName “Microsoft.SqlServer.Smo”

######################################################################

$instanceName = 'BRETTW7'

$databaseName...

OK. Thanks. That's what I thought -- just confirming.

Thanks,

Brett

Yes, the error gives the table / FK info. I have a select that does this but was just wondering if there was an easier way to get this...

Hi Jannie,

I know that if there are no tables, replication can't occur. That is my question -- why are the tables, etc. not replicating. The snapshot is getting...

Thanks HTH,

I'm not seeing anything on the subscriber side.

I don't understand why it's creating the database as part of the initialization of replication but not replicating anything.

Brett

Hi Jannie,

I did check initialize. I'll try the tracer token. Will it work even though there are no tables, etc. replicated?

Brett

Hi Jannie,

Thanks for your response. The problem is that none of the objects (tables, stored procedures, etc.) are being created at the subscriber. It creates the new database...