Filter on Application Name with "Microsoft SQL Server Management Studio"

Interesting that you cannot see the log file in database property, can you post a screen shot of the database property?

Nope, you cannot set memory setting for Individual databases.

However if you have a serious requirement to do that, you will have to install individual instances for those database or...

Yes you can, but it is not suggested to do it, making it not possible to know if there is...

Not sure why that is missing, does it not give info regd the application or hostname, may be that can help track a bit more..

You should have a column in Profiler trace that can help you with the application name, database and many additional columns...

I have seen on multiple...

your best bet is to fire a Profiler trace and select only the event Audit Login Failed event, choose all columns and run the trace..

Have you configured logging inside the SSIS package? It gives more detailed information about each of the control flow tasks inside the SSIS package.

You can read a blog post...

I am not aware of any out of the box mechanism / feature. All I can think of is having another copy of the table (with _1 added at the...

Yes you are right, you cannot make changes to the Mirrored DB until it is the Principal, so your plan to setup DB Mirroring for making changes to databases (add,...

Nicholas Cain (2/7/2012)

---

Bru Medishetty (2/7/2012)

---

Have you clearly read the OP's requirement? He needs a mechanism to synchronize data from 3 client office databases to a centralized Server. In such a...

Have you clearly read the OP's requirement? He needs a mechanism to synchronize data from 3 client office databases to a centralized Server. In such a scenario how will Db...

I guess the OP is trying to know what is the best possible way to achieve this.

The only way I am aware is to have 4 data flow tasks and...

Unless there is a significant workload on the SQL Server which hosts the Publisher and Distributor, I am sure you can configure Publisher and Distributor on the same SQL Instance..