BIDS is an extension of Visual Studio, so Pro Edition VS might have what you need. I'm not sure about that.

BIDS is not the same in 2005, 2008, 2012....

I'd use a DDL trigger for that.

Details here: http://msdn.microsoft.com/en-us/library/ms175941.aspx

Events available for them to fire on: http://msdn.microsoft.com/en-us/library/62ef24b4-3553-4aed-b62a-670980bae501

That sounds like some setting in the connection to Exchange, on your phone, is doing something like converting to plain-text format. Check the settings on that. Check with...

Same thing I say every time this comes up:

Don't do date formatting in the data layer. Do it in the application. Works MUCH better there.

There isn't a native tool for that. You could schedule a job that would periodically check the CPU level and do what you needed if it found it out...

I guess it would help to know what the problem is. You say they work "just fine" alone, but "have a problem" when fired in tandem, but you don't...

They need Business Intelligence Development Studio (usually called BIDS). You can install that from the SQL Server installation disk, just choose the Client Tools option when asked what to...

Here's a solution that will do all the SQL work in one go:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T;

CREATE TABLE #T

(ID...

CDC is A way to go, not necessarily the way to go.

It has some limitations. And, as far as having zero impact, that's partially correct. It doesn't extend...

Can you provide a sample and definition of the data?

You say it's in decimal format, but don't define what the integer part of the number is nor what the decimal...

You'll have to clarify that.

In most cases, Read Committed will peform just fine. In a few, Read Committed Snapshot, or Snapshot, will perform better. In a few...

opc.three (11/19/2012)

---

GSquared (11/19/2012)

---

Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow accessing tables directly,...

Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow accessing tables directly, then synonyms...

Chrissy321 (11/19/2012)

---

I might want to prepare a report for management detailing the state of the database and recommended actions. I would be careful here not to be judgemental, just the...

Most of the time, Read Committed (the default level) will do what you want and is "the best". If you have specific needs, then pick something else, but, most...