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

    Convert date range to seperate records

    I have this in my table: fields: id, create_date, end_date sample data: 12345, 9/12/08, 9/22/08 I need to turn that in to this: ID Date 12345 9/12/08 12345 9/13/08 12345 9/14/08 12345 9/15/08 12345 9/16/08 12345 9/17/08 12345 9/18/08 12345 9/19/08 12345...
  2. jamminjaymeyer

    Missing Historical Data

    Every now and then the histbd.mdb will stop gathering data. Not sure why, but does anyone know of a way to "rerun" a data dump that was lost. I am betting there is not a way but it is worth a try. :)
  3. jamminjaymeyer

    BCMSVuServer Error 1107

    I just took over this system and am having a few reporting problems. I get this error every now and then. Server: BCMSVuServer 1107 list bcms agent day : Column data in BCMS has overflowed switch display capacity. Although I can't prove this yet it seems that when this error comes up the DB...
  4. jamminjaymeyer

    Macro to insert $ in my formulas

    Does anyone have a macro that will insert a $ in each formula all the places there is a cell reference? so that I can move the folmulas without making the cell references change? Make sense?
  5. jamminjaymeyer

    Excel Macro - Adding If statement

    I have a number of cells that now require an if statement to be included at the begining. The macro code that I am trying to use is: ActiveCell.FormulaR1C1 = "=if(N7=0,0," & Right(ActiveCell.FormulaR1C1, Len(ActiveCell.FormulaR1C1) - 1) & ")" All of it work fine except the N7 reference. When I...
  6. jamminjaymeyer

    CallDetail Table

    Does anyone have a good listing of what calls get flagged as what in the call detail table? I am espically concerned about the cflag1 field and the call type field. I have the tables and fields document, that lists out the possible values but does not really explain what each of them are. Any...
  7. jamminjaymeyer

    Deleting a file with a SQL command

    Is it possible to delete a file on the harddrive with a SQL command?
  8. jamminjaymeyer

    Create DB on Mapped Drive

    I have a mapped drive on my SQL server that I would like to create a DB on and I can not get it to work. Is there a trick to this? It says my drive is not supported for database files "network drive not supported for database files" Any Ideas?
  9. jamminjaymeyer

    SMTP Cache Server for outbound e-mail

    Hello, I have a server that sends e-mail to another department's SMTP relay server, but their server is down a lot and not reliable. Is it possible, in IIS, to set up a cache server of some kind that would hold the e-mails and forward them on to the SMTP relay server when it becomes available...
  10. jamminjaymeyer

    Backing up DTS Packages

    Hello, I am pretty sure that the DTS packages are stored in the MSDB database on the server. Does this mean that if I am backing up the MSDB database are my packages being backed up also?
  11. jamminjaymeyer

    Transform from diff data source if first one is down

    Hello, I am looking for a way to test if my "primary" connection is down and if it is run my package from a different "backup" data source that has all the same tables and data. Is there an easy way to test if the "primary" DB is down?
  12. jamminjaymeyer

    DB Will not grow

    Thank you for the reply. I am running SQL Server 2000 with SP3 and all avail hotfixes and security patches since then. I try to keep very current on patches and security hotfixes. It is on a rather large IBM Win 2K server box with all the latest SP and security hotfixes. I have read the...
  13. jamminjaymeyer

    DB will not shrink

    When I try to shrink my DB the data file will shrink fine but the t-log will not shrink. It is only using 100 MG but it has 1.5 gig allocated for it. I would like to be able to free up that space. Thanks.
  14. jamminjaymeyer

    Can't Backup my DB

    I seem to be having a lot of problems with this DB. When I try to do a backup either manual or a scheduled one I get this error: BackupMedium::ReportIoError: write failure on backup device 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\CRData\CRData_db_200305080845.BAK'. Operating system...
  15. jamminjaymeyer

    GetOverLappedResult() Error when expanding db

    When I try to make one of the datafiles bigger for my db it gives the error: fcb::ZeroFile(): GetOverLappedResult() failed with error 2. Anyone seen this before? The command I am using is: USE master GO ALTER DATABASE CRData MODIFY FILE (NAME = CRData_Data, SIZE = 2000MB) GO...
  16. jamminjaymeyer

    DB Will Not Grow

    I have disk space available and I have the auto grow set to grow 10 % and unlimited growth but it still will not grow and says my primary file group is full. Any ideas?
  17. jamminjaymeyer

    Primary Filegroup Full

    What can I do when it say's "primary filegroup full"? I am trying to run a big DTS package that appends a lot of records. Thanks
  18. jamminjaymeyer

    Missing a transaction log

    Hello, I get a message: Server: Msg 823, Level 24, State 3, Line 1 I/O error 2(The system cannot find the file specified.) detected during write at offset 0x0000014b576000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\CRData_Data.MDF'. Whenever I try to do anything with the...
  19. jamminjaymeyer

    Can't find the transaction log

    Hello, I get a message: Server: Msg 823, Level 24, State 3, Line 1 I/O error 2(The system cannot find the file specified.) detected during write at offset 0x0000014b576000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\CRData_Data.MDF'. Whenever I try to do anything with the...
  20. jamminjaymeyer

    DB Restore says (Loading)?

    Hello, I tried to restore a DB backup to another DB name on the same server and now it just says "Loading". The restore job did fail on the last Transaction log backup but got most of the way through it. I just need one table out of the backup. Is this normal?

Part and Inventory Search

Back
Top