Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 3,666 total)

  • RE: T-SQL

    I don't agree with calling this tricky. It's only tricky if you start making assumption about what might have been intended as opposed to what is actually there.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Insufficient Disk Space

    Try setting the BufferTempStoragePath property for the Data Flow task to the other drive you want to use.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Regarding a while loop

    Try replacing "@count = @count + 1" with "SET @count = @count + 1"



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: What is the different between MCTS and MCITP for SQL server 2008?

    I believe MCTS (Microsoft Technology Specialist) is one of the lowest levels of certification Microsoft offers. MCTS certifications only cover "narrow" topics.

    To get the MCITP for SQL Sever you...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Connect to another SQL Server Database Within a Stored Proc

    The normal way to do this is to setup a linked server pointing to the other server. You can then access it's data by using ServerName.databasename.Schema.tablename. You should...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS packages Scheduling(Sequential)

    ...when designing the package is it necessary to add EXECUTE PACKAGE TASK ?....

    To do what? You only need that if you want to execute another package from within that...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS packages Scheduling(Sequential)

    If you want email notification on the individual steps then that should be programmed into each package.

    SQL jobs notify after the job completes, not after each step.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL tool(s) to create ERD and forward engineer into database?

    If anyone knows better then please correct me if I'm wrong.

    I like what I can do with Visio for a reasonably low cost. The problem I have with Visio...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Is It Worth Upgrading to SQL Server 2008

    There might be another good reason to upgrade to 2008.

    First let me say that I'm not on top of all the latest developments.

    Did M$ fix all the 2005 bugs? ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS packages Scheduling(Sequential)

    Can we get a bit more information?

    You want B to run after a successful run of A. What do you want to happen if A fails?

    I suspect you can...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL tool(s) to create ERD and forward engineer into database?

    I feel your pain Barkingdog.

    I went thru the same thing. I'm so disappointed at Visio for not being to push the design to a database.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: insert into

    The query expects eventstatus_bek_IGA to already exist. Does the table exist?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Need to change 1000 SP's drop & re-recreate them with permissions?

    Garadin (10/9/2008)


    Rather than updating 1000 SP's, couldn't you just create a view named what the table used to be that references the new database / table with a SELECT *...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: best backup Strategy

    Where I'm working now, for the non-system databases, we typically do transaction log backups every 30 minutes; differential backups daily; and full backups weekly.

    We do a full backup of system...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SELECT queries

    Because sometimes the data you want does not lie in just one table and you have to query all the required tables at the same time in order to get...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 3,541 through 3,555 (of 3,666 total)