Is there a session variable? Microsoft please help

Is there a way to access a session variable for the url in reporting services? This is hard to explain, but our internal users access our website and view reports via one url, while external users use a different url to view the website and reports. I used the jump to url in some of my reports, but I need the report to read which url they came in on so that it can jump to the correct url that I need it to. Has anyone done anything similar to this?Anyone have any ideas? I use "jump to url" in quite a few of our reports w/ the link that it is jumping to being different information on our website. Our internal users see our website on a different url than our external users, so in my jump to link I need to conditionally set whether they go to the one url or the other, but I have to determine how they came in to begin with to determine which one they jump to.

Is there a session variable?

Is there a way to access a session variable for the url in reporting services? This is hard to explain, but our internal users access our website and view reports via one url, while external users use a different url to view the website and reports. I used the jump to url in some of my reports, but I need the report to read which url they came in on so that it can jump to the correct url that I need it to. Has anyone done anything similar to this?Anyone have any ideas? I use "jump to url" in quite a few of our reports w/ the link that it is jumping to being different information on our website. Our internal users see our website on a different url than our external users, so in my jump to link I need to conditionally set whether they go to the one url or the other, but I have to determine how they came in to begin with to determine which one they jump to.

Is there a good website with SQL Index tips?

I've created a few indexes on my tables but before I over-do it I wanted to see if there were any good websites out there with recommendations. My plan is to create clustered indexes on my primary keys and non-clustered for each foreign key. Also there are a few fields that are regularly searched so I will index them separately as well.

I don't want too many though because I know that affects the performance of record inserts. I'm also not sure about using multiple keys in one index.

Is there a good site out there with tips on what indexes to create or avoid, or have I pretty much covered it?Try this article:

http://www.sql-server-performance.com/optimizing_indexes.aspsql

Is that possible from live website sql record to " intranet " database ?

hi.

I would wish to know whether it is possible for me to program the code from html or aspx ( from web hosting server ) to our office intranet database which is window server 2005?

I had tried to google for more info but there are too complicated thing for me to understand.

Actually i am doing the web form feedback form from the website for the public to fill in and submit. i am using the mysql from web server to store the records from the feedback form.

