Try with INSTEAD OF triggers.

When a table has this kind of trigger, data is not inserted by the statement directly, but you have to insert data from the INSERTED logic...

To set up the new computer name in SQL Server, refer to this FAQ:

http://support.microsoft.com/kb/257716/en-us

Q. Can I rename a server after installing SQL Server 2000?

A: Yes, you can rename a...

Why don't you simply use CHECK constraints?

Another way could be using INSTEAD OF triggers and insert manually only the rows that pass your test.

Generally speaking I agree that working with ISNULL() or COALESCE() to catch dynamic input parameters can lead to performance issues, but I found it useful in situations where I have...

I simply try to avoid it because I can't prevent the reporting tool from...

You could use xp_cmdshell to get this info, but be careful what you do with it, it could lead to possibile security issues.

If you want to use xp_cmdshell you will...

It depends on your DB size. We have small databases (under 100 Gb) and we prefer nightly full backups to keep it simple and reliable. We use Tivoli Data Protection...

GilaMonster (5/8/2009)

---

Not quite.

Log backups contain the log records since the previous log backup. Full...

If your purpose is to restore the whole db server (to protect yourself from hardware failure or that kind of disaster) you will have to backup system databases too. Obviously...

The cheapest solution is to link the servers and set up queries to compare data by primary key.

Quite a lot of work.

When you run the package from SSMS, it is run directly from your computer, but with SQLAgent it is run from the DB server. Check if there's dome firewall rule...

Maybe you mean track changes in data. If this is what you want there's Red-Gate's SQL data compare:

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

You could use ddl triggers to track changes in databse objects.

Take a look at this article:

http://www.sqlservercentral.com/articles/Auditing/62126/

Regards

Gianluca

The plan I prefer for backups is a nightly full backup and transcation log backup every hour, but it depends on your database size, user activity etc.

This fits my...

RBarryYoung (5/8/2009)

---

Yes, there are ways to do it, but they are a lot of work and they perform very poorly. In general if you need to dynamically specify the...