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

    Trigger overhead?

    I can't give you anything directly constructive because, neither triggers nor user defined functions have given me much trouble on utilitization. But, I expect your problem is somehow due to contention for update and not resource utilization. One obvious possibility is that you may have a...
  2. harryrich

    I can see the files, but they aren't really there! =\

    At my location we've had some NTFS "ghost" files that would only go away following a system restart.
  3. harryrich

    Giving views a unique identifier

    You will likely find your solution at the client end. Access 2000 serves for the client at this site. It asks for a unique identifier when an SQL Server table is first connected to a database but the database retains that information and does not normally ask for it again. The protocol here...
  4. harryrich

    Run Job / DTS Errors

    When you manually start a DTS job the file access credentials come from your Windows logon and the SQL server credentials are as specified in the Enterprise Manager connection for that server. If you didn't get a logon dialog when connectiong to the server, they come from your Windows logon...
  5. harryrich

    Strange Behaviour in Table That Has No Key, No Rowguid

    There are a number of update situations both in ODBC and in trigger processing where things just don't work out if a table lacks a unique constaint. Probably the only way to prevent all of them would be for each table to have have a hidden identifier column. Meanwhile, it is probably best...
  6. harryrich

    ANSI_NULLS error message

    I can't speak authoritatively, but I seem to recall from somewhere that the procedure runs with the settings at the time of compilation. In other words, you might try running the two SET statements, compiling the procedure, and then setting the variables back to the values you want to default...
  7. harryrich

    Index Rebuild Fails on Table Exported from MS Access

    For some tables exported (straight export, no Wiz) from MS-Access 2000 the standard maintenance plan fails when rebuilding the index. The message was (and still is): [MICROSOFT SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server] DBCC failed because the...
  8. harryrich

    Sharing printers within DOS

    I don't have a solution for you. One work-around echwould to be to output to a file, and then use the START command to run a Windows application to print the file. Best, Harry
  9. harryrich

    Windows 2K Printing Password

    I don't have an answer for you but three possibilities occur to me. First, there are permissions on both the printer itself and its share. Anyone connecting to the printer has to pass both. Make sure they both make sense. I don't think they default the way they did in NT. Second, some...
  10. harryrich

    Set Toolbar Icon Size

    Rich, Changing the icon size in appearance does repaint the icons on the taskbar, but does not change their size. I went from 48 to 72, and, just to make sure pasted images of the task bar in paintbrush. Exactly the same size. It looks like the icons on the desktop, in the start menu, and in...
  11. harryrich

    Set Toolbar Icon Size

    I would like to change the size of the the icons in toolbars appearing on the taskbar. Anyone know how? Thanks.
  12. harryrich

    Compression

    The 2 to 1 compression ratio is an estimate for sources containg a typical mix of data. If the data you are trying to compress already has a high information densitiy, it may not compress at all. Maybe most of your data is already explicity compressed, or in one of standard media formats which...
  13. harryrich

    How many databases SQL 7 can host

    I don't know what the limit is, but each database has a separate data and log file and is registered in the master. With many database files, I would expect considerable fragmentation of the disk containing them. You will also need to be prepared for growth in the master and back it up...
  14. harryrich

    Installation problem

    I haven't run into this particular problem, but if you're using NTFS you have file security that you didn't have under 98. I'd check to make sure that the identity that SQL server starts under is a member of the administrators group for my Windows 2000 system. And if that didn't work, I'd...
  15. harryrich

    Problem Importing Access tables via DTS

    I had the same problem but didn't get much response from the group and didn't have time to fiddle with it. It was a one-shot, so I just exported text from Access and imported the text into SQL Server. I've also had success exporting from Access into an SQL database using ODBC. The former...
  16. harryrich

    Microsoft access 2000 to Microsoft access 97, Urgent

    This is the SQL Server group, and you should probably direct your question to one of the MS Access groups. I suspect that you are out of luck trying to get a an Access 2000 database with Access 97. However, if you can beg or borrow a system with Access 2000 installed it will likely do a good...
  17. harryrich

    IP Addresses as int

    I don't know enough about the varbinary to advise you on it. And, I don't know any way to get SQL Server to use unsigned integers. But, I advise against converting to 4 byte signed integer unless you have serious storage problems. You can easily lose more speed running things through...
  18. harryrich

    ? Running a Batch Process ?

    First of all you can put multiple SQL statements in a procedure, so there is nothing to prevent you from putting 15 update statements in your procedure. However, if you look at the CREATE PROCEDURE statement, you will see that procedures can have parameters, so you might simplfy things by...
  19. harryrich

    User ID and Password

    I'm using BENT 7.3 on a Windows NT server. The install prompted me for the User ID and Password of the identity BENT would be using in the network. Is there any way to change these without reinstalling BENT? If not, what information should I expect to lose in the process of reinstalling the...
  20. harryrich

    Automatically Generate Media Description

    See the help on the General tab of the backup definition dialog. If I read it correctly the system substitutes: %j the job name %d the date %t the time

Part and Inventory Search

Back
Top