Another tutorial on enabling db mail:

http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm

Is Database mail enabled on your SQL server?

If not (http://www.sql-server-performance.com/articles/dba/email_functionality_p1.aspx)

Once enabled:

How to use databasemail

http://msdn.microsoft.com/en-us/library/ms190307.aspx

Hi

Can you rather tell us what tables\table structures you have and what outcome you would like.

Im not sure I understand the question or the problem...

Thanks

Perfect. That is exactly what I was looking for.

Thank you!

Thanks for the reply. I found the solution.

Turns out when SQL security patches are automatically deployed it used the default setting for the patch. In this case the securtity defaults...

Thanks for the feedback. I will investigate these two options.

What syntax are you using to select from the linked server?

What type of linked server is it (Is it SQL\Oracle etc?)

Also, have you verified that you are authenticating using the...

Nevermind. Im being a moron!:blush:

No one database in Express can be larger than 4 GB, but there is no limit on the number of databases you can use in Express.

From: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1082707,00.html

SQL Server Express can handle multiple databases each up to 4Gb in size (this excludes logfiles).

I think the 1Gb limit that you mentioned refers to the fact that SQL Server...

Hi

I would think that something like this might not be possible.

Also I'd imagine that you would have dig around the registry of your server in order to make something like...

Well you can use an Excel connector to read the data from your source Excel file and possible insert it into a table and do some SQL manipulations to your...

You could write a DTSX package which extracts the data, performs manipulations (within the package) and sends the output to an Excel file and email it to your recipient.

In what...

I dont now the exact facts regarding this but in my experience we do on occation shrink the tempdb's but it never shrinks it by much. We have never had...

Hi Laura

Check out this document:http://www.proprofs.com/forums/index.php?showtopic=12070 and download it as a PDF.

It will guide you through setting up mail profiles etc and once you have completed all the steps...