Search results for query: *

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

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

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

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

Current set up: P4 2.4ghz, 1gig ram, The 3 physical IDE hard disks and dvd writer are set up as follows: 1st channel C: WinXP - master (80g) F: My Documents - slave (200g) 2nd channel D: Program Files - master (80g) E: DVD Writer - slave I am getting some performance problems, which I think...

Hi, If there is a problem with a database data file why does bol/exam guides advise me to immediately back up the transaction log using NO_TRUNCATE? I understand that you need to take a log backup to restore the database back to its current status but why not clear out the inactive...

Hi, If there is a problem with a database data file why does bol/exam guides advise me to immediately back up the transaction log using NO_TRUNCATE? I understand that you need to take a log backup to restore the database to its current status but why not clear out the inactive transactions...

I used master.dbo.xp_restore_log to restore a transaction log to a database in standby mode and specified that the standby file be recreated in the same location (H:\). The restore worked but moved the standby file to C:\WINNT\system32 Anyone know why it would do this? Is it some kind of...

Hi, Is the following correct: 1) For a clustered index the last intermediate level in the b-tree points to the leaf level data page (but does not point to the exact row in the page). 2) For a non clustered index the leaf level in the b-tree points to the page and row in a data page. Thanks Jon

Hi, I need to create an NT (Kerberos) Linked server across 2 domains. Server 1 - DOMAINa\Test1 account Server 2 - DOMAINb\Test2 account Both accounts have sa permissions. Is it possible to map these accounts together so that the linked server works? Thanks Jon

Hi, I need to create an NT (Kerberos) Linked server across 2 domains. Server 1 - DOMAINa\Test1 account Server 2 - DOMAINb\Test2 account Both accounts have sa permissions. Is it possible to map these accounts together so that the linked server works? Thanks Jon

Hi, I have created a time dimension from my Time_Dim table which stores dates upto the year 2030. I only want to display dates in the dimension which have corresponding data in the fact table. What is the best way to do this? Thanks Jon

Hi, I installed a usb modem on W2K Server and am receiving Event ID: 4311 error when rebooting. I have uninstalled the modem but the message is still appearing. Event Type: Error Event Source: NetBT Event Category: None Event ID: 4311 Date: 11/08/2005 Time: 07:29:43 User: N/A Computer...

Hi, I have connected my W2K Server to a hub, created a static ip and subnet address, pinged the server successfully. When I run the wizards to install DMS, AD and domain controller the installation fails with the error "the network location cannot be reached". I have no idea what the problem...

Hi, I have connected my W2K Server to a hub, created a static ip and subnet address, pinged the server successfully. When I run the wizards to install DMS, AD and domain controller the installation fails with the error "the network location cannot be reached". I have no idea what the problem...