Forum Replies Created

Viewing 15 posts - 46 through 60 (of 243 total)

  • RE: Execute a SSIS Package with xp_cmdshell

    lucazav (10/10/2008)

    I got the solution empirically... The package goes on with this string stored in the @cmd variable:

    C:\Progra~2\Micros~2\90\DTS\Binn\DTExec.exe /DTS \MSDB\StratificaGiacenzaDaCSV /SERVER DV-ERP /SET \package.variables[strRollUpDate].Value"; 2008/10/01 23:00" /MAXCONCURRENT " -1...

    November 10, 2010 at 6:45 am

    #1248823

  • RE: VDI

    muthukkumaran (11/2/2010)

    Check with below MS link

    http://technet.microsoft.com/en-us/library/aa337272.aspx

    Did you recevie this type of error perviously ?

    No

    What's the DB size ?

    Size 800 GB

    Backup Drive have has sufficient space ?

    Yes

    November 2, 2010 at 10:14 am

    #1245522

  • RE: VDI

    Adiga (11/1/2010)

    sudhakara (10/30/2010)

    Hi,

    Am getting below error message while taking the backup using the third party product on sql server 2000(SP2) on windows server 2000.

    2010/10/25 01:18:34 pid(6044) tid(6376)

    Error on...

    November 2, 2010 at 5:31 am

    #1245287

  • RE: VDI

    sql_lock (10/30/2010)

    A good start would be what is the 3rd party product?

    If it is symantec then look at the link below.

    http://www.symantec.com/business/support/index?page=content&id=TECH37461

    Using Light speed for taking the backup of the database.

    The...

    October 30, 2010 at 8:11 am

    #1244531

  • RE: Working Set

    chris.s.powell (10/29/2010)

    Is AWE enabled on the SQL Server? How much memory do you have allocated to SQL Server - if more then 2 GB you will recieve this error.

    we...

    October 29, 2010 at 11:24 am

    #1244350

  • RE: will DELETE deallocate used space as well ?

    Adi Cohn-120898 (2/12/2009)

    Actually as far as I know when you delete records even if the page is empty, it will still belong to the table. Truncate table will release...

    October 21, 2010 at 12:48 am

    #1240080

  • RE: Job Success

    SKYBVI (10/20/2010)

    @ sudha...

    check if you have enabled the option verify backup once finished

    Regards,

    Sushant

    I think i have enabled that option. will check and update you. what would happen if i have...

    October 20, 2010 at 9:19 am

    #1239767

  • RE: Job Success

    Adiga (10/20/2010)

    Hi Sudhakara,

    Check the job properties if "Quit reporting Success" is selected when the job fails. Add an output file to

    the job step. This will give you more details...

    October 20, 2010 at 9:16 am

    #1239759

  • RE: Counter

    Adiga (9/21/2010)

    Here is one which explains Memory counters

    Hi,

    Thanks for your reply.

    Memory Grants Outstanding

    Number of processes that have successfully acquired workspace memory grant. High value of this counter indicates peak user...

    September 21, 2010 at 11:42 am

    #1225099

  • RE: SHRINKFILE

    Hi,

    I have two data file's in the same file group.

    August 18, 2010 at 11:34 pm

    #1208895

  • RE: SHRINKFILE

    Steve Jones - Editor (8/18/2010)

    I believe that data is moved to other files in the filegroup, round robin style, and then the file is emptied.

    Hi,

    Thanks for your reply. My database...

    August 18, 2010 at 10:44 am

    #1208626

  • RE: SHRINKFILE

    Hi,

    Yes. I got the information from MSDN. i knew that it will move the data's from spcified file in command to another mdf or ndf files.

    what i want know is...

    August 18, 2010 at 8:28 am

    #1208525

  • RE: Could not allocate space for object, the ''PRIMARY'' filegroup is full.

    Hi,

    Did you try to Empty the file by using the dbcc shrinkfile(4,emptyfile)?

    August 17, 2010 at 8:43 pm

    #1208246

  • RE: AWE

    sqlbuddy123 (7/28/2010)

    Hi Sudhakara,

    From what I remember ..

    ...

    July 29, 2010 at 10:44 am

    #1199929

  • RE: AWE

    Richard M. (7/28/2010)

    sudhakara (7/28/2010)

    jezza101 (7/28/2010)

    sudhakara (7/28/2010)

    But i dont know why only 4 GB can able to access even if i have 6 GB of RAM in my system.

    You might find...

    July 28, 2010 at 7:47 am

    #1199240

Viewing 15 posts - 46 through 60 (of 243 total)