Forum Replies Created

Viewing 15 posts - 271 through 285 (of 782 total)

  • RE: Contained database temporary tables

    Koen Verbeeck (4/14/2011)

    Nice question, thanks.

    The hint (select 2) makes the last answer "None of the above" a bit superfluous 😀

    Same i was too thinking.

    Regards,

    Sushant

    April 14, 2011 at 6:54 am

    #1311551

  • RE: Contained database temporary tables

    .

    April 14, 2011 at 6:52 am

    #1311548

  • RE: Database mail nt sending mails

    CirquedeSQLeil (4/8/2011)

    well you could continue to use xp_sendmail but SQL 2005 and Outlook 2003 don't play nicely. Also, that means installing application software on the server - which isn't...

    April 8, 2011 at 1:44 pm

    #1309385

  • RE: Database mail nt sending mails

    CirquedeSQLeil (4/8/2011)

    The two versions function differently. SQL 2005 no longer requires Outlook be installed so is not plugged into the address book like 2000 was. In 2005, just...

    April 8, 2011 at 12:58 pm

    #1309364

  • RE: Sql Server Agent job

    arun.cnb (4/6/2011)

    HI,

    I have been deleted All job but still running backup job in sql server 2005

    How you know backup job is still running>?

    Regards,

    Sushant

    April 6, 2011 at 7:09 am

    #1307995

  • RE: How to select blank values

    Ninja's_RGR'us (4/5/2011)

    1 - SELECT * FROM table where Column IS NULL

    2 - Are you using left joins? That could cause the same issue.

    Yes, tht did d trick...

    Yes, i am...

    April 5, 2011 at 9:59 am

    #1307566

  • RE: slow performance in sql server 2005

    You can also add up in the maint plan-- checking database integrity to ensure, everything's fine with your db's.

    Also, rebuilding indexes every other day, i think its too long...

    March 25, 2011 at 7:16 am

    #1303558

  • RE: table is slow

    Is that particular table only slow to open??

    Try opening any other and compare the time taken.

    Regards,

    Sushant

    March 23, 2011 at 11:15 am

    #1302620

  • RE: table is slow

    Krasavita (3/23/2011)

    When I poen a table is very slow, what I should? how can I check why and fix the problem?

    poen???

    March 23, 2011 at 10:45 am

    #1302596

  • RE: How to find out SQL Server job and rollback complete percentage?

    track progress of backup--

    SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],

    B.ESTIMATED_COMPLETION_TIME/60000 AS [Remaining],

    B.PERCENT_COMPLETE as [%],(SELECT TEXT FROM sys.dm_exec_sql_text(B.SQL_HANDLE))AS COMMAND FROM

    MASTER..SYSDATABASES A, sys.dm_exec_requests B

    WHERE A.DBID=B.DATABASE_ID AND B.COMMAND LIKE '%BACKUP%'

    order by percent_complete desc,B.TOTAL_ELAPSED_TIME/60000 desc

    Regards,

    Sushant

    March 23, 2011 at 7:20 am

    #1302440

  • RE: Configuration manager

    Dan.Humphries (3/22/2011)

    In 2000 it was called Service manager and should be available in the program folder from the start menu.

    or available at the following

    C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe

    Oh, I am sorry,...

    March 22, 2011 at 10:10 am

    #1301969

  • RE: Linked server error

    vishnubhotla.uday (3/22/2011)

    Hi Sushant,

    Did you add the login credentials you have in the server which you want to use it as linked server?

    Only issues that we generally face with the linked...

    March 22, 2011 at 7:07 am

    #1301853

  • RE: Linked server error

    Attached.

    Regards,

    Sushant

    March 21, 2011 at 3:32 pm

    #1301614

  • RE: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    same question...

    any answers??

    Regards,

    Sushant

    March 21, 2011 at 2:36 pm

    #1301588

  • RE: Linked server error

    Lowell (3/21/2011)

    'LinkedServerName' was the example...you never mentioned the name you gave that server, so all i could post was examples i thought would be intuitive enough that you knew you'd...

    March 21, 2011 at 2:30 pm

    #1301586

Viewing 15 posts - 271 through 285 (of 782 total)