dan-572483 (9/27/2012)

---

If a database application functions flawlessly on SQL Server 2008, close to 100 percent is the likelyhood that it will also function flawlessly on SQL Server 2008 R2?

Given that...

diveshps (9/27/2012)

---

Laurie,

Thank you for your reply.

I guess if I force a cast to a decimal it will work since that is what happens when I add the "* 1.0" but...

SKYBVI (9/25/2012)

---

Hi,

I have installed sql server 2008 express edition with managemnt studio successfully on my local pc.

In the connect to server dialog box in starting...

options -->...

Lynn Pettis (8/17/2012)

---

cphite (8/17/2012)

---

I've been tasked with trying to set up log shipping in a blind scenario... that is, the source server and the target server cannot communicate with...

Canazei65 (8/15/2012)

---

Hi

Thanks for the replies - I shall take a look now. However, I should have made it clear in my post the financial year in the UK runs from...

Canazei65 (8/15/2012)

---

Sorry my previous post was incomplete (pressed some key combination that submitted).

Here's what I meant to say:

Hi

I have 3 parameters in my report:

[FinancialYr] in text format: '2011/12', '2012/13' etc

[FromDate]...

Was just wondering if anyone has found a fix to this issue... I am getting the following error when I open Activity Monitor. My account is a sysadmin...

rummings (7/25/2012)

---

A developer showed me a very small sql server t-sql script he wrote (5 SQL lines). It loads information into a SQL Server 2005 table. If he runs the...

Lucky9 (7/11/2012)

---

I have to create a SSIS package.

Where the data gets loaded from excel to Sql server database table....

excel file name gets updated every 1 hour...so after every 1 hour...

Steve-443559 (7/9/2012)

---

I'm using SQL 2008 R2 Reporting Services enterprise edition. I have a report which needs to be sent out to 500 or so different email addresses. The...

ELLEN-610393 (6/22/2012)

---

I thought that BIDS was basically opening VS with the SSRS Templates as a default project/solution type? We have a user now that has Visual Studio but does...

Correct.

In fact, aside from the lack of a preview feature and the different file extension,...

joshd 1807 (5/31/2012)

---

I wasn't aware you could put the case statements into the GROUP BY clause...that's interesting! I need to be more daring in writing code 🙂

Unfortunately the query doesn't...

I still have to disagree. We don't have the full picture here. How do we know if the individuals ssn is stored anywhere else in the database? Personally, it shouldn't...

Lynn Pettis (5/25/2012)

---

cphite (5/25/2012)

---

blampe (5/25/2012)

---

The countSSN procedure runs fine, but what I am trying to do is actually physically replace the values in the table with these count values generated...