Search results for query: *

Hello all. I'm writing a script to add some lines to about 1200 text files. The script is done with one problem. I need to preserve the formatting in the orignial text files while adding the lines I need to add. The original file is formatted with spaces, either 2, 4, 6 or 8 spaces before...

Our DBA decided to take an "extended vacation" so since I'm the data manager I've been asked to take over his duties temporarily. The boss wants a list of all users in the database (no problem) and also what tables they have permissions to (problem) I could go through table by table...

Hello. I have a table (Columns) with three colums: Name, Length, Type that contains the info needed to create a new table. I know how to create a table in Query analyzer, but how do I programatically loop through the columns table to create the columns in the new table? I would do this...

I'm trying to fill a table with about 100 or so UNIQUE records so I can test a search function. I know I could just loop a stored procedure to fill it, but the data has to be unique. Short of sitting here manually entering is there anything I can do? Thanks in advance!

Howdy. We're using an .adp (Access 2k) for our front end with a MS SQL server 2000 db. Using a .mdb we had the reports getting data by creating, using, then deleting (after the report was created) access queries and pointing the report to the query. Now with the .adp, queries are gone. How...

I'm writing an app for distribution and need to use SQL linked tables. Going the file, get external data, link tables..works fine on my machine where I have the dsn set up and know the dsn name. My concern is someone installing this app and having a different dsn name. In that case the links...