We have another database in our server, ms server 2005 to store records in the intranet office only. i need to get the records from mysql to intranet database. i don`t think there is a automated scripting which allow u to auto update the intranet database from mysql( web server )

So i thought of one thing . program html or aspx to insert records directly to our database intranet . but how ?

I appreciated that.

Regards

newbie on aspnet.

You can do it by

Add a web service to your remote server to expose your table.|||Add a web service to your remote server to expose your table.Lock the web service site to only respond to the expternal IP address of your of your office.Write an application to consume the web service and update the internal table.|||

>But i think it is better to program aspx to insert records to intranetdatabase directly. or any alternate ? All database software are alreadyfixed, no change.

For the web application to be able to write directly to the local database will require opening up your firewall - this is not a good idea as it opens up the possibility of your intranet database being hacked. The solution I suggested requires only the HTTP and HTTPS ports to be opened. As the data is being dragged in rather than being pushed in, it is much more secure.

>All database software are already fixed, no change.
If the table is a pure log (records are only added), then the required information may already be be present. You would need to provide your table creation scripts for me to comment further.

Is SSRS 2000 compatible with any version of VS 2005?

I am awaiting my free VS 2005 Standard that I'm supposed to get for
viewing online videos on an MS website, and I am curious if SSRS for
SQL Server 2000 can be used with VS 2005'
Thank you, TomI forgot to search the list before I asked, I apologize...
It seems that RS 2005 is compatible with SQL Server 2000, and that RS
2005 will work with VS 2005, but is RS 2005 even available as a
separate download/install for SQL Server 2000'
I looked on the MSSQL downloads page and did not see it...unless it is
not a separate download...I don't expect my agency to be interested in
SS 2005 for quite a while.
Thank you, Tom|||RS 2005 is part of SQL Server 2005. You cannot get it separate. Any box
running RS 2005 must have a SQL Server 2005 license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tlyczko" <tlyczko@.gmail.com> wrote in message
news:1148307676.169124.284530@.38g2000cwa.googlegroups.com...
>I forgot to search the list before I asked, I apologize...
> It seems that RS 2005 is compatible with SQL Server 2000, and that RS
> 2005 will work with VS 2005, but is RS 2005 even available as a
> separate download/install for SQL Server 2000'
> I looked on the MSSQL downloads page and did not see it...unless it is
> not a separate download...I don't expect my agency to be interested in
> SS 2005 for quite a while.
> Thank you, Tom
>|||Sorry to hijack this. I have RS2000 running on my dev machine and would
like to be able to run RS2005 side by side with this. Is this possible?
I cannot uninstall 2000 as it used for dev of production reports and I
could not make any changes if I needed to?
TIA
Bruce L-C [MVP] wrote:
> RS 2005 is part of SQL Server 2005. You cannot get it separate. Any box
> running RS 2005 must have a SQL Server 2005 license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tlyczko" <tlyczko@.gmail.com> wrote in message
> news:1148307676.169124.284530@.38g2000cwa.googlegroups.com...
> >I forgot to search the list before I asked, I apologize...
> >
> > It seems that RS 2005 is compatible with SQL Server 2000, and that RS
> > 2005 will work with VS 2005, but is RS 2005 even available as a
> > separate download/install for SQL Server 2000'
> >
> > I looked on the MSSQL downloads page and did not see it...unless it is
> > not a separate download...I don't expect my agency to be interested in
> > SS 2005 for quite a while.
> >
> > Thank you, Tom
> >|||Both Report Designers can be installed side by side. RS 2005 comes with its
own version of VS 2005 so you do not need to purchase VS 2005 to run the
designer. However, if you want to create custom assemblies then you would
need to purchase VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"theaddict" <theaddict@.gmail.com> wrote in message
news:1148316677.949788.85080@.y43g2000cwc.googlegroups.com...
> Sorry to hijack this. I have RS2000 running on my dev machine and would
> like to be able to run RS2005 side by side with this. Is this possible?
> I cannot uninstall 2000 as it used for dev of production reports and I
> could not make any changes if I needed to?
> TIA
> Bruce L-C [MVP] wrote:
>> RS 2005 is part of SQL Server 2005. You cannot get it separate. Any box
>> running RS 2005 must have a SQL Server 2005 license.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "tlyczko" <tlyczko@.gmail.com> wrote in message
>> news:1148307676.169124.284530@.38g2000cwa.googlegroups.com...
>> >I forgot to search the list before I asked, I apologize...
>> >
>> > It seems that RS 2005 is compatible with SQL Server 2000, and that RS
>> > 2005 will work with VS 2005, but is RS 2005 even available as a
>> > separate download/install for SQL Server 2000'
>> >
>> > I looked on the MSSQL downloads page and did not see it...unless it is
>> > not a separate download...I don't expect my agency to be interested in
>> > SS 2005 for quite a while.
>> >
>> > Thank you, Tom
>> >
>|||What about publishing and running srs2000 .rdl files to sql server 2005? Is
this possible?
"Bruce L-C [MVP]" wrote:
> Both Report Designers can be installed side by side. RS 2005 comes with its
> own version of VS 2005 so you do not need to purchase VS 2005 to run the
> designer. However, if you want to create custom assemblies then you would
> need to purchase VS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "theaddict" <theaddict@.gmail.com> wrote in message
> news:1148316677.949788.85080@.y43g2000cwc.googlegroups.com...
> > Sorry to hijack this. I have RS2000 running on my dev machine and would
> > like to be able to run RS2005 side by side with this. Is this possible?
> > I cannot uninstall 2000 as it used for dev of production reports and I
> > could not make any changes if I needed to?
> >
> > TIA
> >
> > Bruce L-C [MVP] wrote:
> >> RS 2005 is part of SQL Server 2005. You cannot get it separate. Any box
> >> running RS 2005 must have a SQL Server 2005 license.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "tlyczko" <tlyczko@.gmail.com> wrote in message
> >> news:1148307676.169124.284530@.38g2000cwa.googlegroups.com...
> >> >I forgot to search the list before I asked, I apologize...
> >> >
> >> > It seems that RS 2005 is compatible with SQL Server 2000, and that RS
> >> > 2005 will work with VS 2005, but is RS 2005 even available as a
> >> > separate download/install for SQL Server 2000'
> >> >
> >> > I looked on the MSSQL downloads page and did not see it...unless it is
> >> > not a separate download...I don't expect my agency to be interested in
> >> > SS 2005 for quite a while.
> >> >
> >> > Thank you, Tom
> >> >
> >
>
>

Is SQL Expresss Production Ready?

I will be hosting my website in the next few months and doing more testing and I was having trouble finding a place to host the site that allows enough space for my sqlserver2005 database. I am estimating that the database will be around 40-50GB. Most hosting companies only give about 500MB for the database. Does anyone know of a company that provides more space? Also, is SQL Express production ready, or is it just for developing applications? If it is production ready, is there any "major" performace impact in using it over the full version. The reason I am asking is because hosting companies only give 500MB for a database, but alot more space for the web page. If I can put the SQLExpress file in the App_Data folder, then I will have more space. Does this even sound like it will work? Opinions are appreciated!

this is just off the top of my head, but I would think that, either more web page space, or more SQL Server space would always be available for a price, from a hosting company.

With previous hosting companies, once I'd reached the max, I was told that I could buy more space if I wanted.

|||

Thanks for the reply. From the companies I have looked at, they do offer more space but it only comes in small chucks(500MB) for an additional $5-$10 per month. I'm sure they would be more than happy to give me 50GB, but it would be hard on the wallet.

|||

I just realized that if I use SQL Express I cannot do hot backups. So I guess that is out of the question. But I'm still wondering what companies everyone else uses for hosting. Does anyone know of a place that allows for more storage for the database?

|||

A 40-50GB database is pretty large for a hosting company. You might want to consider something more along the lines of a VPS at that point.

|||

What is a VPS? To me 50G isn't that big. I mean storage is cheap these days. I work with multi-terabyte databases every day so I guess I expected a hosting company to support a 50G database lol. Thanks!!

|||

VPS = http://en.wikipedia.org/wiki/Virtual_private_server

|||

Thanks for the info. I did a google search and found many places that should work out.

|||

40-50G is a very small database when used as a data warehouse, ERP, etc. But for a typical web service that is actually extremely large. Remember that only a couple years ago that large hosting plans were for serving up 4-10GB of data transfer per MONTH. So having 40-50GB of data would be extremely odd to try and place in a shared hosing environment where the server is trying to handle 10,000+ websites.

Even a VPS may be too small for your needs, but it's definately a step up from a shared hosting plan. Of course if it is too small (or you outgrow it), it's usually trivial to move the VPS to it's own dedicated machine (or a larger machine). It's normally just copying a few files, and then changing a few configuration settings in the VPS software to allow your VPS to hog the whole box for itself.

|||

I think that VPS is a good place to start. The database will be smaller when I go live, but I expect it to grow up to 50GB in a short amount of time. I just want to make sure I have enough room and I have the flexibility to add more storage space for less cost then the $10 for 500MB that I can get with shared storage plans. Thanks for all the good info!!