Search results for query: *

Hi, I am trying to install SQL Server onto a client windows XP machine. I have installed SQL but my ODBC connection is failing. It cant see the server instance, not even (local). Any ideas on where im goin wrong? Cheers

Hi there, I am running a small network with Microsoft server 2003, with 3 XP Client PCs and I have a specialist printer connected to COM1 (serial port) of one of the XP client machines. I want to make COM1 available as a COM on the other client PCs on the network so they can also print to the...

Hi there, I almost have my DTS complete. It is scheduled too transfer the past 24hrs entries from one database to another. The only trouble i am having is preventing duplicate entries being transfered. Can I prevent an entry from being copied from the source DB to the destination DB if say 3...

Hi there, I need to automate a DTS package to run daily. I have the code Im going to use, only, it is designed for input of a 'start date' and 'end date' by a user. I need the DTS package to pick up todays date and yesterdays date automatically, rather than have the user input these dates. That...

I have a Date/time column in the format 'DD\MM\YYY HH:MM:SS' I need to query the time and not the date, but there on the same column. so for example: Print_Date 30/11/06 15:00:59 29/11/06 12:15:13 23/11/06 06:55:44 I need a query that will give all items printed before 18:00:00 EVERYDAY...