fixed the 'sp_send_dbmail .csv attachment Xcel not opening properly - putting all data in one column' issue with a small hack:

in sp_send_dbmail, do:

@query_attachment_filename = 'blah.csv'

,@query_result_separator = ' ...

yes, select.

SSRS is included in list of painful ways.. 🙂

<bump>

https://connect.microsoft.com/SQLServer/feedback/details/555557/ssms-open-file-with-active-connection-or-prompt-connect-to-database-engine

pls see: https://connect.microsoft.com/SQLServer/feedback/details/555557/ssms-open-file-with-active-connection-or-prompt-connect-to-database-engine

<bump>

where can i get explanations for what each registry key does ?

i tried setting this to 0, but new files still open with current connection:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\ReuseActiveDocumentWindow

try TestReport.YourQues

instead of YourQues.TestReport

(table name should come first)

the 1st parameter for sp_send_dbmail is profile name,

so try this instead:

exec msdb.dbo.sp_send_dbmail @recipients='dweil@jewishhome.org', @body = 'Let keep it simple'

u can see its syntax here:

use msdb

go

exec sp_helptext sp_send_dbmail

i have a dictionary software - WordWeb (runs as a background process), which incidentally allows u to manually set a keyboard shortcut to activate it.. set ctrl+e

i made a work-around - mapped ctrl+e as a hotkey in another software.

i do Not want to use ctrl+e, but might by accident; so want to Disable it

are u referring to tools-customize-keyboard aka tools-options-keyboard ?

i only found 'Reset to default' ctrl+1, ctrl+2 etc.. which are user-customized shortcuts (not inbuilt shortcuts like ctrl+e)

SQLDMO doesn't seem to script 'grant view definition' permissions - any idea why ?

looks like MS isn't supporting DMO (COM), but SMO (.NET)

But is there a non .NET/VB/scptxfr.exe (i.e...

thanks

SQl 2005 management (SP2) studio has 'ANSI text' option..

in object explorer.. right-click a database -> Tasks->Generate Scripts->select database->choose options->choose object type->choose object->

'Script to File'

Save as:

'unicode text'

'ansi...

Is there an option number to script triggers of a table, by specifying only the table name ?

...