Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 1,790 total)

  • RE: SQL 2008 on development machine, with SQL 2005 on production server

    1) Yes, 2) Yes, 3) I have built reports with 2008 tools and deployed to 2005 RS, and 4) Yes. 😀

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Installing reporting services in a new box for sharepoint integration mode

    The screen shot you show is fairly normal. You should be able to click next and walk through the installation. Be sure to use the Configuration Wizard once the install...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Installing reporting services in a new box for sharepoint integration mode

    madhu.arda (11/7/2008)


    The prerequisite check failed for a default report server installation:First time install, the SQL instance is either not selected or is not a local install.

    Was that the error...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Installing reporting services in a new box for sharepoint integration mode

    Best thing to do would be to get the reporting services installed and then walk through the "Reporting Services Configuration Wizard" under start > programs > ..SQL Server 2005 >...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Migrating Master & MSDB to new servers

    The restore of msdb will take care of jobs and I believe you alerts as sysalerts resides there.

    The procedure that Tracey mentioned will allow you to script out the...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: How to handle views?

    The standard rule of thumb is not to use select * in a view for the very reason that you would have to refresh the view with every change of...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: SET STATISTICS IO Output Missing

    Thanks and I did think about trying that. Have you seen this before? Very curious.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: activity monitor

    Are you referring to Activity Monitor in SSMS in 2008? If so, then you will need to run a trace to collect the different queries that it runs and probably...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Security

    Assuming this is reporting services.... If so, then you need to look at the details of the report (view details when looking at the available reports). You should then be...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: introduce to me

    I would actually use the SQL Server 2005 Books On Line resource first and then search out questions from there.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Are two Servers necessary?

    I struggling a bit with why you would use the same server that you have as a publisher and possibly a distributor unless you have another instance on the same...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Segmentation fault in tempdb

    Just stumbled on this post but wondering where you see these faults? Curious.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Error log message at SQLServer shutdown.

    This link - https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377594&SiteID=1 - should help in troubleshooting this. There are a couple of blog entries as well regarding the warnings you are seeing.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Backup History

    This query which is part of the procedure you are referencing will return all the backups. So, find this portion of the code and look at the query. Start looking...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • RE: Sql Server 2005 Transaction Logging

    chileu17 (10/28/2008)

    my SQL Server 2k5 has only one disk but it's supposed to be able to do parallel read/write operations.

    I would be a bit concerned about this configuration even...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 15 posts - 1,066 through 1,080 (of 1,790 total)