Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Catadmin

    Set Database Location not showing new fields

    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...
  2. Catadmin

    dates in Crystal XI

    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"
  3. Catadmin

    Set Database Location not showing new fields

    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...
  4. Catadmin

    Show PageHeader Label on Drilldown

    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"
  5. Catadmin

    Show PageHeader Label on Drilldown

    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...
  6. Catadmin

    Show PageHeader Label on Drilldown

    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...
  7. Catadmin

    SSIS and Security - need help

    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...
  8. Catadmin

    SSIS and Security - need help

    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...
  9. Catadmin

    Who should own jobs in SQL Server 2005

    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...
  10. Catadmin

    FYI: SQL 2005 SP2 Problem!!!!

    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...
  11. Catadmin

    Restore SQL 7 DB to SQL 8 - Possible?

    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...
  12. Catadmin

    SQL remote Backup

    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...
  13. Catadmin

    MSSQLSERVER service fails to start

    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...
  14. Catadmin

    Installing reporting services on another machine

    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...
  15. Catadmin

    maintenance plan, best practices

    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...
  16. Catadmin

    MSSQLSERVER service

    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...
  17. Catadmin

    Decimal Fields

    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"
  18. Catadmin

    MSSQLSERVER service fails to start

    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...
  19. Catadmin

    Update Stats job failing

    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...
  20. Catadmin

    IIF in sql server

    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...

Part and Inventory Search

Back
Top