Search results for query: *

I have some Access forms in text format that were exported using "SaveAsText". I want to put these into a sql table using a varchar(max) data field. How do I load each text file, which has up to 1000 line of code, into a single record using the VARCHAR(MAX) field? Can the text in the sql...

I'm trying to do a simple FTP out of a Windows 2008 cloud server to a 2003 server. The file is created on the 2003 machine but it is empty. Error message states that it cannot establish a data connection. I am logged in as administrator. The same commands work well from any other machine...

Here is the actual code I'm running to copy data from one set of tables to another. The table structures are identical. SET @runCmd = 'INSERT INTO dbo.' + @dbTable + ' (' + @fldList + ') SELECT ' + @fldList + ' FROM dbo.' + @tmpTable EXECUTE (@runCmd) @dbTable is the new table @fldList is the...

Not sure if this is the right forum. Please advise me if not. Using LogMeIn I often transfer large files (500 MB to 5 Gb) to and from two of the servers in our rack over the internet to my machine at home. Server a typically transfers at about 300 KB/s Server b typically transfers as about...

I'm trying to export data from a table into a text file using Scripting.FileSystemObject in a VB module I don't want to copy fields that are Identity field or Computed fields. rs.open "SELECT * FROM SomeTable"... buf = "" FOR EACH fld IN rs.fields IF fld.type <> COMPUTED THEN IF...

Tbl_A fName fSex aKey Tbl_B fHome fSex bKey These two tables are inner joined on the aKey and bKey in a view (theVue) that outputs these fields: Tbl_A.fName, Tbl_A.Sex, Tbl_B.fHome (The keys and tbl_B.Sex are not included in the view.) The query is: SELECT * FROM theVue...

How do I go about finding other computers on my local area newtork? I can use FileSystemObject to search for drives, folders and files but It doesn't allow me to look beyond my own machine. Is there another method or catalog that I can use? (I need to do this programatically.) Thanks.

Not sure if this is the right forum but I'm programming in Access ADP. My program can use SQL Servers that are either on the local machine, on a server on the local network or a remote machine through an IP address. I need to copy files from the applications machine to the sql server machine. If...

I have two tool bars containing 32 items. Some are drop down menus with numerous items and sub menus 2 and 3 deep. I would like to transfer these to another adp file but nothng I've read about exporting user defind tool bars appears to be what I need. I would prefeer to export as text files and...

I'm importing text files that were exported from Access. Some included the identity field and some did not. So I need to know which files have identity fields in them. (The text files do not have all the fields that are in the SQL tables.) Dim cnn as new adodb.connection Dim rs as new...

When I run this code in Management Studio: DECLARE @tbl TABLE ( PID int, Chip varchar(7) ) INSERT INTO @tbl SELECT Pid,Chip FROM Runners WHERE LiveUpdated = 0 DECLARE @LocalSvr varchar(25) SET @LocalSvr = 'SQLSERVER.LocalLive.dbo.LiveRunners' DELETE FROM @LocalSvr WHERE PID IN (SELECT...

I've searched everything I can find but without a solution. I have 2 SQL servers: one with SQL 2000 and one with SQL 2005. Both on the same LAN. The 2000 machine is runnjing Windows server 2000 and the 2005 machine is running Vista pro (64-bit) The 2 servers are linked to each other and both...

I've spent the last 7 years building a MS Access project using MS SQL Server 2000 back end. The program code is over 75 Mb with Lots and Lots of forms, reports and modules. Now I'm being asked to convert the entire thing over to ColdFusion using the same sql database. (They want to make it into...

When doing an update to several records at one time the following trigger will fire on only 1 record. Consequently I have to use a cursor to update each individual record separately. ALTER TRIGGER Repl_Starts_Trigger1 ON dbo.Repl_Starts FOR UPDATE AS DECLARE @Pd integer DECLARE @Tm_G...

An Access program on my XP machine needs to be able write files to a folder on my Vista machine but I keep getting "access denied". I just spent the last 2 hours turning off ALL the security on the Vista machine that I could find. Still no luck and now my vista machine is open to everyone. I'm a...

I've got SQL 2005 Standard Edition (64 bit) on a Vista 64 bit machine. I want to manage it from my XP machine. I tried to install the 2005 tools on the XP machine but I'm blocked by the 64 bit SQL CD. Is there a downloadable version of SQL Server Management Studio that will run on my XP machine...

SQL Server 2000 is installed on 2 machines on the same LAN. One is running W2k Server and the other is running XP Pro. The following query will run on the XP machine but not on the W2K machine. SELECT PE_ID FROM OtherServer.database.dbo.PeopleTable Turning off my XP firewall doesn't help. I...

I created a publication and then a subscriber. The replication works fine. Then I generated a script to initialize the publisher/subscriber programatically. The publisher and subscriber are created properly but the snapshot agent won't start. Is there another command I can but into the script...

When I create replication in Enterprise Manager and select the snapshot agent to initialize immediatly it works fine. But when I run a script created from the replication it will not start unless I go into EM and reinitialize the snapsot agent. How can I get it to initialize immediatly from...

I'm trying to update records in a table on a remote server but I keep getting an error about too many prefixed in the WHERE clause. UPDATE RemSVR.RemDB.dbo.People SET OfficeID = Corporate.OfficeNMBR FROM Corporate WHERE RemSVR.RemDB.dbo.People.OfficeFloor = Corporate.OfficeFloor Can...