Search results for query: *

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...

Thanks for the post... I am not quite in a position to test this yet but I am testing partial online restores and then restoring the read-only filegroups later. I can see that we may be able to create a mirror on partial restore primary and apply subsequent transaction logs across the mirror...

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...

That is a shame, would be really handy to be able to do this as it is in keeping with our security structure. Is there a security option to take out the ability to use linked servers?

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...

Thanks for your comments. However, we don't have outlook or exchange on the server so I think it would require a change within Reporting Service. I guess there is a chance that it is just not possible....

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...

Thanks, the problem was will the caching of the ODBC connection which can be altered through the ColdFusion administrator.

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...