Select the table and then go to table properties. Change your "Source Name" if you are in "Table Preview" mode or edit the sql code if you are in...

pharmkittie (11/20/2014)

---

I have a histogram SSRS chart already built but now there is a requirement to click on any of the bars to get the list of individual rows that...

You can't just temporarily stop transactional replication - it will attempt to resume where it left off. After all, it is attempting to be transactional - so it will...

I get the same as you...not "SP2" but the version number looks OK.

fliu2265 (11/13/2014)

---

Hello,

I created a parameter named @agency. For Available Values, I use OS as the label and agency code 559 as the value and also use IS as another label...

mfriessnig (11/13/2014)

---

we are impementating sql server 2014 for data warehousing. is this version stable?

we are going to start out with a 600gig hard drive. can anyone recommend a drive?

our...

To me, it looks like you are trying to get a value from a log table and assign it to variable @STARTTIME. When you use the EXEC command, all...

I think that the problem is because mirroring wants you to use fully qualified domain names (FQDN). TCP://tas:7024 is not. Simplistically, this needs to become something like TCP://tas.something:7024...

This

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

should get you started

Steve Jones - SSC Editor (10/6/2014)

---

Agree with HappyCat. I'd set up the same jobs on both servers, but disable the jobs on the secondary. If you failover, you can enable...

The reasons for installing the different services on separate servers is for performance and scalability. Database servers like lots of RAM (SQL and SSAS) and frequently I find that...

Maybe try a URL report action - have a look at http://stackoverflow.com/questions/17149244/how-to-open-url-in-ssrs-report-in-webpart-to-new-window. If you use a URL that renders a report, using the technique shown, the report...

Not sure whether you mean to show the parameter/field as a tooltip (when you hover over the field) or as something like a message box.

The tooltip is done...

When you add...

g.britton (10/22/2014)

---

I'm looking for a way to get the SQL Server Agent Job ID from within a stored procedure that is being run from SQL Server Agent, either scheduled or...