Recent content by cbhnp

If a stored procedure is dropped, a record would be deleted from the syscomments table. Would a log reader find that transaction to determine the user that dropped it? Or aren't transactions in system tables logged?

I can't tell you how to parse out the contents of the order/retail records. How are you doing it now? Couple ideas though... First, while your rewriting the file to a new import file with a consistant layout, you might try the Split function to separate the record into an array using the "+"...

Yeah, that's ugly... There's no way you can import that file without rewriting it into a layout that is standardized. 1) I would start with VBA or an ActiveX Task in a DTS. Here's some psuedocode: dim sOrder as string Open a new file for writing, OUTPUT Open your file for reading, INPUT Read...

It's an Outlook display thing. Think of it as trying to type a bunch of text into an email message without it wrapping. It's going to wrap.

I had a similar situation. I approached it in 3 steps. 1) Write the file to a new file with a useful format. Best speed is obtained by reading in 64K chunks. You can find help on this by searching on large file processing. Write out the data to a new file in 80 char lines. 2) Import the new...

BIGAL It's an addin we developed in house. The typical user can't load the addin in the way you describe because they don't have permissions to load their own addins. That's the hurdle we're trying to overcome. I'm thinking we may have to implement a Outlook Security Settings public folder...

We have group policy to prevent users from being able to install software. What we want is to deploy the Add-In through SMS as Admin so the limited user can use it. The problem is the user can't use it if the Administrator installed it. Is this typical or are we missing the boat on something...

Can this be true?

We're trying to deploy an Outlook 2002 COM Add-in we built in VB6 to users that are not Administrators on the local machines. When the user goes to Tool/Options/Other/Advanced/Com Add-Ins/Add and loads the Add-in nothing happens and the Add-in fails to appear in the list. Loading the add-in...

Looks like it should work. Are you sure that you, or the user the DTS is executing as, has adequate permissions to create a file at the destination?

Try importing the csv file into a staging table first. Then run an insert query like this: insert into customers select col1, col2, col3 from customers_stage cs left join customers on cs.cust_id = customers.cust_id where customers.cust_id is null I'm doing something similar now with...

Maybe I'm misreading this but it doesn't look like you need a global variable in this script. All you're doing is comparing the datetime stored in Col002/Col003 of the current record with the previous record. So only the first record needs to be compared to a previous file import. Global...

I was thinking the filtered recordset could be stored in a table defined as the source of the report. Version1 of the report could be run, the table emptied and repopulated with the next filter. That may not be the best solution though. A better idea, might be to set a global variable...

I use a xp_cmdshell and a command line interface to winzip to zip files. To move, copy, delete files use an ActiveX Script Task and the FileSystemObject.

Look into using ADO recordsets instead of the QueryDefs. Then you could use the recordset.Filter method. The Access GUI front end for building queries is useful but its not an object that you can manipulate with VBA. Dim rsData As ADODB.Recordset Dim cnDB As ADODB.Connection Dim db As...