Search results for query: *

I think I figured out. It was a three fold problem. First, I was looking at the wrong stored procedure. @=) WHOOPS! Secondly, I had an IF/ELSE statement in the stored proc where the field count in the IF part of the statement had 2 more fields than the field count in the ELSE part. Thirdly...

I don't think the YYYY is invalid. Try changing the datepart to dateadd in your formula for figuring the year. Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?" -- Xena, "Been There, Done That"

Help, please. I have a location database on my machine (SQL Server 2005) which uses a stored procedure for my dataset. I have a remote database connection (SQL 2000) which has the same exact stored procedure. I go to "Set Database Location" to change which server I'm using. I create the new...

Why the page header section instead of just the label? Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?" -- Xena, "Been There, Done That"

Actually, the problem isn't the formula. It's where I put the label. Apparently it works when the label is in the group header, but the page header won't work. Darnit... Thanks, though, LB. Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No...

Any assistance that you can give me would be greatly appreciated. I have a label with the word "Detail", stuck in my page header, that I want to show up when someone drills down to the Detail line. The Detail line's property is set to Hide-Drilldown OK. The suppression formula for the Label...

Opps. I forgot to mention something. By default, the folder that saves under an Integration Services component is File System. Usually, it is set up to point to a specific location on the server. You can change this behavior by editing the MSDtsSrvr.ini.xml file usually found under Program...

You can't make changes to a package saved up to SQL Server. The only thing you can do is export the package back to your PC (unless you have it saved in Visual Source Safe or other versioning software), make your change and save it back up to the server. Here's how the encryption works...

It really depends on what you mean by "Admin". I have a windows user account (regular vanilla) that doesn't have Domain Admin privledges, but is SysAdmin in SQL which we use for my SQL Server Agent account. We change job owners to that same account so that everything is consistant and works...

All, I have just been notified about the following problem with SQL Server 2005 Service Pack 2. Hope this helps someone out. I don't think it affects plans created by programs like Litespeed Backup, but I'll post again if I notice that it does. Catadmin - MCDBA, MCSA "No, no. Yes. No, I...

It can be done and it should do some bit of automatic "upgrading" as you restore it to SQL 8 (SQL 2000). However, as there are T-SQL changes and datatype changes between 7 & 8, you might find some problems with procs, views, functions, and jobs if you don't go over them with a fine tooth comb...

You can only backup a SQL Server database to a local drive, or drive the Server thinks is local (like a SAN drive). The best way to take care of your issue is to backup the databases locally, then move the files to your network shares. You can do the move with a windows batch file or do it...

FYI: Don't know if you have it, but here's the link to see all the versions and what Service Pack they indicate: http://www.sqlteam.com/item.asp?ItemID=8318 I don't recommend uninstalling and reinstalling unless you're having major problems. It looks like you are, though, so take SQL Server...

FYI: I heard this problem was fixed with SSRS 2005, but we haven't tried implementing it yet. Which makes me curious. What version of reporting services are you using? Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more...

There are currently some issues with the 2005 integrity check plans (or at least, I'm running into issues) that promise to be resolved with SP2. But other than that, I think the 2005 plans seem to be much better, and have more options, than SQL 2000. Catadmin - MCDBA, MCSA "No, no. Yes...

Well, you do have to have the rights to change the service accounts, whether its on SQL Server or via the Windows OS Services box. However, as Paul said, I'd get a plain ol' vanilla non-user domain user account to use as your SQL Services account. The reasons for doing this are more than...

That would certainly do it. @=) Glad you figured it out. Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?" -- Xena, "Been There, Done That"

To follow Paul's advice, you'll have to remember 2 things. 1) You have to have SQL Server stopped and offline to do the renaming. If you don't, you might make the problem worse. 2) Try to get the model DB from a server that has the same setup as your current "problem" server. Such as a Dev...

All, Sorry it's been a while. One would think, with the new year, things would slow down for a while. Not so in my workplace. I'm beginning to feel like a fireman. @=) Anyway, I have an SSIS maint. package which does an Update Statistics job (only) on one production database. It's been...

You could use a regular IF...ELSE statement in T-SQL (look it up in Books Online). It's the closest T-SQL has to the IIF function. Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?" -- Xena, "Been There...