Search results for query: *

We have a number of regular repeating tasks that are currently managed using an outlook calendar. I was wondering if those calendar entries could initiate a workflow to start which would then direct people to create a specific document / set of documents? This would enable the whole workflow...

Hi, we are about to purchase SQL 2005, and I'm trying to work out what spec the PCs need to be in order to run client tools effectively. Having looked about in MSDN etc I can't find anything that gives me minimum / recommended requirements. Does anybody know the location of where this might...

I am running SQL 2000. I have a stored procedure that creates a set of data, which then needs to be put into Excel, the excel spreadsheet password protected and then emailed to a recipient. I have the sp sorted, and was going to use xp_sendmail to send the spreadsheet to the required...

I have a server whereby 3 or 4 databases all relate to each other. Occasionally it has been necessary to make changes to the schema of one or more of these databases to incorporate new requirements. Is there a way to autodocument 3 or 4 databases in tandem so I can view dependancies. (eg...

Hi, I have got a DTS package that exports the results of some SPs to an Excel workbook on a daily basis, because it's a daily job, I've set up a dynamic properties task (to be the first thing that happens in the DTS) and this datestamps the name of the Excel spreadsheet to something like...

Hi, I'm a bit stuck and any and all advice / help would be greatly appreciated. I have a server (called for arguments sake: server1), this server and all the tables in all the databases on it have the following collation type: SQL_Latin1_General_CI_AS. Server1 is linked to Server2. The server...

Hi, I have a table which shows an 'In date & time' and an 'out date & time' for people in hospital. I have to calculate how many patients were occupying a bed at midnight per day, between any two dates that the user might choose... For example: patientid startdate...

I'm trying to build a DTS package that runs a win32 executable. (not designed by me). This package looks at data puts the data through a processor and assigns another code to the data before exporting it all out to a csv file which I will then reimport to the server... (hope this makes sense)...