I guess I need to clarify my statement about using the cubes in both Oracle and SQLServer. What I have been told by my boss is that we want to be able to use 1 tool to create our cubes, such as the Analysis Manager, and then be able to distribute those cubes in our […]
2003-07-31
Guys, thanks for the help. We figured it out at last. It is the issue with Firewall. The port which we configured for SQL Server to listen had to be opened. thanks
2003-07-14
Is SQL Server Agent running under an account that has access to both servers ? This has caught me out before. The local account has no rights to the other server.
2003-07-14
I am now using: <% ' Dim the Recordset Object Dim rsADO ' Define the Connection String From Above ConnectionString = "Provider=SQLOLEDB; Password=;User ID=sa;Initial Catalog=TestDatabase;Data Source=mydatasource;" ' Create the Object Set rsADO = Server.CreateObject("ADODB.Recordset") Source = "SELECT * FROM Table1" ' Open the Recordset rsADO.Open Source, ConnectionString if not rsADO.EOF then Response.Write rsADO("test") end if […]
2003-07-13
1 reads
Yes, I did but it doesn't apply to my sitution. The SQL Server performance counters show up without any problem if SQL Server running active/passive in service pack 3. It just happens to active/active configuration.
2003-06-13
1 reads
2003-06-11
2 reads
Jon, 6 hours is an extraordinarily long time for a 45gb database. Normally I'd say your tape drive needs looking at, except for the fact that it's about half the time for a pre-existing database. So, when restoring to a new database, given that SQL is taking about 3 hours just to prepare the ground […]
2003-06-10
1 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