Hi all, I've got PDC and BDC Windows NT 4.0 Servers (Enterprise edition) installed in the MS cluster. The clustered application is MS SQL server 7.0. Now I need to change names of both nodes - PDC and BDC Windows NT 4.0 Servers. Has anyone any experience with such operation ? Is it too risky ? Thanks a lot for any hint MichalChanging the server names will break your SQL servers.
I did this on a standalone (changed the server name) and SQL stopped working. The fix according to Microsoft was to reinstall SQL on the servers. When the installation starts it will see that all the components are already installed and then see the name resolution conflict and fix it.
This worked for the standalone but I dont' know about the cluster.|||Furthermore, you can not change the name of a PDC without reinstalling NT 4 server.
Showing posts with label mssql. Show all posts
Showing posts with label mssql. Show all posts
Sunday, February 19, 2012
Thursday, February 16, 2012
Change query (ODBC driver), change query result
Hello
Situation: Application->ODBC->MSSQL2K
I need to change some queries (replace) between ODBC and MSSQL on the fly,
or, in the other words transparently to application modify some query before
they executed by SQL server.
Another Q.
There is the query: SELECT COUNT(A) FROM B WHERE B.A='C'
(and there are a lot other select, insert etc. queries to table B)
I need to do something on server side (triggers/views etc.) to change result
of this query (but I can't change query itself)
(for example - it should always return 5)
Help me with this problems
AndyYou can't make SQL Server lie to you on purpose. SQL Server will return the
result from the query, nothing you can do about that. Either catch the
result in the client and handle it, or pass some other query to SQL Server.
You could write an ODS application, which is essentially a SQL Server
gateway, so your client would connect to your "pseudo-SQL Server" and it
will pass the queries to the real SQL Server. You can now intercept the
queries. I'm not sure MS carried over the ODS possibilities to SQL2K, and
this is also not light-weight programming to write an ODS gateway.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Andy" <andycpp@.i.com.ua> wrote in message
news:OlMB7tU7DHA.1592@.TK2MSFTNGP10.phx.gbl...
> Hello
> Situation: Application->ODBC->MSSQL2K
> I need to change some queries (replace) between ODBC and MSSQL on the fly,
> or, in the other words transparently to application modify some query
before
> they executed by SQL server.
> Another Q.
> There is the query: SELECT COUNT(A) FROM B WHERE B.A='C'
> (and there are a lot other select, insert etc. queries to table B)
> I need to do something on server side (triggers/views etc.) to change
result
> of this query (but I can't change query itself)
> (for example - it should always return 5)
> Help me with this problems
> Andy
>|||Is there some kind of ODBC Proxy?
Can I redefine COUNT function?
I don't need to _modify_ SQL Server _answer_, I should redefine/replace etc.
query or reroute it...
I'll look for ODS, tnx
Andy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9Z$GLV7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> You can't make SQL Server lie to you on purpose. SQL Server will return
the
> result from the query, nothing you can do about that. Either catch the
> result in the client and handle it, or pass some other query to SQL
Server.
> You could write an ODS application, which is essentially a SQL Server
> gateway, so your client would connect to your "pseudo-SQL Server" and it
> will pass the queries to the real SQL Server. You can now intercept the
> queries. I'm not sure MS carried over the ODS possibilities to SQL2K, and
> this is also not light-weight programming to write an ODS gateway.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "Andy" <andycpp@.i.com.ua> wrote in message
> news:OlMB7tU7DHA.1592@.TK2MSFTNGP10.phx.gbl...
fly,
> before
> result
>|||> Is there some kind of ODBC Proxy?
Not that I know of. You might want to check the ODBC newsgroups.
> Can I redefine COUNT function?
No.
> I'll look for ODS, tnx
Just don't hold your breath. As I said, I think MS removed this ability in
SQL2K. And, it is probably a lot of hard (C++) work to write an ODS gateway.
I'm sorry, but I don't think you'll find any viable solutions to this...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Andy" <andycpp@.i.com.ua> wrote in message
news:%23p3tmxW7DHA.2044@.TK2MSFTNGP10.phx.gbl...
> Is there some kind of ODBC Proxy?
> Can I redefine COUNT function?
> I don't need to _modify_ SQL Server _answer_, I should redefine/replace
etc.
> query or reroute it...
> I'll look for ODS, tnx
> Andy
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:e9Z$GLV7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> the
> Server.
and
>
http://groups.google.com/groups?oi=...ublic.sqlserver
> fly,
>|||Yep, with ODS - no solution... Obsolete.
But "you'll find any viable solutions to this" not a solution.
Taks is defined, and I heve to find correct answer...
please, try to help me
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%237mDR8W7DHA.2524@.TK2MSFTNGP11.phx.gbl...
> Not that I know of. You might want to check the ODBC newsgroups.
>
> No.
>
> Just don't hold your breath. As I said, I think MS removed this ability in
> SQL2K. And, it is probably a lot of hard (C++) work to write an ODS
gateway.
> I'm sorry, but I don't think you'll find any viable solutions to this...
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "Andy" <andycpp@.i.com.ua> wrote in message
> news:%23p3tmxW7DHA.2044@.TK2MSFTNGP10.phx.gbl...
> etc.
> in
return
it
the
> and
>
http://groups.google.com/groups?oi=...ublic.sqlserver
the
query
change
>
Situation: Application->ODBC->MSSQL2K
I need to change some queries (replace) between ODBC and MSSQL on the fly,
or, in the other words transparently to application modify some query before
they executed by SQL server.
Another Q.
There is the query: SELECT COUNT(A) FROM B WHERE B.A='C'
(and there are a lot other select, insert etc. queries to table B)
I need to do something on server side (triggers/views etc.) to change result
of this query (but I can't change query itself)
(for example - it should always return 5)
Help me with this problems
AndyYou can't make SQL Server lie to you on purpose. SQL Server will return the
result from the query, nothing you can do about that. Either catch the
result in the client and handle it, or pass some other query to SQL Server.
You could write an ODS application, which is essentially a SQL Server
gateway, so your client would connect to your "pseudo-SQL Server" and it
will pass the queries to the real SQL Server. You can now intercept the
queries. I'm not sure MS carried over the ODS possibilities to SQL2K, and
this is also not light-weight programming to write an ODS gateway.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Andy" <andycpp@.i.com.ua> wrote in message
news:OlMB7tU7DHA.1592@.TK2MSFTNGP10.phx.gbl...
> Hello
> Situation: Application->ODBC->MSSQL2K
> I need to change some queries (replace) between ODBC and MSSQL on the fly,
> or, in the other words transparently to application modify some query
before
> they executed by SQL server.
> Another Q.
> There is the query: SELECT COUNT(A) FROM B WHERE B.A='C'
> (and there are a lot other select, insert etc. queries to table B)
> I need to do something on server side (triggers/views etc.) to change
result
> of this query (but I can't change query itself)
> (for example - it should always return 5)
> Help me with this problems
> Andy
>|||Is there some kind of ODBC Proxy?
Can I redefine COUNT function?
I don't need to _modify_ SQL Server _answer_, I should redefine/replace etc.
query or reroute it...
I'll look for ODS, tnx
Andy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9Z$GLV7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> You can't make SQL Server lie to you on purpose. SQL Server will return
the
> result from the query, nothing you can do about that. Either catch the
> result in the client and handle it, or pass some other query to SQL
Server.
> You could write an ODS application, which is essentially a SQL Server
> gateway, so your client would connect to your "pseudo-SQL Server" and it
> will pass the queries to the real SQL Server. You can now intercept the
> queries. I'm not sure MS carried over the ODS possibilities to SQL2K, and
> this is also not light-weight programming to write an ODS gateway.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "Andy" <andycpp@.i.com.ua> wrote in message
> news:OlMB7tU7DHA.1592@.TK2MSFTNGP10.phx.gbl...
fly,
> before
> result
>|||> Is there some kind of ODBC Proxy?
Not that I know of. You might want to check the ODBC newsgroups.
> Can I redefine COUNT function?
No.
> I'll look for ODS, tnx
Just don't hold your breath. As I said, I think MS removed this ability in
SQL2K. And, it is probably a lot of hard (C++) work to write an ODS gateway.
I'm sorry, but I don't think you'll find any viable solutions to this...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Andy" <andycpp@.i.com.ua> wrote in message
news:%23p3tmxW7DHA.2044@.TK2MSFTNGP10.phx.gbl...
> Is there some kind of ODBC Proxy?
> Can I redefine COUNT function?
> I don't need to _modify_ SQL Server _answer_, I should redefine/replace
etc.
> query or reroute it...
> I'll look for ODS, tnx
> Andy
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:e9Z$GLV7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> the
> Server.
and
>
http://groups.google.com/groups?oi=...ublic.sqlserver
> fly,
>|||Yep, with ODS - no solution... Obsolete.
But "you'll find any viable solutions to this" not a solution.
Taks is defined, and I heve to find correct answer...
please, try to help me
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%237mDR8W7DHA.2524@.TK2MSFTNGP11.phx.gbl...
> Not that I know of. You might want to check the ODBC newsgroups.
>
> No.
>
> Just don't hold your breath. As I said, I think MS removed this ability in
> SQL2K. And, it is probably a lot of hard (C++) work to write an ODS
gateway.
> I'm sorry, but I don't think you'll find any viable solutions to this...
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "Andy" <andycpp@.i.com.ua> wrote in message
> news:%23p3tmxW7DHA.2044@.TK2MSFTNGP10.phx.gbl...
> etc.
> in
return
it
the
> and
>
http://groups.google.com/groups?oi=...ublic.sqlserver
the
query
change
>
Friday, February 10, 2012
Change Notifications
Hello
I have a requirement to update the Exchange contacts folder according
to a table in MSSQL 200. Also changes in the db has to be updated in
the contacts.
The solution that I have thought about is to write a trigger and
contact a COM object that does the update. Is there a better way to do?
Thank you and regards
Renjith V.I helped someone with a similar requirement a while back. We ended up using
DAV and a Windows Service that checked the table to do the updates en masse
every 5 minutes or so. Depends on your requirements - if you need to have
immediate updates you could write an XP and avoid COM; or you could go the
COM route and use the 'sp_OA%' stored procs to invoke/manage it. I've never
invoked a COM routine from within a Trigger, however, so I couldn't tell you
about possible performance or other potential problems (although if you
don't properly destroy COM objects and/or you're not on SP 4, you can end up
with serious memory leaks.)
"Renjith" <v.renjith@.gmail.com> wrote in message
news:1150338308.044717.160160@.y41g2000cwy.googlegroups.com...
> Hello
> I have a requirement to update the Exchange contacts folder according
> to a table in MSSQL 200. Also changes in the db has to be updated in
> the contacts.
> The solution that I have thought about is to write a trigger and
> contact a COM object that does the update. Is there a better way to do?
> Thank you and regards
> Renjith V.
>|||Thank you Mike for the comments. But I am not sure what DAV and XP
mean. Could you please tell me a bit more about it?
Mike C# wrote:
> I helped someone with a similar requirement a while back. We ended up usi
ng
> DAV and a Windows Service that checked the table to do the updates en mass
e
> every 5 minutes or so. Depends on your requirements - if you need to have
> immediate updates you could write an XP and avoid COM; or you could go the
> COM route and use the 'sp_OA%' stored procs to invoke/manage it. I've nev
er
> invoked a COM routine from within a Trigger, however, so I couldn't tell y
ou
> about possible performance or other potential problems (although if you
> don't properly destroy COM objects and/or you're not on SP 4, you can end
up
> with serious memory leaks.)
> "Renjith" <v.renjith@.gmail.com> wrote in message
> news:1150338308.044717.160160@.y41g2000cwy.googlegroups.com...|||"Renjith" <v.renjith@.gmail.com> wrote in message
news:1150339498.386101.227740@.g10g2000cwb.googlegroups.com...
> Thank you Mike for the comments. But I am not sure what DAV and XP
> mean. Could you please tell me a bit more about it?
DAV is a web-based protocol you can use to retrieve and update information.
You can use it to update your Exchange folders. XP is an extended stored
procedure written in C++ and compiled to a DLL that SQL Server can invoke to
perform functions that are outside the normal scope of T-SQL.|||If you can update the contacts through Active Directory you can look linking
to the AD through VB/VBScript (DTS ActiveX Task), you could also link to SQL
Server through the same script, produce a recordset of the changes and apply
the changes to the AD.
If this is an option the best place to start would probably be:
http://www.microsoft.com/technet/sc...er/default.mspx
Ray
"Renjith" wrote:
> Hello
> I have a requirement to update the Exchange contacts folder according
> to a table in MSSQL 200. Also changes in the db has to be updated in
> the contacts.
> The solution that I have thought about is to write a trigger and
> contact a COM object that does the update. Is there a better way to do?
> Thank you and regards
> Renjith V.
>
I have a requirement to update the Exchange contacts folder according
to a table in MSSQL 200. Also changes in the db has to be updated in
the contacts.
The solution that I have thought about is to write a trigger and
contact a COM object that does the update. Is there a better way to do?
Thank you and regards
Renjith V.I helped someone with a similar requirement a while back. We ended up using
DAV and a Windows Service that checked the table to do the updates en masse
every 5 minutes or so. Depends on your requirements - if you need to have
immediate updates you could write an XP and avoid COM; or you could go the
COM route and use the 'sp_OA%' stored procs to invoke/manage it. I've never
invoked a COM routine from within a Trigger, however, so I couldn't tell you
about possible performance or other potential problems (although if you
don't properly destroy COM objects and/or you're not on SP 4, you can end up
with serious memory leaks.)
"Renjith" <v.renjith@.gmail.com> wrote in message
news:1150338308.044717.160160@.y41g2000cwy.googlegroups.com...
> Hello
> I have a requirement to update the Exchange contacts folder according
> to a table in MSSQL 200. Also changes in the db has to be updated in
> the contacts.
> The solution that I have thought about is to write a trigger and
> contact a COM object that does the update. Is there a better way to do?
> Thank you and regards
> Renjith V.
>|||Thank you Mike for the comments. But I am not sure what DAV and XP
mean. Could you please tell me a bit more about it?
Mike C# wrote:
> I helped someone with a similar requirement a while back. We ended up usi
ng
> DAV and a Windows Service that checked the table to do the updates en mass
e
> every 5 minutes or so. Depends on your requirements - if you need to have
> immediate updates you could write an XP and avoid COM; or you could go the
> COM route and use the 'sp_OA%' stored procs to invoke/manage it. I've nev
er
> invoked a COM routine from within a Trigger, however, so I couldn't tell y
ou
> about possible performance or other potential problems (although if you
> don't properly destroy COM objects and/or you're not on SP 4, you can end
up
> with serious memory leaks.)
> "Renjith" <v.renjith@.gmail.com> wrote in message
> news:1150338308.044717.160160@.y41g2000cwy.googlegroups.com...|||"Renjith" <v.renjith@.gmail.com> wrote in message
news:1150339498.386101.227740@.g10g2000cwb.googlegroups.com...
> Thank you Mike for the comments. But I am not sure what DAV and XP
> mean. Could you please tell me a bit more about it?
DAV is a web-based protocol you can use to retrieve and update information.
You can use it to update your Exchange folders. XP is an extended stored
procedure written in C++ and compiled to a DLL that SQL Server can invoke to
perform functions that are outside the normal scope of T-SQL.|||If you can update the contacts through Active Directory you can look linking
to the AD through VB/VBScript (DTS ActiveX Task), you could also link to SQL
Server through the same script, produce a recordset of the changes and apply
the changes to the AD.
If this is an option the best place to start would probably be:
http://www.microsoft.com/technet/sc...er/default.mspx
Ray
"Renjith" wrote:
> Hello
> I have a requirement to update the Exchange contacts folder according
> to a table in MSSQL 200. Also changes in the db has to be updated in
> the contacts.
> The solution that I have thought about is to write a trigger and
> contact a COM object that does the update. Is there a better way to do?
> Thank you and regards
> Renjith V.
>
Subscribe to:
Posts (Atom)