Recent content by harryrich

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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