Are you using a password that does not conform to your Windows security configuration? Is the error message legitimate or objecting falsely to a valid password? Your posts...

Have you tried changing the order of your case statements to see if the results change?

Is it also possible that you're getting a default value assigned because of a step...

Without wanting to know corporate details or other 'secret' information, it sounds like you are trying to improve performance without having a clear idea what's truly wrong, other than either...

I'm confused. Are you trying to capture:

a) data changes

b) structure changes

c) code (aka stored procedures, views, etc.) changes

d) all of the above

The methods used to...

This may sound like 'master of the obvious', but here goes:

The more clearly you can define your objectives, the easier it is to choose between alternatives. Is the objective...

Atul, your version is later (9052 vs 9042) - are you suggesting that a bug fix has been implemented?

Operating system? version of SS2k5 (Express, std, enterprise...)?

Language settings? Sounds like a funky setting is getting impacted when you first open, then fixes itself upon closing. Or...

Nothing beats good design.

first question: Will you capture the who/what/when in the same table as where the table resides, or in a separate 'audit log' area?

second question: how...

bodhilove (12/3/2008)

---

Is there a way to change database context in a trigger?

For example. I want to use a login trigger to open a symetric key for decryption/ encryption in a...

Rusty -

If you use transactional replication, beware of the initial snapshot - it will overwrite your added fields. Also, each time you update a record in the subscriber,...

Yes, thank you, the scenario is clear. The challenge you are experiencing is, I believe, in how you set up the pull replication drawing from A3 to A2. ...

Sorry to take so long to respond - I've been away....

Anyway, to answer your question, let's pretend you only need the content used by the view:

Let's say that your view...

There is a difference between requesting a 'what' and requesting a 'how'. This sounds like a 'what' request - they want additional columns to correlate with a snapshot-replicated table....

What kind of replication are you performing? If not MERGE, then your subscriber will have to match publisher 100%, without regard for what was in subscriber before. There...

If you are replicating / synchronizing between 2 machines (simplest case), and one machine is down, what do you have to replicate / synchronize with?

I'm looking through the glass darkly,...