Search results for query: *

Can someone point me in the direction of an in-place upgrade from 32 bit to 64 bit SQL Server 2005 Standard?? I am having a devil of a time finding documentation for this

Are there any gotchas or anything like that? Or is it as "simple" as running the 64 bit cd?

I have a server with the following specs and want to know if it is possible to do an in place upgrade from SQL Server 2005 32 bit to SQL Server 2005 64 bit... 2008 Enterprise but not R2 64 Bit OS with 32 GB of RAM SQL Server 2005 Standard 32 bit

Is it possible to sort in Report Manager while in List view? I have SQL Serve 2005 Reporting Services and am tryng to have all th folders show in the list view first and then the individual reports afterward.

Perfect! That will give me what I am looking for -- I was hoping to be able to write a query that would give me the same thing, but this will definitely work. Thanks!

This doesn't show if the report is using shared datasource. It shows the name of the datasource that was used when creating the report in VS. What I am trying to figure out is if there is a way to see if the Report is using a shared datasource (the first option under data sources in Report...

Is there an easy way (or not so easy way) to get a list of all reports that use a shared data source and the name of the data source?

Thanks everyone! This gave me what I needed.

I am a little confused as to what you are suggesting? Are you recommending I script out all the procedures before searching for that string inside the procedure?

I am looking for a way to query all my stored procedures in a certain database to find out if the string "set transaction isolation level read uncommitted" has been put in them... does anyone have an easy way to do this?

So how would I convey that in an sQuery or Stringbuilder??

Stefanwagner: Could you explain in depth a little more about your idea of using UNION?? The programmer ran the first select and then the other and I want to use all the information from the second select EXCEPT if the EMPLOYEE (id) = 12345 in the EMPLOYEE table. If EMPLOYEE (id) = 12345...

Thx for the explanation! Now back to the original problem... since I am trying to do an if statement in the second statement that would reference the first if statement - is it best to put it in a method and then call it unconditionally the first time and then call it conditionally in the...

What is the difference between sQuery and Stringbuilder/Stringbuffer?

My thought is that I may need to create a function with the first "select" statement and then call that method with no conditions and then in the second "select" statement, call the method conditionally? Am I on the right track?

Here is the second statement that pulls the employee table that if in this statement the emp id = then I want it to grab the EmpName from the first query Statement stmt = null; ResultSet rs = null; String sQuery = ""; try { stmt =...

I am attempting to modify someone else's code and I need to do the following... If employee id is 611481, then use the EmpName field in ReportMenu for the employee name, not the LAST_NAME, FIRST_NAME fields in the EMPLOYEE table. The code that already exists is: String sQuery = ""; try {...

How hard is it to configure Report Manager to access data inside a firewall from outside the firewall? We have Report Manager running on a webserver outside the firewall right now and need to access Lawson Test data inside our firewall.

That is quite interesting that an upgrade changes the mode to 8.0 even though it is a 9.0 server. I don't have a test server that I can test this... when I ran the original test, I did not have this issue. But when the production upgrade package was created and ran - it changed the mode. I...

This server was built as a SQL Server 2005 x64. I did detach and attach a 2000 database from another server to this one, but that should not have changed the compatibility setting from 9.0 to 8.0. The only thing that was done was a Great Plains upgrade on this server and I still don't see that...