Hi,
SQL Server Replication
I have created a a new Publication and have set the replication snapshot to be run every night at 04:00. The snapshot is saved to the snapshot folder <default path>\<publication>\<datestamp>\. I only want the latest copy of the snapshot held in the snapshot folder...
Hi all,
We are running with SQL Server 2008 R2 and are in the system design stages of making a large database resilient and recoverable within a set time frame. Our current preferred setup is to use SQL Server mirroring to provide the resilience and ease of server maintenance and combine it...
I am creating a linked server from SQL Server 2005 to Oracle. I would like to lock down the link to a set of developers assigned to an global windows group. I konw there is a method to map individual users to a login on the Oracle database but I cannot find a way of allow a group to have...
Hi, this question is related to Reporting Services on SQL Server 2000. When creating a report and setting it to send via email as an attached excel spreadsheet, the email is in the format HTML. Does anyone know if it possible to default this format to something else like Rich Text. I have a...
We have a coldfusion web page that does a query on an Oracle database using ODBC connection and tnsnames.ora. When the database is down it the page displayd this information to the screen. However, we often get in the situation that the database is back up again but the coldfusion page still...
Hi,
I am wondering if there is a way to find out the number of client connections into CICS. I am not interested if a user on a PC has more than one connection open, I just need a count of all the users connected. Hope this make sense.
Anybody have any ideas on how this can be done?
I would like to create a standby database with a different database name and file location to be used in read only mode. This database will be shutdown and recovered using the production archive logs on a nightly basis.
I have no problem creating and updating the standby if it has the same...
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.