Forum Replies Created

Viewing 15 posts - 301 through 315 (of 320 total)

  • RE: how to take a backup as sql server authentication from a remote system to the server using t-sql script

    follow that Syed Jahanzaib said! is necessary to attribute the permissions to account service in folders out of database server!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    May 27, 2011 at 7:59 am

    #1331001

  • RE: Standard to Enterprise, In-Place or New Installation

    New instance and migration of databases!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    May 27, 2011 at 7:49 am

    #1330995

  • RE: Msg 8501, Level 16, State 3 problem - wierdness rules

    is clustered server? because i found this link for SQL 2K0 in environment W2K3 with problem on MSDTC!

    this link: http://support.microsoft.com/kb/889706/en-us

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    May 25, 2011 at 1:40 pm

    #1329916

  • RE: SQL 2008 R2 on a production Svr

    Damian-167372 (5/18/2011)

    Hi Guys

    Is the SQL 2008 R2 a stable version? is it worth upgrading SQL 2008 to > 2008 R2?

    I use SQL 2K8 x64 SP2 CU2 and is very stable!...

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    May 25, 2011 at 6:16 am

    #1329616

  • RE: Error while opening SQL Server job

    what's version of SQL? and what do you running in job?

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    May 24, 2011 at 7:04 am

    #1329020

  • RE: Resource Governor - Memory

    Colleen M. Morrow (4/29/2011)

    Please take a look at this thread by someone else facing the same issue.

    thanks! i had no choice and i migrated to SQL Server x64 with W2K8...

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    May 23, 2011 at 10:16 am

    #1328563

  • RE: SSRS Report on Local Server works fine but not through Remote server

    in Management Studio, you must be logon on instance of report server and enable the property EnableRemoteErrors to see more details that error.

    follow this -> Management Studio -> in screen:...

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    May 17, 2011 at 6:27 am

    #1325726

  • RE: SSRS Report on Local Server works fine but not through Remote server

    can you post the errors on remote access??

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    May 16, 2011 at 10:09 am

    #1325241

  • RE: Resource Governor - Memory

    Colleen M. Morrow (4/29/2011)

    Can you post the results of this query, please?

    select * FROM sys.dm_os_performance_counters WHERE object_name like '%Memory Manager%'

    follow attachment: dm_os_performance_counters

    The strangest fact is that in the Task Manager...

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    April 29, 2011 at 8:49 am

    #1317823

  • RE: Resource Governor - Memory

    TRACEY-320982 (4/29/2011)

    sp_configure or right click sql server name properties to change default memory settings. Not looking at SQL but i am sure that the place.

    whats the version of SQL...

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    April 29, 2011 at 7:41 am

    #1317801

  • RE: Resource Governor - Memory

    but i can just set max_memory_percent, only percent for use! and how do i change the value column max_memory_kb????

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    April 29, 2011 at 5:03 am

    #1317723

  • RE: Resource Governor - Memory

    it´s SQL 2K8 Enterprise (32bit) and AWE is enabled and the service account is in local policy!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    April 28, 2011 at 1:34 pm

    #1317509

  • RE: OUTPUT & NEWID()

    great question! Initially, I analyzed the text in question and then I found the command's return is not fixed, after running it several times, really it can be any value...

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    April 25, 2011 at 6:27 am

    #1315391

  • RE: Length

    the question is completely wrong, the text in question is saying, 'nvarchar' and not 'nchar'

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    April 11, 2011 at 5:49 am

    #1309753

  • RE: Scaled-down SQL

    fantastic question!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    March 21, 2011 at 8:12 am

    #1301323

Viewing 15 posts - 301 through 315 (of 320 total)