have you read http://blogs.msdn.com/b/suhde/archive/2009/07/12/how-to-configure-sql-server-database-mail-to-send-email-using-your-windows-live-mail-account-or-your-gmail-account.aspx and http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/setting-up-sql-server-database?

I guess you can define multiple datasets in your report. Display the resultset of each dataset in the desired format.

You could use the import/export wizard and save the generated SSIS package upon completion. This gives you an initial test and if it works, you can call the generated SSIS...

There is not enough information to help you. Do you have error messages (on screen or in the logging)?

Some common issues:

- firewall

- anti-virus blocking the mail

- incorrect exchange server

- ...

try...

try this url:

http://www.microsoft.com/en-us/download/details.aspx?id=6362

You have to change the owner of the database to another account (like 'sa'). Because "MyLogin" is currently the owner it is mapped to the "dbo".

You can also define a "zero" time (set @time = '0:00:00') and use this with the DATEDIFF to get the passed time

datediff(minute, @time, @time1 + @time2)

Just add both values. The return type will also be a datetime value which you can CONVERT to the desired format. If you want to calculate just the minutes, you'll...

I don't have a complete solution for you (not enough time on my hands), but I think the code below could give you a headstart.

Create Table #Temp

(

Number Int,

Transaction_Date DateTime,

Totalcoll Numeric(12,2),

Maintainance_Due...

You should number your rows (add a number column) and join on this number column, or change your current JOIN statement from "ON T1.ID1 = T2.ID1" to "ON T1.ID1 =...

I don't have powershell experience yet, but I think http://technet.microsoft.com/en-us/library/ee176858.aspx could give you a start. There are also a lot of other resources on the web. Just google around 😉

Use WMI or powershell (for example every minute, depending on the requirements) from a central server to monitor the status of the SQL Engine service on a remote server. When...

You don't mention how the rows are related to the next row. I have numbered all rows, but this is maybe not as you need. The numbering is needed to...

This is way to little information. You need to specify sample input and output data and preferrably explain what your goal is. Also state whatever you have tried so far....

When using "SELECT *" in a view the metadata is not automaticly updated when the related table(s) are altered. Use "sp_refreshview" to update the metadata for the specified non-schema-bound view....