SQL Noob (12/17/2007)

---

Matt Miller (12/15/2007)

---

Unless I skip that part in BOL, 1433 is not a telnet port, so telnet is going to fail....telnet is a specific application - so trying...

Simon -

there are 2 sites that get created in an SSRS setup. One is the "Report Manager virtual directory" and one is the "Report Server virtual directory". the...

Installing Enterprise will upgrade the standard edition. Enterprise should cover both instances.

Don't double-post.... It doesn't serve any real purpose, other than perhaps frustrating the regulars....

Thread to be continued over here:

http://www.sqlservercentral.com/Forums/Topic433813-338-1.aspx

Since you're in 2005 - you should look up the PIVOT syntax. It should get you started.

That will only work for one month of data. if the table has more than one month - you need to add to the group by.

This won't scale well, because...

Unless I skip that part in BOL, 1433 is not a telnet port, so telnet is going to fail....telnet is a specific application - so trying to get SQLserver to...

here's a thread on the MS forums that ought to help...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=949426&SiteID=1

Edit: I see adam already posted this... Anyway - you should probably look at the middle where they tabl about...

It's a strange combination. Yesterday I found myself accessing a 2005 server through QA (looking for stuff as you just were), and doing a lot of modification to...

of course - leave it to a C# programmer to re-rewrite the form, when he gives you the simplest solution in the first paragraph of his description (i.e. run query...

it's gone - it's been replaced by the filter in object browser.

However - all is not lost... Here's a neat little trick...

http://www.codeproject.com/KB/database/SqlObjectSearch.aspx?print=true

to follow on to Jeff's questions:

- Do you want to STORE just one instance of the combined row, or do you want to DISPLAY the combined "table" even if...

When you look under the services in the control panel, do you have SQL services listed? Since there seems to be a SSEE instance loaded, and that it's loaded...

Remember - it's fairly easy to attach a database under an entirely different name than what the files are created. Chances are - this is attached to your production...

I hate to say this - but (and I don't know HOW you would have this) are there NULLs in your identity field? It's not supposed to be possible,...