Search results for query: *

Hi there, If you run the DB on SQL 7/2000 server a good tip is to start the sql profiler - do some regular task (browse for files, backup files aso) - and then go for the Index tuning wizard which will really improve the speeds. We used VLDB for quite some time and ran into alot of problems -...

I am going through the network setup now and i've found some strange settings. You should happen to know the difference between EC=1 and EC=10060 ? I think that EC=10060 refers to the WinSock error 10060 (timeout) but the EC=1 is still a mysteri.

The first thing i would do is check the backup log. Which servers take a long time, is it only 1 server that spend 15 hours backing up or is every server "equal" in time ? This would be the first thing i would check and then continue with my findings in the log file.

I am having problems with Arcserve 2000 SP4 running on a w2k server. The servers that i am backing up is running NT 4.0 SP6a with remote agent. The problems is that the backup is "50%" done and i receive and E8522 error. The problem appears after a few hours of backup when i receive...

I would have checked the service account that runs BE. If it's not specified it's the localsystem account, try change this to an user that has rights to the remote server. Another option is to use the PSEXEC utility from www.sysinternals.com in a script like this: @echo off psexec \\LPFCH-EXCH...

Had a similar error code "E6084 Drive Hardware Error-Servo or Sensor.." with a Storagtek tape-library. The error message was gone when i cleaned the tape drives. Hope this helps

There is a function called ISNULL that will return a value specified in the query when the row is null. ISNULL ( check_expression , replacement_value )

There is a &quot;function&quot; called locking but this includes creating a directory called /COM1 /<and some directory> (COM1 and a space) on the NT box. To access the &quot;COM1 &quot; folder one will have to knwo the subdirectory as COM1 is a function reserved for the communications port 1...

I've checked the books online on the DATEDIFF function and it pointed me to the DATEADD function. Could you write the query with a string like : &quot;select * table where table.date >= (DATEADD(mm,3,getdate()))&quot; ?

You could use the NET SHARE command to share the directory. NET SHARE BOND$=D:\USERS\BOND /REMARK:&quot;James Bond&quot; The part about the batch script where the users enters the share name is a bit tricky. How much rights has the user to the &quot;d:\users&quot; directory ? Should they...

This has not been tested, and you will probably need some sort of admin rights on the SQL server to perform this (right to xp_cmdshell for instance) Create a file on the server called c:\ftp_command.txt, in this file write the commands for the ftp session. ie === open...

You'll find kix (and scripts) at http://www.kixtart.org

Try to run the select statement like this SELECT * FROM Users WHERE FullName LIKE 'Joe%' or SELECT * FROM Users WHERE Upper(FullName) LIKE 'JOE%' should hopefylly give you the results you've been looking for.

Have you tried to run the program in another compatability modus ? Right click the program and select the compatibilty sheet. Select &quot;run this program as&quot; and choose Windows 95. Should do the trick..

Have you included a gateway for the server ? &quot;ipconfig /all&quot; should have a default gateway for your network.

I don't have the magic fix for this problem but there are some &quot;standard&quot; troubles shooting options here. How is the switch performing when you loose the connection with the server ? Are you able to ping the server from a workstation ? Are you able to access the internet ? My initial...

Error 53 Network path not found indicates that there are problems resolving your servername. Are you able to &quot;ping servername&quot;, or is VOL1 shared ? Type a NET VIEW \\<SERVERNAME> to see the share you've created on the server <SERVERNAME> and then try a NET USE S...