Forum Replies Created

Viewing 15 posts - 7,861 through 7,875 (of 9,720 total)

  • RE: Execute permission denied on package

    What's the package protection level set at? Does the Developer have permissions in the SQL Server that he's running the package against?

    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.

    July 8, 2010 at 9:17 am

    #1190320

  • RE: Suggestion required in creating a maintenance plan

    You should be able to use an Execute SQL Task to check the fragmentation amounts and then have a conditional precedent to lead up to the reorganization task. But I...

    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.

    July 8, 2010 at 9:15 am

    #1190318

  • RE: integration Services Proj.

    You have to use a data conversion task to change the data from WSTR to STR or vice versa. It's like the difference between unicode and non-unicode characters. In fact,...

    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.

    July 8, 2010 at 9:11 am

    #1190317

  • RE: Getting error when changing ProtectionLevel property in SSIS package

    What kind of login / permissions are your connection managers using?

    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.

    July 8, 2010 at 9:09 am

    #1190315

  • RE: passing variables to sql task from script task

    What you need to do is define a variable with a Global scope (or within the scope of the container that both tasks are in). Then in the Execute SQL...

    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.

    July 8, 2010 at 9:08 am

    #1190314

  • RE: Psuedo Partion!!!!

    PeterG-377490 (7/8/2010)

    Trying to be proactive.

    Sales transaction database. 100's millions of rows. I built an access front end for users to view reporting.

    Sounds like if i let the sales columns...

    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.

    July 8, 2010 at 8:45 am

    #1190292

  • RE: How well do you really know your colleagues?

    Ah, my probationary period for one job started right in the middle of a major project. There'd been over a hundred scope changes the the project was due the end...

    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.

    July 8, 2010 at 7:56 am

    #1190245

  • RE: 70-448

    What do you mean summary? And why would someone need to send you their resume?

    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.

    July 8, 2010 at 4:27 am

    #1190108

  • RE: problem getting rid of a log file

    Good point about the TRUNCATEONLY issue being only data files. Maybe that's what I was working on, I don't remember.

    Alen, are you getting a specific error message when you try...

    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.

    July 8, 2010 at 4:25 am

    #1190107

  • RE: Psuedo Partion!!!!

    PeterG-377490 (7/7/2010)

    While i have your attention Brandie - I mentioned the typical query. That query will also return the sales information. Should i use those columns as an included column...

    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.

    July 8, 2010 at 4:20 am

    #1190105

  • RE: Best Alerting System For Small Company

    iqtedar (7/7/2010)

    thanks. One of the issues what i can forsee by using sql agent is that ,lets say i have 200 jobs then i will need to manually add agent...

    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.

    July 7, 2010 at 12:41 pm

    #1189812

  • RE: problem getting rid of a log file

    Did you try running the DBCC Shrinkfile with TruncateOnly after or before the EmptyFile?

    ISTR going through this and I had to run both of them (don't remember the order) before...

    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.

    July 7, 2010 at 12:33 pm

    #1189807

  • RE: Psuedo Partion!!!!

    PeterG-377490 (7/7/2010)

    I am NOT a DBA but have enough knowledge to do damage.

    Don't worry. We all started that way.. @=)

    PeterG-377490 (7/7/2010)

    A typical query would be to search for a transaction...

    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.

    July 7, 2010 at 12:28 pm

    #1189802

  • RE: Best Alerting System For Small Company

    As the others have said, this is all built into SQL Server already. And if there's an alert you can't find, but want, you can make your own.

    And on jobs,...

    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.

    July 7, 2010 at 12:20 pm

    #1189797

  • RE: CTE - Avoiding the cursor

    Eugene Elutin (7/6/2010)

    Post #945638 explains how you can generate random number using NEWID() function without using FranchiseID column to randomize.

    It doesn't uses FranchiseID in the TaxID...

    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.

    July 7, 2010 at 8:44 am

    #1189657

Viewing 15 posts - 7,861 through 7,875 (of 9,720 total)