Recent content by jonwolds

Hi, Is it possible to export data from sql server using fixed width format to be read into excel? When I select a fixed width export the data in the text file is not formatted into columns. At the moment I am having to export from sql as .csv and import into access and then re-export as fixed...

Thanks. I'm going to move them. If you are interested in this topic please also refer to: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=308628 Jon

Hi, Is it worth moving the system database data and log files from the default location on the c:drive to the disks set up specifically for sql server data and log files? Thanks Jon

Hi, We have a new Small Business Server which will host SQL Server 2005. The SQL Server instance will be used for an ETL solution and will hold 2 databases that have heavy read/write processing and 1 that has minimal read/write processing. Databases are about 4 gig in total. The server comes...

Thanks for your response. Please could you elaborate? Jon

Hi, Can SSIS be used to implement the following: 1. Each company will supply a monthly text file. 2. A companys file format will be the same each month. 3. No two companies will use the same file format and column orders/number of columns as each other. 4. I want to poll a windows folder...

Hi, I have SQL Server 2005 client tools and Visual Studio.net 2003 installed on my pc. Hi have associated .sql files with Management Studio "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe". When I double click a .sql file to open it I recieve the following...

Hi, I have SQL Server 2005 client tools and Visual Studio.net 2003 installed on my pc. Hi have associated .sql files with Management Studio "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe". When I double click a .sql file to open it I recieve the following...

Hi, I have created second data and log files for tempdb on a seperate disk to the originals. Does anyone know whether SQL Server will use the first data and log files until they are full and then move on to the second files? The idea is to use the second files as 'overflow' files. Thanks Jon

Hi, I have installed Virtual Server 2005 R2 on my Windows XP Pro machine. I have created a W2K Server virtual machine which I have set up as a domain contro ller. I want to network the host to the guest but I am having problems. I tried th e following: 1. Installed the ms loopback adapter on...

Got it to work by using 1040:768. Not a great resolution but beats 800:600. Thanks for your help. Jon

Hi, OS - WinXPro Graphics card - geForce4 ti 4200 128 meg (Lasted drivers) PC - TV - Svideo to scart using the clone setting in Nvidia NView. The cloned pc image on the TV is too large for the screen and I cannot shrink it unless I change the monitor resolution to 800:600. Is there another way...

I think the problem was being caused by data being written onto the same drive that Itunes was reading from. I will monitor this to confirm the problem has been solved. Thank you all for your help. Jon

("When nothing is running on the system, performance is fine (except Itunes still stutters).")

Yes