Lovely idea.

Still, it seems to be hard to find in reality.

Easy way to implement this would be the following:

you create two ssis packages. One is the main package and responsible for control flow. It takes the parameters and passes them...

nick.mcdermaid (5/13/2013)

---

Why don't you change the tone of the question from 'how do I get SQL 2000 to install' to "how do I get my game to work on SQL...

This thread is almost 5 years old. Is this when you had your last real vacation?

Its really the same here. Extra work before the vacation AND afterwards.

Nothing of the my...

To get the total volume space of a HDD you might find this link useful:

http://www.sqlservercentral.com/articles/powershell/68011/

It can be done using PowerShell to collect the data in in SQLAgentJob.

The Problem...

Hi!

You can capture all raised errors in a table type variable.

BEGIN TRY

EXEC(@SQL)

END TRY

BEGIN CATCH

UPDATE @tFirmen SET ErrorMSG = ERROR_MESSAGE()

WHERE ID = @FirmaID

END CATCH

After execution you can handle the errors or...

You would have to wait for the scripttask to process all rows and set variable value after endofrowset.

Since you are already using stored procedure here, why not just insert the...

Your table definitions contain serious errors. Only way to join users (give the correct datatype and references are used) is by joining sals with users on designation_id.

This happens to...

This topic is .NET related since the only differences here are based on the processing of the query results. You should choose a simple method to get data back from...

Since you don't have a Identity column here you might have to use a row number to join the other columns back in.

Generally you could just split the information accordingly...