Here is an article on how to post to get a better response:

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Please show at least an attempt at doing this yourself.

You need to be a bit more specific about what you are trying to do.

All versions of MS SQL have been able to process two queries at the same time...

These two syntax differences will always generate the same execution plans as long as you have no outer joins. Once you have outer joins, the order in which you...

In most other programming languages, you would see the same result. Anything that happens successfully before the error within a try/catch will actually happen unless you explicitly manage the...

You cannot do this without dynamic SQL.

No.

The SSIS Server knows what server the MDSB database is on (it is in a config file) but the msdb database does not know which SSIS server stored a package...

The INNER JOIN / OUTER JOIN syntax is ANSI 92 standard (yup - the old syntax is REALLY old). The old syntax is deprecated and will be completely unsupported...

It is an output parameter of the procedure you are already calling.

Check books online, but I think this is it:

[font="Courier New"]EXEC msdb.dbo.sp_send_dbmail

...

Ok, if you are using Exchange and that is what you have configured as the SMTP server for database mail, there are configurations on the exchange server for allowing AMTP...

Ok, first, you should rewrite the trigger to handle having multiple records in the INSERTED table. I understand your application currently cannot insert multiple records, but if the application...

Database Mail uses SMTP to send messages. If you are using a mail server like Exchange, SMTP relays to external email addresses needs to be enabled. Be sure...

I guess I don't understand what you are asking for. The database engine would not know anything about an SSIS engine. However, since SSIS cannot have a named...

Assuming the steps are all Execute SQL steps in your job, each step will get 1 spid. Since the steps have to be sequential, each connection will close before...

It is probably that you picked the wrong field in the dimension relationships in the cube. This is pretty easy to do, especially since the auto-join features in visual...

Assuming your job agent is connecting with a different username, it should be fairly easy to see if that user is blocking others just by looking at the activity monitor.