How was the problem resolved? How to remove an unwanted and orphaned PRINCIPAL??

Thank you folks. Use Trusted in the SQLCMD is something we have previously missed.

Pursuant to this, I would be interested to know a way to produce a server-wide trigger [or...

Hi

Thank you for the messages.

We don't like using sqlcmd cos credentials too exposed. As above the question relates to our clients who are using SQL express Editions without Agent.

Was looking...

Thanks everyone for responses. JM - it's for clients with SQL EXPRESS Editions

TR

SQL 2012 Reporting Services - SSDS and Visual Studio - Development of reports to be embedded in ASP.NET web app or published on web via a viewer

Related to this topic, i notice that many DBs, including MS samples, have table columns like modifieddate, modifiedby & Co --

Is this really necessary?

Can this information be obtained from metadata...

Hi thanks for your reply to my questions. What do you think about his article for the job:

http://www.sqlservercentral.com/articles/Change+Tracking/74397/

Our customer tables to be synched contain max 100,000 rows

Thank you Erland for your reply. Here is a more articulate expression of what we are trying to do:

Using the the data samples below, is it possible to implement transactional...

Thank you Dwain,

True what you say.

I was trying not to use DROP per various blogs herein. Since posting I have done it this way.

USE <dbname>

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

declare

Helpful article Adam - thank you.

How can I use this to trace Queries and Sp activity?

Peter

Melbourne, Australia

Thanks everyone for interesting input on this topic.

I came in on this discussion midway seeking a method to obtain a unique [but not necessarily sequential] NextNumber value that is used...

That is sneaky! How would you manage the locking and multi-user aspects of this, ie to prevent thousands of calls per second retrieving the same ID?

Hey Steve,

I know this is an old posting but the problem of tempdb log growth seems to be a perennial issue.

Why should tempdb be set to SIMPLE recovery model?

In SQL...

Thanks Jeff for the informative reply.

Independently of this blog, we very quickly canned any further thought on ISOLATION LEVEL et aliter

All the tests we did with this were catastrophic!

We will...

Thank you for the feedback

Agreed, the IDENTITY column works fine for creating a unique RECNUM ID, but this type of process is required when creating a 'unique' sequential number that...