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!

  • Congratulations strongm 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. DatabasePrincess

    Need Help Calculating Months Excluding Same Month

    Thanks for replying! :-) Actually, that's what I ended up doing and it worked! I also ended up using a table variable (since it has to be a function) and a CTE to make sure I don't count the same month twice. It's possible someone could take leave for one week in the middle of the month. That...
  2. DatabasePrincess

    Need Help Calculating Months Excluding Same Month

    SQL Server 2005 sp3 This is driving me nuts. It's probably a simple solution but I'm just not seeing it. We have a table of employment records like this (simplified): ID fromDate throughDate type ---- ---------- ----------- ---- 1 2009-08-02 2010-09-12...
  3. DatabasePrincess

    SQL Cluster Jobs Issue?

    Is it an active/passive cluster or active/active?
  4. DatabasePrincess

    Replication Monitor 2005 and 2008 – Publishers Missing or Deleted

    I have SQL Server Management Studio 2005 (9.0.4035) and 2008 (10.0.2531) installed on my computer (Windows XP). Today when I opened the replication monitor in SSMS 2005 connecting to a SQL 2005 server, all of my publishers (SQL 2005) were either missing or had a red X on the name. I re-added the...
  5. DatabasePrincess

    Recursive report based on manager of managers...

    What version of SQL Server are you using? If it's 2005 or 2008, there's a template regarding this sort of thing. It's called "Direct Reports Recursion Example". It basically uses a CTE (common table expression). http://technet.microsoft.com/en-us/library/ms186243(SQL.90).aspx Hope that helps!
  6. DatabasePrincess

    SQL 2005 SP3 Error 17310 Severity 20 EXCEPTION_ACCESS_VIOLATION

    Hello all! When I run T-SQL to drop and re-create a specific stored procedure on a development server, I get a stack dump every time and it disconnects my session from the server. Server Info: SQL Server 2005 SP3 (9.0.4035) Windows Server 2003 Standard SP2 2 GB RAM The procedure contains a...
  7. DatabasePrincess

    Rotate text so writing mode is from bottom to top

    Using Reporting Services 2005, does anyone know how to format a column cell in a matrix so that it reads from bottom to top? I have the writing mode set to tb-rl but it reads from top to bottom. Can this be rotated so that it reads from bottom to top instead? Any help is appreciated! Thanks! :-)
  8. DatabasePrincess

    Join Question

    Aha! Thank you both for replying. George, that example shows it perfectly! It makes perfect sense now! Thank you so much! :-)
  9. DatabasePrincess

    Join Question

    Thanks for replying. I know what you're saying. Here is some code to show what I'm asking. Which of the two statements below is better? select o1.name ,Address.streetNumber ,Address.streetName ,Address.zip ,Address.city ,Address.state from vwNam o1 left join dbo.Contact on...
  10. DatabasePrincess

    Join Question

    Hello all, I'm a bit rusty with database development and am hoping someone could help me figure something out. Normally when I write select statements with joins, I don't include things such as "and codeDeleteFlag = 'N' " as part of the join clause. I usually put this in a where clause. Is it...
  11. DatabasePrincess

    Legacy DTS packages

    I have yet to find a way to change the connections other than opening each one and changing it. Sorry. :-(
  12. DatabasePrincess

    Legacy DTS packages

    What I did was follow the instructions in the link below. I used the data pump task to copy the packages from msdb.dbo.sysdtspackages to the same table in the other server. http://www.sqldts.com/204.aspx It worked great for me. Hope this helps!
  13. DatabasePrincess

    Database Owner vs. DBO Permissions

    I don't think there's a difference, but I could be wrong. :-)
  14. DatabasePrincess

    SQL Server Agent Install 2005

    I believe that just because the Start, Stop options are greyed out that doesn't necessarily mean the Agent wasn't installed correctly. I'm looking at one of my 2005 installations and the agent is running fine even though the Start, Stop options are greyed out. Have you checked the...
  15. DatabasePrincess

    Prevent Administrator from using database

    One option could be to encrypt the actual data files using something like Windows File Encryption System. Another option would be to secure the server or computer the files are on to prevent someone from getting to the files in the first place.

Part and Inventory Search

Back
Top