SSIS isn't free, but it comes with the product, so it won't cost you anything extra to write a package that will connect to each server and get the information...

Good work, Cadavre, especially generating all those random postcodes! The following are also legal postcodes, and I've checked that your code also works with them:

'N12 4DB'

'SW1A 4DB'

'W1B 4DB'

'L1 4DB'

'LS1...

I'm afraid I don't understand what the difficulty is. Just give the SQL Server Agent service account the necessary permissions on the share and everything should work.

John

Yes, we have no DDL or sample data, so it's difficult to visualise and impossible to test. However, are those nested statements necessary? This should work:

case when bh_type...

You should be able to do everything with UNCs. You haven't said what operations you'll be carrying out on the folders, so I'm just guessing, but if you keep...

Yes, you can do this. Read about package configurations. You can take any property of the package (for example the location of the text file to be read...

OK, then if you absolutely need to use a database function, you'll need to use an Execute SQL task to run it and get the result into a variable and...

You don't need to incur the expense of connecting to a database just to get the current date and time, and even if you do, you don't need a user...

If your users are attempting to see the new columns in SSMS, they need to refresh first before they can see them. This one has caught me out before!

John

Is the user defined function a SQL function? What parameter(s) does it take, if any? You'll need to connect to the database in order to evaluate it before...

Yes, you can have two foreign key constraints on tblWorkedHours - one referencing tblClients and one referencing tblTasks.

John

Can you not just leave the client column NULL in tblWorkedHours where there is no client involved?

John

Nithin

Can it be as simple as this:

SELECT TOP 1 * FROM MyTable

WHERE MyColumn > 4000

ORDER BY MyColumn ASC

John

If you run that code in a query window, you'll get the full output and you'll be able to see which database is causing the problem.

John

I think you'd be best investigating converting your variable to datetime and then using the DATEPART function. But, if you insist on doing it as above, something like this...