Forum Replies Created

Viewing 15 posts - 121 through 135 (of 326 total)

  • RE: Locate - Reporting Services actual report

    The report project file will have an extension of .rptproj. You might try doing a wildcard search for the *.rptproj

  • RE: Sql Server Integration Services.

    From BOL:

    If you want to run a package from a 64-bit SQL Server Agent job in 32-bit mode, select a job step type of Operating system, and enter a command...

  • RE: Sql Server Integration Services.

    It looks like the package is running in the 64 bit environment. Packages on a 64 bit server need to run in the WOW layer (32 bit) since SSIS is...

  • RE: Documenting your SSIS package

    One simple thing I'd like to do is just print a list of the package variables, and their properties. Is there an easy way to do that?

    I'm...

  • RE: The Daily Commute

    in Houston, only people with death wish are bikers

    You're not kidding. I moved to Houston in '94 from CO. After getting here, I realized I would get killed if...

  • RE: The Daily Commute

    Let's hope none of your commutes are along the Cross Bronx Expressway in NYC - parts of it are congested over 90 hours a week! They should call it...

  • RE: Send mail to variable recipients

    Actually this is exactly what I have done. I had a look at sp_send_dbmail but I couldn't see how you set the "from" value. This mechanism will be used by...

  • RE: SSIS Execution Error

    I think the problem is that there is no 64 bit Jet driver and packages that need Jet have to run in the 32 bit WOW layer. I vaguely remember...

  • RE: TechEd - Day 1

    We had MSFT give a class in Power Shell. All of .Net, WMI and more is accessible which means you can do everything in PS. Scripting in PS will probably...

  • RE: Intellisense

    Steve,

    I won a copy also and since it is a licensed copy, I have been checking for and receiving regular updates. I now have the latest version and don't...

  • RE: How to disable COLLATE in a table?

    Sorry - I forgot that the less than and greater than symbols are for html tags so it come out right

    ALTER TABLENAME

    ALTER COLUMN ...

  • RE: How to disable COLLATE in a table?

    sharma (5/8/2008)


    Thanks SanjayAttray

    I did

    ALTER TABLE NVARCHARTBL

    ALTER COLUMN NAME COLLATE default

    The above query is correct?

    Bcoz It shows error

    Msg 156, Level 15, State 1, Line 2

    Incorrect syntax near the keyword...

  • RE: SQL2005 SSMS script DROP before CREATE

    jpeables - hmmm - I never noticed that. You would think MS wouldn't miss something like that. :ermm:

  • RE: SQL2005 SSMS script DROP before CREATE

    that is because you don't have SP2 installed. I asked earlier if this was a desktop client or a server.

  • RE: SQL2005 SSMS script DROP before CREATE

    to change the defaults for generating scripts, from the Menu bar select Tools, then options. The Options window should have scripting in the tree. Select it and change the defaults...

Viewing 15 posts - 121 through 135 (of 326 total)