Forum Replies Created

Viewing 15 posts - 976 through 990 (of 1,409 total)

  • RE: 50+ tables need to be copied using Data Flow task.

    Perhaps you can use the import/export wizard to create an initial SSIS package. Save this package in the last step of the wizard instead of executing it. Modify the saved...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 7:12 am

    #1629054

  • RE: is it possible to have Single instance(name or SID) on multiple database?

    nikunj_lodhi (7/2/2013)

    Hi Folks,

    I wanted to know that can we have a single instance on two different databases?

    I am till now aware that it is a one to one relation(correct me...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 6:32 am

    #1629031

  • RE: Can you please help me??

    techmarimuthu (7/2/2013)but i wanna extra add distinct for C_recid

    Do you mean there are more records in the resultset with the same value for "C_redid"? And you want just 5 unique...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 5:39 am

    #1629005

  • RE: Snapshot Backups and Transaction Logs

    If "Backup Exec" is really SQL aware then it should be able to do a complete point-in-time recovery, but maybe you can better ask this on a forum of the...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 5:26 am

    #1628999

  • RE: Can you please help me??

    I'm sorry, I didn't understand you wanted the order of the resultset be the same as the sequence order entered in the IN clause.

    That requirement is not a standrd function...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 4:25 am

    #1628973

  • RE: Can you please help me??

    Just add an ORDER BY clause:

    select *

    from customer

    where C_recid in (50200,50194,50430,50191,1)

    order by C_recid

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 4:07 am

    #1628968

  • RE: A New Look

    Toreador (7/2/2013)

    On my screen, approximately 2/3 of the width is white. Why all the wasted space? I don't do my development on a mobile device, and don't read this website...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 4:04 am

    #1628966

  • RE: change dbo login name

    HildaJ (7/1/2013)

    I also tried running sp_changedbuser 'userB' and the query never seems to finish.

    Run the action again and look in the activity monitor (or use sp_who or something else) for...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 2:08 am

    #1628935

  • RE: SQL Server freezes (because of application) need logging

    When it happens again, you could try to connect to the SQL instance using a "Dedicated Admin Conection (DAC)". If you even can't connect to the Windows server when the...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 1:59 am

    #1628931

  • RE: How to Store Data in Database using Data table

    ramanathan.raman88 (7/2/2013)

    c# - Insert data from DataTable to database table

    I see you have edited your original post, but it is still not telling us much. Do we need to guess...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 1:11 am

    #1628922

  • RE: how to insert foreign key value in my table?

    raghuldrag (7/1/2013)

    create table users

    (

    users_id int primary key,

    [...etc...]

    )

    insert into users values('0001','Ram','ram@123','IT','programmer')

    insert into users values('0002','Ra','ra@123','IT','Designer')

    insert into users values('0003','Raju','raju@123','Sales','Area Sales Manager')

    Because your table is created with the column "users_id" with datatype INT, you...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 12:56 am

    #1628919

  • RE: how to insert foreign key value in my table?

    No trigger needed!!

    Just use an INSERT command. The thing you need to take care of is that the value of "users_id" you enter in the [travel_request] table must allready exists...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 12:43 am

    #1628914

  • RE: Query execution plan

    Take a look at the free e-book of Grant Fritchey: Disecting SQL Server Execution Plans

    http://assets.red-gate.com/community/books/assets/sql-server-execution-plans.pdf

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 12:26 am

    #1628909

  • RE: How to Store Data in Database using Data table

    Please explain your question, it is very unclear. Please be more specific and give more information about your situation and what you want to do.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 12:22 am

    #1628907

  • RE: Performance Tuning on Very Small Databases - When is it worth it

    Gail Shaw has said it all.

    It doesn't sound like you hhave a maintenance plan implemented. Do you take regular SQL backups of the databases?

    Take a look at the maintenance scripts...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    July 2, 2013 at 12:18 am

    #1628906

Viewing 15 posts - 976 through 990 (of 1,409 total)