Search results for query: *

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

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

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

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

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

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