Search results for query: *

Hi all, I have two servers one new and one old. The old server is in production and must run as long as possible. The new server is supposed to replace the old server. What is the best way to syncronize these two server so that the new server can the same time as the old server is powered down...

Hi all, How can I use a tape device connected to another server? RESTORE DATABASE MyNwind FROM TAPE = '\\MyServer\tape0' ?? WITH NORECOVERY NOUNLOAD /Kent J.

Hi all, When I try to browse a asp file directly from IIS with the extension .asp (example: asptest.asp) then I get: 'The page cannot be found'. If I change the same file to suffix .aspx then there is no problem. I have checked the application extension and seen that .asp is present in the...

Hi all, How can I copy all my local DTS-packages and all my Jobs from my old server to my new one? /Kent J.

Hi all, I have a include file that I've used for years. But now I'm shifting to a new server and it doesn't work. The include file: <!--#INCLUDE FILE="../System/ConnKundData.asp"--> ================= Browser error: Active Server Pages error 'ASP 0131' Disallowed Parent Path...

Hi all, I have a backuped a database on a tapedevice from an old server that I would like to restore to a new server. I have created a new database with the same sortorder and name as the old one. When I run the restore command from EnterpriseManager everything looks good and I'll get...

Hi all, I have invested in a new server with Win2003. How can I import users, passwords and roles from my old Win2000 server to the new server? /Kent J.

Hi all, I have a server on a corporate network and I suspect a problem with port because the preformance is poor on some applications. How can I monitor that? /Kent J.

Hi all, I have a strange problem. I can connect to a table, and list records, with Enterprise Manager but not from Query analyzer. What can be wrong? Channel problem? /Kent J.

Hi all, I have a 136 GB database and for backup purpose I have a SDLT tape backup unit that can take 110/220 GB backup. This means that the unit can take up to 220 GB compressed data. So, my question is: can the SQL-server 2000 backup program compress the data? /Kent J.

Hi all, I have a pivotchart that shows the development of 25 customers. My problem is that it's very difficult to see anything with all lines criss-crossing each other. If I choose one customer at a time there's no problem with visiability. What I need is a macro, connected to a button, that...

Hi all, I have a textfile that I import to a table. I'm not sure I understand the difference between NULL and empty. Example: Item OrderNo LengthOrderNo 1 0 2 NULL NULL 3 1027612317 10 'Empty' or blank means that the field has something...

Hi all, I have a strange problem. SQL-server is up and running. For some reason i can not connect to SQL-server anymore. I can connect to it via remote control software but not via the EnterpriseManager. /Kent J.

I'm setting a textfile as a datasource. First I have to check if it exists. The end of the name can change so that's why I have to use a wildcard. Example: OTBRFC-E001_TST00005.txt should be substitude as OTBRFC-E001_TST*.txt How can I get a wildcard to work? Function Main() Dim oConn...

Hi all, How can I get a script in a DTS-package to accept a wildcard (*)? sFilename="OTBRFC-E001*.txt" /Kent J.

Hi all, I have a script that looks for duplicates and deletes them: ================================ select Cnt=min(Cnt) into #temp from Tbl1 group by BusinessPartnerNumber having count(BusinessPartnerNumber)>1 DELETE Tbl1 FROM Tbl1 k INNER JOIN #temp t ON k.cnt = t.cnt...

Hi all, I'm trying to loop all XML-files in a directory so that I can load the files, one by one, into a database. Below is what I have in a ActiveX DTS package on SQL-server. But I can't get it to work. ================================ ...... Set fso =...

Hi all, I have a bunch of XML-files that comes every day. I want to merge all these files to a big single file so that I can load the file into SQL-server one step. Below is a simplified version of the real file. Only difference is that BusinessPartner is repeated x number of times. <?xml...

Hi all, I have a bunch of XML-files that comes every day. I want to merge all these files to a big single file so that I can load the file in one step. Below is a simplified version of the real file. Only difference is that BusinessPartner is repeated x number of times. <?xml version="1.0"...

Hi all, I have a DTS-task below that basically updates two fields in a SQL-server table from a XML-file. The "Street" node exist on many records. The "DateSentAt" exist only once per file. But I want the value in "DateSentAt" to be in all records in the table. My problem is that the loop stops...