Search results for query: *

On a server running Windows Server 2003 SP2 I have a simple one line batch file that syncs the local time with a remote server: net time \\172.20.49.10 /set /y I can run this manually and it works fine. However, I have set up a scheduled task to run this file and it consistently fails with...

I'm experiencing some odd behaviour with a remote procedure call and was just wondering whether anyone could shed any light on it? I have a job on ServerA that has a step which calls a proc on linked ServerB: EXEC ServerB.MyDB.dbo.MyProc Occasionally this step fails with the error: Could not...

I wonder if anyone can shed any light on this seemingly strange "feature"? We have recently started receiving spam emails through to various users where the email address is prepended with a pipe character (|), eg: |my.user@myco.com Because of this character the messages are being allowed...

I have a folder on a Windows 2003 SP2 server which has a large amount of files in it, probably a couple of hundred thousand, going back over a few years. I am trying to delete all the old files and just keep one month's worth. If I try and just open the folder in explorer it just hangs. Does...

Has anyone else encountered a problem with the system table map help file, available at: http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.mspx This is a very useful help file which displays the system tables in a graphical format. I have downloaded the systbl.chm file but when...

Is there any easy way to center the text vertically in a fixed-height H1 heading, such as: <style type="text/css"> h1 { margin: 0; padding: 0; height: 120px; background: #CCC; text-align: right; } </style> ... <h1>Header</h1> I would like the text to be centered vertically on the...

I currently have a scheduled DTS package that uses an FTP task to connect to a remote FTP server and download the latest version of a single file (setup.exe). The third party that provides the file has changed the location of the file now so that instead of being on an FTP server it is only...

I started off posting this as a question but have since realised what is happening (I think). I decided to post anyway as it's something to be aware of. I was inserting some character data into a money column, using ISNUMERIC first to check whether it could be converted to a number. However I...

I have a large table of data which is often much higher than the available screen height. What I am trying to achieve is to put the table in a fixed-height div and when the user scrolls down, all the data rows scroll but the single top row of headings stays where it is, ie always visible at the...

Does anyone know how to get mails sent using xp_sendmail to save in the Sent Items folder? I know there's an option in the SQL Agent properties for this but this only affects Agent mail (job notifications, DTS sendmail tasks etc). All mail used to be saved when we were using SQL 7 but since...

I have recently transferred a couple of databases to a new server running SQL 2000 SP3 (from SQL 7 SP4). I have set up a mail profile through Outlook (exactly the same as on the old machine) and it works fine. However, I have noticed that mail sent using xp_sendmail is not saved in the Sent...

I have a few Excel spreadsheets that are stored on a shared folder on the network and are accessed by a number of users. Some of these contain data that is queried from our SQL Server via an ODBC DSN set up on each machine. Until recently these all worked fine but now two users have reported...

I get a daily email that contains a single text file attachment. What I want to do is when I receive the email to automatically save that attachment to a certain location. At the moment I have written a macro that saves the attachment and added a button to my Outlook toolbar which i just click...

This is what I'm trying to do: - set up a command object to execute a stored proc, passing in a couple of parameters - execute the command and return a recordset - get the record count of the recordset I can execute the command and get the recordset back no probs. The problem I'm having is...

I thought this question cropped up so frequently that it was high time for my first FAQ! As always, any comments/suggestions welcome. Passing a list of values to a Stored Procedure faq183-3979 --James

I'm trying to get SQLMail working on a new server. Windows NT4, SQL Server 7. Both the SQLServer service and the SQLAgent service are running under the same account, which at the moment is the Domain Admin account (just while we're setting this up). After installing Outlook, I created a mail...

Is there a way (without purchasing 3rd party s/w) to see which machine(s) on the network a particular user is logged in to? --James

On many forms floating around the internet users are required to select which country they are from. The list of countries is obviously quite long and from the looks of it is a &quot;standard&quot; list, ie names spelt correctly etc.. Does anyone know whether you can create this select list...

I have Server2 set up as a linked server on Server1 which has been working fine for ages. However, I have just added 4 columns to a particular table on Server2 and now cannot query the table at all through the link (works fine direct from Server2). I get the following error: Server: Msg 7353...

Does anyone have any recommendations for a good, FREE text editor for coding ASP/HTML. I use InterDev at work but only really for the syntax help and colour formatting as I code everything by hand. I just find having the different colours helps when checking/debugging code and was looking for...