Search results for query: *

I'll leave the original message up as a monument to stupidity. I was trimming the damn spaces myself earlier in the code....

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

Never mind! I just wrote a quick routine in Access/VBA to loop and do it. I was hoping I could learn to do it in T-SQL, but time is $$ ;). Here's the code if anyone's interested: Private Sub Command1_Click() Dim cnNow As ADODB.Connection Dim rsNow As ADODB.Recordset Dim...

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

whoah...quick reply..thanks :) 42 columns. It's a patient registry that contains patient info, so just about every data type is used. I can export data into a .dba file from the old application, but many of the variables are diffferent. Other than that, I have nothing with similar data.

I'm using SQL 2000 so this may not be the same, but I thought I'd see if it helps. In 2k, if you right click on Data Transformation Service there is an Open option. I use this and it opens the .dts file in designer.

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

Okay, I think I may have found something that will help me. Q209862 in the MS Knowledgebase.

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