I believe code smith is a tool for auto-generating SP's for a specific table to insert/update/delete data.

If the SP's have a comment in mentioning the name, then this tool was...

I am currently working towards 70-432 too and have gone for the Self Paced Training Kit.

Can you change the linked server properties?

If so, try changing the "Enable promotion of distributed transactions" to FALSE. This recently solved the issue for me.

Matt

You might need to use the SQL Server configuration tool to enable named pipe connections.

Try connecting via 127.0.0.1 instead.

Try adding some numbers to the end of the desired username. If it says unavailable I amm guessing its either a reserved word..or already in use!

I know a DBA who's title is "Director of information systems". Fancy but doesnt mean anything to me.

As GilaMonster said its your responsiblities that matter!

Hi,

I think a bit more information is required before we can help.

What sort of locks are you getting on your databases?

Not sure about matching the output of DBCC Log - I'll look into it.

With regards to the trigger. I wasn't really thinking. The Truncate does not actually delete data -...

What recovery mode is the database in? If its in full or Bulk you can use SQL Log Rescue:

http://www.google.co.uk/url?sa=t&source=web&cd=1&ved=0CBoQFjAA&url=http%3A%2F%2Fwww.red-gate.com%2Fproducts%2FSQL_Log_Rescue%2F&ei=g6p8TO2YN8K5jAeDqMnTDg&usg=AFQjCNG6Ya1KDoa6y1HcWl6JiUOFR420Lg&sig2=pVz3NU4o43eG2vXsCUoZZg

However, I don't think you will get hostname information from...

How do you mean into a different table?

Say you want to insert data from TableA into TableB you could do the following:

insert into tableb (Col1, Col2, Col3)

select AnotherCol1, AnotherCol2, AnotherCol3

go

Or..have...

You could possibly use a C-Tree ODBC driver:

http://www.google.co.uk/url?sa=t&source=web&cd=1&ved=0CBoQFjAA&url=http%3A%2F%2Fwww.faircom.com%2Face%2Fctpodbc_overview_t.php&ei=waV8TIbcDceOjAf06bTSDg&usg=AFQjCNGiuL503pYGLzc38-C41CpLNKRUWw&sig2=vay_a4OvWltF4Mi7yX3zeA

and create a linked server in SQLServer?

So you want to search the network for all SQL Server instances and return the name and version details?

If so, you could try SQL Ping:

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

Matt.

How are your subscribers connected - over the internet?

How big is your filtered database?

What sort of performance issues are you having exactly?

Is it the actual process of the merging that's running slowly? Are you using push or pull subscribers? Is the Distribution...

What type of replication are you using, Merge?