Do SQL Server 2005/CLR Triggers support .config Files?

Does anyone know if it's possible to use the standard .config file within a CLR Trigger to read properties via the System.Configuration namespace

I guess it's not possible because the CLR Trigger needs to be compiled as an assembly which is hosted by SQL Server

Thanks

Jason

Hi,

http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thread/6d635c2cd23fed7

CLR stuff in SQL Server does not work like those know from "normal" applications. Although you can use the Configuration class to load a configuration somewhere stored on disk, you have to keep in mind, that every namespace / class that you use with are not approved as safe will lower down your security, because you have to mark them as unsafe / external access.

Perhaps any other posters has some other experiences about that.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Hi,
I think the “CLR Triggers for SQL Server 2005” article on
http://aspalliance.com/1273_CLR_Triggers_for_SQL_Server_2005
may be helpful in this discussion.

This popular white paper is written by a software engineer from our organization Mindfire Solutions (http://www.mindfiresolutions.com).

I hope you find it useful!

Cheers,
Byapti

Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.
Start|Run|msinfo32.exe should sort it.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
|
|||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.
|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editions/64bit/overview.mspx
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
|
|||Cheers Dave.
Dave Patrick wrote:

> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editions/64bit/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.

Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.Start|Run|msinfo32.exe should sort it.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
||||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editio...t/overview.mspx
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
||||Cheers Dave.
Dave Patrick wrote:

> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editio...t/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.sql

Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.Start|Run|msinfo32.exe should sort it.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
||||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editions/64bit/overview.mspx
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
||||Cheers Dave.
Dave Patrick wrote:
> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editions/64bit/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]|||You're welcome.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.

Do I need second license?

Hello,
I have MS SQL Server 2005 Standard Edition with one Client Access License.
May I
install the server as Primary on one machine and as Secondary (backup)
with Log Shipping on it on another machine, using same license?
Thanks,
GBYes,
But, note, its there for backup only and should not be used to run queries
etc...
So, if you ship the logs across to the backup server and then use database
snapshots then you are probably breaking the liecence terms and need another
liecence.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"GB" <gennady@.telus.net> wrote in message
news:79SJf.7479$n67.3175@.edtnps89...
> Hello,
> I have MS SQL Server 2005 Standard Edition with one Client Access License.
> May I
> install the server as Primary on one machine and as Secondary (backup)
> with Log Shipping on it on another machine, using same license?
> Thanks,
> GB
>|||Since GB really asked two questions (one in the subject and one in the body)
in which a YES can answer both but it has opposite meaning I wanted to say:
No you don't need two licenses<g>.
Andrew J. Kelly SQL MVP
"Tony Rogerson" <tonyrogerson@.sqlserverfaq.com> wrote in message
news:O0phfIUNGHA.2472@.TK2MSFTNGP11.phx.gbl...
> Yes,
> But, note, its there for backup only and should not be used to run queries
> etc...
> So, if you ship the logs across to the backup server and then use database
> snapshots then you are probably breaking the liecence terms and need
> another liecence.
> Tony.
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "GB" <gennady@.telus.net> wrote in message
> news:79SJf.7479$n67.3175@.edtnps89...
>|||Lol - teach me for reading the Q and ignoring the subject - doh!
Absolutely Andrew, and thanks for waking me up!
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:e7XMoyVNGHA.536@.TK2MSFTNGP09.phx.gbl...
> Since GB really asked two questions (one in the subject and one in the
> body) in which a YES can answer both but it has opposite meaning I wanted
> to say: No you don't need two licenses<g>.
> --
> Andrew J. Kelly SQL MVP
>
> "Tony Rogerson" <tonyrogerson@.sqlserverfaq.com> wrote in message
> news:O0phfIUNGHA.2472@.TK2MSFTNGP11.phx.gbl...
>

Distributed Transaction Error

I have two SQL Servers (Standard), one running on Windows Server 2003 sp1,
and the other on Windows 2000 sp4. Both are SQL Server sp4.
When I design a view on the 2003 machine, using a linked server (Win2k
system), I can get results by running the view. However, when I try to save
it, I get "The operation could not be performed because the OLE DB provider
'SQLOLEDB was unable to begin a distributed transaction', and 'OLE/DB
provider returned message: New transaction cannot enlist in the specified
transaction coordinator' messages.
I followed the instructions in KB816701, but this did not solve the problem.
There was no option on the Win2k system to set up Application Server: Enable
network DTC access.
Both systems have the Distributed Transaction Coordinator service running.
It seems strange that I could run the unsaved view, but not save it from the
designer. However, creating it via Create View does work, i.e. creating the
view and saving it.
Any assistance would be greatly appreciated.
Thanks,
TomT
Hello,
The following articles are for your reference:
306212 INF: Troubleshooting Linked Server Error 7391
http://support.microsoft.com/?id=306212
827805 MSDTC fails to mutually authenticate when computers do not run in the
http://support.microsoft.com/?id=827805
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Sophie,
Thanks for your response. However, I think there may be an issue between the
two platforms (Win2k and 2003). I had been planning to upgrade the Win2k
system to 2003, and did so today.
Once that process was completed, the issue I encountered went away. I.e., a
view created in the designer on one server using a linked server table, can
now be saved - no error messages.
Thanks,
TomT
"Sophie Guo [MSFT]" wrote:

> Hello,
> The following articles are for your reference:
> 306212 INF: Troubleshooting Linked Server Error 7391
> http://support.microsoft.com/?id=306212
> 827805 MSDTC fails to mutually authenticate when computers do not run in the
> http://support.microsoft.com/?id=827805
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>

Distributed Transaction Error

I have two SQL Servers (Standard), one running on Windows Server 2003 sp1,
and the other on Windows 2000 sp4. Both are SQL Server sp4.
When I design a view on the 2003 machine, using a linked server (Win2k
system), I can get results by running the view. However, when I try to save
it, I get "The operation could not be performed because the OLE DB provider
'SQLOLEDB was unable to begin a distributed transaction', and 'OLE/DB
provider returned message: New transaction cannot enlist in the specified
transaction coordinator' messages.
I followed the instructions in KB816701, but this did not solve the problem.
There was no option on the Win2k system to set up Application Server: Enable
network DTC access.
Both systems have the Distributed Transaction Coordinator service running.
It seems strange that I could run the unsaved view, but not save it from the
designer. However, creating it via Create View does work, i.e. creating the
view and saving it.
Any assistance would be greatly appreciated.
Thanks,
TomTHello,
The following articles are for your reference:
306212 INF: Troubleshooting Linked Server Error 7391
http://support.microsoft.com/?id=306212
827805 MSDTC fails to mutually authenticate when computers do not run in the
http://support.microsoft.com/?id=827805
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Sophie,
Thanks for your response. However, I think there may be an issue between the
two platforms (Win2k and 2003). I had been planning to upgrade the Win2k
system to 2003, and did so today.
Once that process was completed, the issue I encountered went away. I.e., a
view created in the designer on one server using a linked server table, can
now be saved - no error messages.
Thanks,
TomT
"Sophie Guo [MSFT]" wrote:

> Hello,
> The following articles are for your reference:
> 306212 INF: Troubleshooting Linked Server Error 7391
> http://support.microsoft.com/?id=306212
> 827805 MSDTC fails to mutually authenticate when computers do not run in t
he
> http://support.microsoft.com/?id=827805
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>

Distributed Transaction Error

I have two SQL Servers (Standard), one running on Windows Server 2003 sp1,
and the other on Windows 2000 sp4. Both are SQL Server sp4.
When I design a view on the 2003 machine, using a linked server (Win2k
system), I can get results by running the view. However, when I try to save
it, I get "The operation could not be performed because the OLE DB provider
'SQLOLEDB was unable to begin a distributed transaction', and 'OLE/DB
provider returned message: New transaction cannot enlist in the specified
transaction coordinator' messages.
I followed the instructions in KB816701, but this did not solve the problem.
There was no option on the Win2k system to set up Application Server: Enable
network DTC access.
Both systems have the Distributed Transaction Coordinator service running.
It seems strange that I could run the unsaved view, but not save it from the
designer. However, creating it via Create View does work, i.e. creating the
view and saving it.
Any assistance would be greatly appreciated.
Thanks,
TomTHello,
The following articles are for your reference:
306212 INF: Troubleshooting Linked Server Error 7391
http://support.microsoft.com/?id=306212
827805 MSDTC fails to mutually authenticate when computers do not run in the
http://support.microsoft.com/?id=827805
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Sophie,
Thanks for your response. However, I think there may be an issue between the
two platforms (Win2k and 2003). I had been planning to upgrade the Win2k
system to 2003, and did so today.
Once that process was completed, the issue I encountered went away. I.e., a
view created in the designer on one server using a linked server table, can
now be saved - no error messages.
Thanks,
TomT
"Sophie Guo [MSFT]" wrote:
> Hello,
> The following articles are for your reference:
> 306212 INF: Troubleshooting Linked Server Error 7391
> http://support.microsoft.com/?id=306212
> 827805 MSDTC fails to mutually authenticate when computers do not run in the
> http://support.microsoft.com/?id=827805
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

Distributed Transaction

I want to do distributed queries in a transaction, I'm using win XP pro, then I connect to a remote server (win 2003 standard), the remote server has sql server standard edition and my computer has sql server personal edition.
when I try to do this
begin tran
select * from rafael.tcadbcoi.dbo.invlin
commit tran
I get this error
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
without "begin tran" , the sicript works ritght> when I try to do this
> begin tran
> select * from rafael.tcadbcoi.dbo.invlin
> commit tran
> I get this error
> The operation could not be performed because the OLE DB provider
'SQLOLEDB' was unable to
> begin a distributed transaction. [OLE/DB provider returned message: New
transaction cannot enlist in
> the specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction
> returned 0x8004d00a].
> without "begin tran" , the script works right
--
Error 0x8004d00a is an issue with MSDTC. On the Windows 2003 server, verify
whether "Enable DTC for remote access" is turned on, reboot and try again.
For more information, consult the "Configuring an application server"
documentation of Windows 2003 online help.
Hope this helps,
--
Eric Cárdenas
SQL Server support