Recent content by tonykblen

Hi James, Because we use an ERp program that uses trusted logins and windows authentication is allowed, I can't really use SQL server logins. Do you have any other ideas? Cheers, Tony. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is half the work. Every start is difficult . -Two...

Hi, I would like to know what the best way would be to prevent certain users/user groups from accessing databases in SQL Server. I was thinking of deleting the odbcad32.exe file in order to prevent access, but am unsure as to whether there is a method with more granularity? Any help on this...

Forgot to put the formulae in: In a formula called @Weighting {mfgorder.mor_producedqty}/Sum ({mfgorder.mor_producedqty}, {itemspec.its_route}) - This give the weighting calculation for each manufacturing order. This gives me a correct basis to calculate the yield {@FillSize}*{@Weighting}...

Hi, I am tryiing to create a report that calculates a weighting based on the following formula: Order Produced Quantity / Overall Machine Qty I then want to take this and multiply it by a yield percentage. I have been able to do this but cannot total up either column. From reading other...

Hi, We have a SQL server db backend for our ERP system. I have written a Crystal Report to extract data from one particular table called itemspecbomw which contains amongst other things Bill of Materials costings. When I run the report I know that some rows are missing as when I look at values...

Hi Nigel Many thanks for that. That has done the trick! The procedure now is: CREATE PROCEDURE dbo.changedbname ( @dbname varchar(80) ) AS Select * from zxsystem where zxg_property= 'dbid' Update zxsystem set zxg_value= 'sqlserver-' + db_name()where zxg_property='dbid' Select * from zxsystem...

Hi, I have a stored procedure that updates a single record. Instead of me having to pass in a parameter with the database name, I want to use the stored proc to rename any database with the following syntax: sqlserver-*The name of the database* Currently I hard-code the first part of the...

Thanks very much Mosaic1, My only question is where do you run the script from? Is it the startup menu so that it executes each time on start up? Otherwise looks great! Cheers, Tony. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is half the work. Every start is difficult . -Two...

Hi, Is there a way of popping up a message box that can be customised to display a warning message to users when IE is loaded up? Can the same thing be done for Outlook? I am aware that a message box can be displayed when logging on to the domain but I want to do this when an application is...

Hi, I would like to know whether there is a way of bulk deleting maintenance plan history from SQL Server 2000. Can I use a delete SQL statement in order to do this without having any adverse effects elsewhere? Many thanks, Tony Kennedy. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is...

Thanks for your reply combo, I'm afraid it happens with any kind of a file name or even if you create a new file and want to save it. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is half the work. Every start is difficult . -Two Gaelic proverbs

Hi, The following error message appears every time a user presses the save icon in Word. [Project]_ Save Doc ERROR: 52 Bad File Name or Number The only way the user can save is by using the X button to close the file and then save. This is the second time this has happened. I cured it before...

Hi again, SwampBoogie thats worked a treat but a little explanation as to what the query does would be great. The use of an alias for the inner select I can see but can you elaborate on that please? Many thanks to you and SQLBill, Tony. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is...

Hi, I have query like this: select isx_transaction,isx_item,isx_itemspec,sum(isx_materialcost) from itemspecbomw group by isx_item,isx_itemspec,isx_transaction order by isx_item,isx_itemspec,isx_transaction which returns: Tr. Num Code Spec Cost 44300 FCH0001 1 1.87042 45258 FCH0001 1...

Hi Garry, Would appreciate it if you could take a look. Please give me the e-mail address. Cheers, Tony. Tony Kennedy BSc. B.I.S., MCSA Cand. A good start is half the work. Every start is difficult . -Two Gaelic proverbs