Let me pose the scenario and see if anyone has a solution: Most of our applications are client/server, in other words they have no middle tier. My management would like to be able to create warm standby servers for our SQL 2000 instances. In the case that we have to "fail-over" to one of these […]
2001-09-05
2 reads
hello there ihave a problem with this stored procedure (sp_makewebtask). I want to create the file in an other computer then mine and i proceed like this : create TRIGGER _TRIGGER_TEST ON [dbo].[Table_SAV] FOR INSERT, UPDATE, DELETE AS execute sp_makewebtask @outputfile='\\MyserverName\MyDirectorie\test.xml', @query='select refclient from table_sav for xml auto',@username='TELECOMPARTNERS\HADDAD',@dbname='TPAccessSQL',@templatefile='D:\DATA\Multiple.tpl' But evry time i have an ODBC […]
2001-09-05
30 reads
Hi all, I've made SQLMail send mails to my Exchange server and Outlook2000. But, my corporate is using Lotus. How do I send mails to my corporate mailboxes. Thanx in advance Parasu Parasu Raman
2001-09-05
2 reads
Hi all I am currently working on a large data model that encapsulates 5 different applications in a final hope to fully integrate the data into a single data model. One of the key aspects of the task is data conversion. I am after ideas/suggestions on the way I propose to tackle it as summaried […]
2001-09-02
1 reads
Hello, Could some one please tell how to get the current Identity value from a table using Dynamic sql. My code is listed below. declare @qry nvarchar(500) declare @qry1 nvarchar(500) declare @tabName nvarchar(50) declare @x int set @tabName='tblCenters' set @qry = N'select @ident=ident_current('''+@tabName+''')' set @qry1 = N'@ident int' exec sp_executesql @qry, @qry1,@x print @x It […]
2001-08-28
27 reads
The company I work for has recently decided to use Source Safe on all of our DTS packages. To do this we save the package down as a .dts file and check it into SS. We've ran into a bump in the road though. When saving as a .dts file, we lose all of the […]
2001-08-27
3 reads
I currently have SQL2000 running on 2 Win2000 Advanced Servers in a Cluster. Only one node currently has ownership of all of the resources and is active. How do I configure so that both nodes in the cluster are active?
2001-08-22
2 reads
hello once again, this time i have encrypted a view and when i open its design view the error comes as : "query designer encountered an unexpected error cant open encrypted view " but the data in the view is seen, now i want to modify the design view but its not working any ideas […]
2001-08-18
3 reads
In our datacenter environment, we are looking for a database monitoring software with which it would be possible to monitor different RDBMSs (presently we support clients with MS SQL Server, ORACLE, and DB2) and multiple instances on multiple servers, with reporting possibilites, threshold monitoring and alert generation possibilities. I've looked at Embarcadero's DBArtisan and Performance […]
2001-08-16
When a server running sql 7.0 tries to get information from the sysindexes table of another server running sql 2000 ,following error occurs : OLE DB provider 'SQLOLEDB' supplied inconsistent metadata for a column. Metadata information was changed at execution time. The query i am running is : select rows FROM [serverRunningsql2000].[dbname].dbo.sysindexes where indid < […]
2001-08-07
41 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers