Hi all, I am trying to run a batch file from within a sql server job. The batch file is located on a seperate machine and executes an application...
All, In case you're interested, I tidied things up and played around with the code. Rather than create a new table just to hold start and end dates...
Guys, Thanks for this (especially the inspiration from Frank!)..... Final solution as follows....The post from Frank reminded me that life becomes...
Hi guys, This is probably a fairly simple query but I am really struggling with it!! I am trying to calculate a financial year to date flag for a...
I would suggesting trying a subquery based on studentdetailmaster to give you the detailed_processed and detailed_unprocessed figures - alternatively...
Thanks Joe....Guessed this would be the response but wanted to make sure. Essentially, they are looking at consolidating their file storage. I...
Hi guys, I am working with a company that is looking at implementing a SQL server standard (sp4) install onto a NAS system. Had a look on Microsoft...
Hi Nelson, Do you keep copies of your database backups or are you wiping it out each day? In the past I have used one of the following. Either:...
Guys - Thanks very much. Confirmed what I was thinking but wanted to make sure that these disks weren't some magical creation that could cope with...
Hi all, In need of advice please. We are implementing an IBM SAN and I am trying to plan out the location of files. Using SQL 2k Enterprise with Win...
This code pulls out the biggest tables in your system and returns a result set. Copy and paste the result set into query analyser and execute - This...
Basically, the lower the number the higher the selectivity. So an all density result of one would mean it is a better selective (more unique) index...
Are you calling this from a web page? If so, you can set the query timeout on the page: server.scripttimeout = 420 (increase this number as needed)...
Separate names with a comma.
