richardkel (12/12/2011)

---

...

Everyone seems to be saying don't use triggers, but how do you get the record keys into the staging table for the records that need to be transferred by...

[sarcasm]

As a firefighter sysadmin/dba, I cannot but embrace your choice of solution.

( insert in table a server a with a trigger to insert into serverb some table)

This will guarantee my...

Greg Edwards-268690 (12/9/2011)

---

ALZDBA (12/9/2011)

---

Nice article. And what's most important .... It will help people diagnose and solve this kind of issues !

With fixed ports, you can also register the spn...

Jeff Moden (12/11/2011)

---

Heh... It's a personal...

Darned, I even forgot that one, despite of my article "Me, myself and Powershell[/url]" :crying:

Thank you for bringing it up,...

The last replies have been to have a db per customer in your set up. That's the one I would go for for simplicity of management, upgrades, specific client tailor...

My rules of thumb for date/datetime data:

1) always store in the appropriate data type (date / datetime)

2) don't put functions on columns, so if you need e.g. 23 year old...

just my 2ct to add ...

it also depends if you have more than just NULL/0/1 ( e.g. you want to know if the data "is being prepared" or "is being...

your backup database command isn't initializing the bak file.

Things to check:

- the @BackupPath backup file name composition (as it still has the same name as the day before, and...

suppose _you_ know the matching criteria, and only want to know if rows defer ... have a look at checksum and only show rows that have non-matching checksum values for...

- How about windows 7/2008(r2)

- networking basics

- communication skills

Keep in mind if your date columns are of datatype datetime don't use BETWEEN but use

col >= @begin and col <= @end

SQLServer has an issue with datetime data typed...

except for the bad choice of the stored procedure name [SP] posting the code of the sproc would help us helping you very much.

Nice article. And what's most important .... It will help people diagnose and solve this kind of issues !

With fixed ports, you can also register the spn yourself ( after...

With your jobs, also keep in mind to check your db-state in a first step ...

cfr

if exists ( select 1

from sys.database_mirroring

...