From what FALCONSEYE described, if we have another record like following in the table temp_p,
7 person7 2
it should be included in the result. But none of the query from Mufasa or FALCONSEYE returns this record. I think the correct answer should like following:
select * from tmp_p...
Thanks a lot denny!
I turned on the anonymous access and specified a windows account being used by the anonymous user, grant this account the access to all the databases that can be used as datasource. It works!
You reminded me license issue, this sounds a Microsoft trick. If we use the scale...
We configure the clustering as following:
IIS group
IP address: vitual IP fot IIS Service to failover
IIS network name resource
IIS script resource
since SSRS is not cluster aware we install 2 standalone reporting service on 2 nodes, connect to the same database, the user view report...
Hi,
We want install 2 reporting service on a 2 node sql clustering. I read some articles and awared of the scale out need use Enterprise Edition of SQL Server. the problem is we already have the standard edition of sql clustering setup, can we install the SSRS using enterprise edition? Is it...
also I found there are 8 CPUs on the server and the TEMPDB only have one file. Is that asking for competition on the data file? Do I need to add more data files for the TEMPDB?
If the TEMPDB should be sized 8G and we have 8 CPUs, do I need to have 8 datafiles for TEMPDB and each of them at 1G?
We have a lot of message like following:
SQL Server has encountered 294 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000814. The offset of the latest long I/O is...
I found the following article:
http://www.databasejournal.com/features/oracle/article.php/3600931
talking about migrate database using RMAN cross platform. I need do more test like you mentioned and script and time every step.
Thanks a lot!
Thanks a lot!
These issues was because of bad design at the beginning. We already allocate another server to migrate the application to. By that time, the connecting problem will solved as well.
This is just phase I, the phase II is to move the database from the windows platform to unix. The...
Someone deleted the databases on purpose, the SQL Server starting fine and most of the critical production databases are gone.
The people who did this must have dba password or can physically logon the box. Looks like the error logs are also modified. Is there any way we can trace this event in...
Your answer really makes sense to me. But for some reason the application for the 9i database was installed on the database server, this makes things complicated.
After I updated the MDAC which is related to microsoft ole db I guess, the clients can't connect to the database anymore if the 10G...
Hi thargtheslayer ,
You mean I deinstall both the 9i client and 10G client on the server?
We can't touch the 9i environment because we have a 9i production database here.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.