Of course, if you were willing to pay for MSSQL, you could also look at Oracle or DB2 which both work on Linux 🙂

Good name! 🙂

If I understand it right, you want to see the original error, rather than 'SP completed successfully'?

This article contains code to rethrow an error from a catch block (usp_RethrowError):

http://msdn.microsoft.com/en-us/library/ms179296(v=sql.105).aspx

I use...

Cool, glad you found the solution. That'll definitely remove any attempt to insert duplicates.

Still odd that you were getting the FK violation rather than a PK one!

The WITH NOCHECK bit in the FK definition is a little worrying too - what's the value of is_not_trusted for the FK in sys.foreign_keys?

ozkary (7/27/2012)

---

Hi,

SELECT

FROM ddb_temp_DDB tdb

join accounts acct on acct.num_cue_s = tdb.num_cue_s

It looks that the join is finding more than one unique record on the accounts table. Have...

Hi,

What's the definition of the foreign key "CwFKaccounts2deposits_daily_balance"?

Thanks

Nic-306421 (7/27/2012)

---

"This is an opportunity to learn new/different thing and your answer will never be wrong if you read the related subject first. "

I dont think I would agree with...

OK, sounds like it's waiting for something rather than being blocked.

Did the monitoring people give you any details on the wait type field?

You say the proc runs parallely - just...

No problem!

ChrisM@Work (7/25/2012)

---

Quite...

Nearly there:

IF (EXISTS (SELECT 1 from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'r' and COLUMN_NAME = y ) and

(select charindex('k',@hdr_where))=0)

On the group properties dialog box there's a Page Breaks page - you can set Page Breaks between groups here.

It's a trade-off between performance and concurrency.

Staying at row-level locking allows other operations to perform on parts of the table not affected by the current query, at the cost of...

You could disable the logins one at a time and see if anyone complains! 😀

A logon trigger or switching on security audit for successful logins (which will supersize your event...