Search results for query: *

Hello, I've posted this item before, but no really solutions to solve this. I've some textfiles which i would like to import. In one textfile there are over 1024 columns when separated. This exceeds sql server's maximum columns. Let call this the resultfile. In the other texfile i've got a...

Hi, I have some files in different directies which i want to rename because they have the same names. The new name has a date then a "_" and then it's original name. E.g. 20041119_test1.txt. The root folder is "c:\results\" and the subdirectories are like "20041119-123456". Can someone help me...

Hi, I've a testpackage which i'm trying to adjust. What i would like is to import multiple textfiles (because there are files with the same name) and archive them. The package is from sqldts.com so i'll paste the activex scripts: Script 1 - Defining the Global Variables: Option Explicit...

Hi, Anyone can tell me which accespoint/router is better? I'm thinking to buy the usr805450 (with all turbo related devices )or the linksys new wrt54g speedbooster. I ditched my old wrt54g, because i think usr805450 is better. When i get me one of those models, i also will buy the same brand...

Hello, Can somebody help me with importing directories with their subfolders and files into tables. I would like to query some files with a particular extension and their size to make a capacity calculation.

Hello, I've posted this item before, but no really solutions to solve this. I've some textfiles which i would like to import. In one textfile there are over 1024 columns when separated. This exceeds sql server's maximum columns. Let call this the resultfile. In the other texfile i've got a...

Hi, How can i merge data from a database with a postscript? I would like to use a number from the database which in postscript should be formatted as a barcode on a specific location. Now i know it is a programming language, so if it requires some skill then i would like to know what the best...

Hello, How can i schedule to take sql server offline so i can ran defragmentation multiple times at night? I would be very greatful if i know to do this.

Hi, I have table where i have the following fields in datasheetview: id | date | image | question1 | question2 | question..N I would like to have it in this way: id | date | image | questionnr | answer 1 01-01-2004 test.tif 1 1000 (this is the value of field question1)...

Hello, Could somebody help me adjust my code below. I would like to automatically insert the record of multiple tables to another table. For each record, after the first four columns there should be an carriage return so that the records can be transformed. Here's the code: Dim rs As...

Hello, I've a form with a listbox where i want to pass the value of the listbox to the pass-through-query which then executes an stored procedure with an parameter. The problem is that i can make it work. I've done the following in the pass-through-query: exec usp_test...

Hi, I've some textfiles which i would like to import. The problem is that there are over 1024 columns when separated. This exceeds sql server's maximum columns. The data in the textfiles which i want to import comes from a datacapture software. When separated there are columns that represents...

Hello, I would like to know if it is possible to use postscriptfiles to merge with data in a database. Basically i have a table with serialnumbers which i would like to have merged in the postscriptfile. There is a dummy number in the postscript which should be replaced with each number in my...

hello, Can someone translate the following code into an stored procedure? I have not yet enough skills to do that. I can learn from it if i have an example like this code: Function splitnumberandadres(address As String, Optional zeroforaddress As Boolean = False) As String Dim strFree As...

Hi, I'm having trouble with triggers, can't let it work. What i would like to works is the following. I want to keep track of changes that users make on records. Therefore i create a trigger to 'log' the following items to the log table: [Tablename] [varchar] (50) NOT NULL , [Columname]...

Hello, I have some access mdb-files which i regurlarly import in sql server. The thing is i want to automate some steps during this proces. The mdb-files are from different companies but the datamodel remains the same. Before i import them, i'll append them to a temporary table with an extra...

hello, I was wondering how to track all changes on tables by using some sort of a history table. What i would like is a generic history table where i can see who updated, inserted, deleted or executed(stored procedures, triggers) what value in what table with a date when it was occured. Could...

Hello, I need some help with implenting the following: I recently migrated from access to sql server and i now i want to use maintainable permissions on my tables, views, etc. The access database will server as a front-end. I've created for testing purposes an testaccount with only a public...

Hi, I was wondering what the best way is to store the values of comboboxes and listboxes. Until now i always use an integer value which i store in a field. This works for a single choice option, but how about when i have a field where there are more than 1 choice available in a combobox or...

Hello, I was wondering is the following is correct with the network packet size. I've installed sql server 2000 and made some changes in the configuration. Now i've read that sql server's default network packet size is 4096 bytes, but when i look up the advanced tab in the enterprise manager...