Forum Replies Created

Viewing 15 posts - 751 through 765 (of 1,222 total)

  • RE: Hiding a row

    Subject to testing, it certainly looks like it could produce the same result.

  • RE: TEMPDB vs REPORTSERVERTEMPDB

    Mmm, I think Gift Peddie needs to do a little more research. SSIS packages are easily configured. Most properties that you can set using Visual Studio/BIDS can...

  • RE: Running SQL server as a system account

    The only reason for an service account to be a local administator is if you need the service to be able to do something with that level of privilege. ...

  • RE: REPORTING SERVICES

    I would be very surprised if you can't run both RS2005 and RS2008 on the same server. At the end of the day, reporting services is simply a pair...

  • RE: Add a column in system table(SQL_LOGIN)

    Picking up on what Gail was saying about triggers on the relevant system objects, whilst you can't use a trigger, you could use the "Audit Login Change" event to detect...

  • RE: TEMPDB vs REPORTSERVERTEMPDB

    The location of the files for each database is transparent to the application using them - this includes reporting services. If you are wishing to keep using the same...

  • RE: REPORTING SERVICES

    I would be very surprised if you can't run both RS2005 and RS2008 on the same server. At the end of the day, reporting services is simply a pair...

  • RE: Add a column in system table(SQL_LOGIN)

    Picking up on what Gail was saying about triggers on the relevant system objects, whilst you can't use a trigger, you could use the "Audit Login Change" event to detect...

  • RE: REPORTING SERVICES

    I would be very surprised if you can't run both RS2005 and RS2008 on the same server. At the end of the day, reporting services is simply a pair...

  • RE: Hiding a row

    There is a row property that can be set to conditionally hide a row. You simply code an expression that returns either true or false. The expression would...

  • RE: Replication to Server That Routinely Changes Date

    Transactional Replication does not use the date/time to manage the data that is being replicated. When you consider exactly the sort of scenarios that you have (with servers in...

  • RE: DB Mirroring and Failover

    Are you still having problems ?

    When a failover occurs, your application will get an error because the connection to the database is no longer valid. However, you should then...

  • RE: Query is performing so slow after encryption

    Try the following query instead

    Select * from [MYTABLE] where [MYCOLUMN]= [dbo].[the Function I created for Decryption]('THE VALUE')

    This allows SQL to utilise any indexes that it thinks appropriate.

  • RE: Scripting "Alter table" commands

    This issue was covered in an article by Jonathan Kehayias just last week. Have a look at

    http://www.sqlservercentral.com/articles/Administration/65896/

  • RE: Cannot export a report to a pdf?

    I am wondering whethering it is simply taking a (very) long time to produce the PDF. Reporting Services will re-render the report and I suspec that it is simply...

Viewing 15 posts - 751 through 765 (of 1,222 total)