Viewing 15 posts - 1 through 15 (of 16 total)
Thanx Greatly !!!!
October 18, 2012 at 8:48 am
sp_helpfile
bc_Data1c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\bc_Data.mdfPRIMARY1681856 KBUnlimited10%data only
bc_Log2c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\bc_Data.ldfNULL3840 KBUnlimited10%log only
October 27, 2011 at 11:16 am
Now that I have fully wasted your time...I appologize. I went back into the database (after thinking because I usually don't just delete items)..I had renamed the field with...
October 27, 2011 at 9:50 am
The manager of that data decided that the field wasn't needed. Then after we deleted the field, it was decided that "well...actually-hold onto it" two weeks after the fact....
October 27, 2011 at 8:54 am
Thank you everyone !!!!
I'll try it...we have 28 change logs each in their own database that I want to make a lookup file to facilitate a lookup without having to...
January 6, 2011 at 3:04 pm
You're right...however, I should have explained more...it's not my database. I might be able to download it to my machine but its huge, etc. I'm relatively new to...
January 6, 2011 at 2:34 pm
Thank you for the info !!! Thant's exactly what I needed...we have over 10 users and later on...more. We need to upgrade !
April 28, 2009 at 2:04 pm
Terry...thanx for the link...it adds some light to the end of my tunnel. Most of my IT is VFP, VB, and MUMPS. I'm new to but getting there...
February 9, 2009 at 2:09 pm
Our system is a small database system written in VB and SQL, keeping all the data in SQL. It has a backup utility that backs up to the files...
February 6, 2009 at 1:41 pm
Our system backs up the data into the "bu" file. When the data is restored thru the menu system, the change logs are restored. However, the latest build...
February 6, 2009 at 9:41 am
Thank you !!!! It works very well. I took it a step further and used your suggestion to select into a temp file, then took that temp...
January 30, 2009 at 11:34 am
my table consists of two columns, NAME and YEAR. When the person visits, we record their name the current year. The queries I used/came up are in the...
January 29, 2009 at 1:44 pm
For a table called "ADDRESSES" with a column "NAME", the following will parse out the space-delimited NAME (the entire column) to its separate pieces into a temp table '#N2' ...
June 20, 2008 at 12:19 pm
You are so correct...I had worked out a solution in ACCESS by using the INSTR and MID functions, as well as column aliases to be able to work the data...
June 20, 2008 at 9:34 am
A quick way is to use the INSTR, MID, LEFT, RIGHT functions.
If your column is NAME,
left(NAME,instr(NAME," ")-1) will give you the first part
mid(NAME,instr(NAME," ")+1,50) will give you the start of...
June 19, 2008 at 11:19 am
Viewing 15 posts - 1 through 15 (of 16 total)