Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 2,010 total)

  • RE: Administering Moss

    I'd suggest you don't leave it out in the sun too long. Mossy databases tend to not react all that well to sunlight. They like dark, damp places...

    -Luke.

  • RE: Using Variables in SELECT statements

    When you put a variable in the SELECT Clause all the Server knows to do is evaluate the variable and output it's contents...

    Select @IDs becomes the exact same thing as...

  • RE: Reporting Services 2005

    Do you mean you're attempting to get your client PC's to point to your new Reporting Server Website? If so a bit of planning now will pay dividends later...

  • RE: Backup Job Lengths?

    If you have these set up as SQL Agent tasks, you could create a script using msdb..sysjobs_view and msdb..sp_help_jobhistory, that way after creating a list of your jobs, you could...

  • RE: Reporting Services 2005

    Not sure what you're asking here...

    Are you talking about moving your current report server database or are you talking about moving the source data of your reports?

    If it's the later,...

  • RE: Add users programmatically

    Well if you want to keep using groups to maintain the servers ssrs security and dont' want to manually add them via SSMS, you could always create a local group...

  • RE: SQL 2008 access

    Did you transfer your logins etc? If I remember correctly when correcting orphaned users, it puts them in the deny data reader group sometimes. check on to make...

  • RE: SSRS (2005) Report Timing out

    The time out is occuring on the report server and in Visual Studio when you run the report locally. the customer ids from the summary report are dumped into...

  • RE: How can I change the word "NULL" in report parameter section for a nullable parameter?

    Unfortunately, other than changing the wording of the prompts there's not much we can do with the parameter selection area, unless you want to write a custom front end to...

  • RE: SSRS (2005) Report Timing out

    Where is the timeout occurring, on the report server or at the source database?

    Have you looked at a trace of this query to see what is happening at the backend...

  • RE: Database Mirroring

    Here's a link to the online version of BOL. On this page you'll find a myriad of how to topics relating to database mirroring.

    -Luke.

  • RE: SQL 2008 access

    I'm guessing you migrated the DB from the 2005 to 2008 server or did you do an in-place upgrade?

    If you migrated the data from one server to another, check for...

  • RE: The "d1" parameter value is missing

    Great!, glad to hear you found a solution.

    Thanks for posting back to let us know what it was too.

    -Luke.

  • RE: The "d1" parameter value is missing

    Couple of things, how are you passing your parameters? in the URL or somehow else...

    The last post in the following has a suggestion which may work for you.

    http://forums.asp.net/t/1265541.aspx

    -Luke.

  • RE: Rather critical perfomance issue

    If you never updated your stats when you copied the file and or depending on the size of your database and how it was copied, then yes, maybe.

    When you re-attached...

Viewing 15 posts - 1,111 through 1,125 (of 2,010 total)