Forum Replies Created

Viewing 15 posts - 6,376 through 6,390 (of 9,715 total)

  • RE: Can't add permissions to table

    I know this is a stupid question, but did you uninstall it first? Did you try the repair utility?

    As far as Messages go, message is a keyword for Service Broker,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Problem inserting Polish characters into a table

    Did you use a #Temp table or a regular table that you deleted afterword?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    How do they prove they posted the link if it gets deleted?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: how do i import data from sap bw

    I think BAPIs is the way the webservices I know of do it. There's no direct table involvement.

    I don't think I've tried the SSIS adapter, though.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Can't add permissions to table

    Management Studio is just a client tool. If it's corrupt, try reinstalling it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Very slow insert using ssis package

    And don't forget the possibility out-of-date statistics. While most people only think about them when it comes time to read, my opinion is that bad stats can also affect inserts...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Extrapolating Db Size [growth] over time?

    As Ninja said, it's a guesstimate, not a science. But you can average out your monthly growth as a baseline, then talk to the business about upcoming trends. If the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Problem inserting Polish characters into a table

    Latin collation will not allow Polish characters. It sounds like you need to change the database collation. Look up "collations [SQL Server], about collations" in Books Online. (without the quotes)....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SSAS 2k5 - Cube Processing Settings

    Aaaaahhhhh. Good catch.

    For some reason, I had it in my head that all I had to do was leave it at "Report and Continue" and that would cause it...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SSAS 2k5 - Cube Processing Settings

    I'm only assuming. I could never get the cube to process so long as "Key Not Found" was left as "Report and Continue." But as soon as I changed that...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: what datatype to i convert [FILE_RUN_DATE] [varchar](8) to ,to put in the destination [FileRunDate] [datetime]

    Koen Verbeeck (2/24/2011)


    SSIS doesn't have a date datatype, so in my opinion the best option is to do the conversion immediately in the source query.

    The name is deceptive (database timestamp)...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: what datatype to i convert [FILE_RUN_DATE] [varchar](8) to ,to put in the destination [FileRunDate] [datetime]

    adam spencer (2/24/2011)


    Using data task flow

    in source table I am using an SQL command (query text) I have:

    [FILE_RUN_DATE] [varchar](8) NULL,

    in destination It is mappied to this column:

    [FileRunDate] [datetime] NULL,

    a. can...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: how do i import data from sap bw

    The two methods I know of are to either use a webservice to get into SAP's database and call the data that way, or get SAP to provide a csv...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (2/24/2011)


    SQLkiwi (2/24/2011)


    David Benoit (2/24/2011)


    I remember when I took my first programming class, Pascal (Turbo actually)...

    I did a term using Turbo Pascal at University too.

    I remember taking Pascal in...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/24/2011)


    Ian Scarlett (2/24/2011)


    Does this sort of irritating Spam really work? http://www.sqlservercentral.com/Forums/Topic1068979-392-1.aspx

    If I was in the market for one of those, I wouldn't buy from a company that does...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 6,376 through 6,390 (of 9,715 total)