Search results for query: *

I'm using Oracle version 10.2 and have a query which contains many WHERE conditions, but one in particular I cannot get to work. Here is the code: where table.division_id in (CASE WHEN :Division = 'AA' THEN '02' WHEN :Division = 'BB' THEN '09' WHEN :Division = 'CC' THEN '07' WHEN...

I'm converting a report from Crystal Reports to SQL Server RS 2005, and I'm stuck on a multi-part, nested IF-THEN-ELSE structure that's necessary to display the data the user wants. I don't know if I'm trying to use too many nests, or if I can't keep track of the multiple ELSE's. Below is the...

Ah...good catch. I used manmaria's suggestion and looked up the properties of SERVERPROPERTY, and found 'LicenseType' and 'NumLicenses'. Guess what came back? "DISABLED" for every instance of SQL Server 2005 I ran it on, and "NULL" for license number. So...evidently Microsoft hasn't gotten...

Thanks for the suggestion. However, that still doesn't show me the license model (per processor or per server (seat/named user/etc)). I did call Microsoft's licensing department, and the "response" I got was that there is no longer a way to differentiate between per processor installs and per...

I'm trying to find out how to tell which license model was used when several SQL Server 2005 instances were installed. I tried @@Version, but it doesn't include information on whether it is licensed per processor or per server (with CALs). Does anyone know how to find this information on SQL...

Jay, I agree (and even more important, so does my manager :). Actually, the performance and function (mostly) of the SQL Server is fine right now, but you're right...it's never a fun feeling when something goes wrong (or "popping fire") it's never fun to wonder whether the behind-the-scenes...

Thanks Jay! I really appreciate all your effort to help. What do you think about trying to uninstall all service packs, and trying SP3 after it's down to just the base (RTM) install? Do you think there's any benefit in doing it that way, or do you think there's a chance that SP2 can be "healed"?

Jay, No, the E:\ drive is not the system drive. C:\ is system, D:\ is .ldf files, E:\ is .mdf files, F:\ is tempdb and G:\ is backups. And...I've already read the MS article about moving system dbs to "non-default" locations, and have verified that the master and resource .mdf files are in...

Weird" to say the least. So, I run the executable, and it creates the "hotfix folder" on the E:\ drive. (By the way, this server has 5 drives, so it actually does have an E:\ drive...) ??? Why it isn't creating it on the C:\ drive is beyond me (may not be significant, but I'm looking for...

Jay, I know it's an issue with the installer, and "thousands of folk" have had considerable problems with SQL Server installer since the release of 2005. If any portion of the installation bombs, it puts the "status" of the installer in a weird state, and it is incredibly difficult to change...

Jay, No, only one instance on the server. I can try the SP3 "redo", but don't know what that's going to get me, except seeing if it will allow the install to run again. I really need help figuring out how to correct whatever is wrong with the SQL Server installer.

SQL Server 2005, SP2 (build 3042) running on Windows 2003 Server (SP2) functioning properly. However, I need to install hot fixes that came out after SP2 on the SQL Server instance. Actually, now that SP3 is out, I'd like to install that. Here's the history: Installed SQL Server 2005 in June...

Paul, Thanks for the response. I don't think I've ever tried this before, so you may be right. The thing that really puzzles me is why it does work in the designer environment but not in the web-rendering environment. If the problem is that it's not getting a dataset at runtime, it should...

Using SQL Server 2005. I created an SSIS package that runs fine by itself and provides an ADO.NET recordset as output (Data Reader Destination). I then created an SSRS report that connects to that SSIS package as its datasource. On the Data tab in the SSRS designer, I can execute the query...

Mellenburg, RiverGuy is right, there is a preformed task in SSIS to transfer objects from one db to another, and there are even tasks to "upgrade" DTS packages to SSIS packages. And...not to pick on MS too much...because these tasks do work--IF you want to transfer all the DB objects, and IF...

Using SQL Server 2005 SSIS. I have created a package that imports a flat file, does some conversions and adds a couple of derived columns and then sends the output to a SQL Server table (works great). Now...I want to add logic in a step before the OLE DB Destination step that determines the...

Thanks for your responses. I found a pretty slick solution at ScriptingAnswers.com. Here is the function that a guy gave me (it's pretty cool!). Function Get-ScheduledTask { Param([string]$computername=$env:computername) #set to "continue to enable debugging messages"...

Lundkvist, Thanks for your response. I made the change to "Add-Content" and it didn't make a difference. Still only writing the scheduled tasks from the last server in the list.

I'm using a PS script to gather all of the scheduled tasks on a number of servers. I have the server names saved in a .txt file, and am referencing that in the PS script. The problem I'm having is that no matter what order I put the server names in, the output only shows the last server name...

MDXer, Thanks for your response. As I mentioned, I'm very new to SSIS, so most of your response doesn't mean much to me. Can you explain what a dataflow is? I looked in Books Online, but didn't find anything. I think I get the part about manually adding the output columns, and I assume that...