Forum Replies Created

Viewing 15 posts - 106 through 120 (of 243 total)

  • RE: Model

    Sorry.My Question is not clear.

    My question is If we create new database from the server it will create the database based on the model database configuration.

    In that case is...

    May 2, 2010 at 12:31 pm

    #1161013

  • RE: @@Servername

    bpflanzer (4/26/2010)

    I've seen this before- I'd bet your server isn't registered as "local"

    Try selecting from master.Sys.servers- (select * from master.sys.servers)

    you're local servername should be server_id= 0

    if it's not- I think...

    April 28, 2010 at 1:41 am

    #1158684

  • RE: @@Servername

    Grant Fritchey (4/26/2010)

    Can you get the information running this query?

    SELECT CONVERT(sysname, SERVERPROPERTY('servername'));

    If not, you may have an issue with the server, it's configuration, your connections... not sure.

    Yes. That select statement...

    April 28, 2010 at 1:33 am

    #1158679

  • RE: Job Failed

    MeltonDBA (4/27/2010)

    Brandie is referring to (I think) when you take a backup of a database, that information (database name, timestamps, file name and path) are kept in system tables. ...

    April 28, 2010 at 1:15 am

    #1158673

  • RE: Job Failed

    Brandie Tarvin (4/27/2010)

    I'm glad it's working now. Sounds like the filename was kept in a table and re-running might have cleared the cache.

    Hi ,

    I could not get you.can you elaborate...

    April 27, 2010 at 11:02 am

    #1158380

  • RE: Job Failed

    Brandie Tarvin (4/27/2010)

    Well that seems to be the problem right there. The job is failing by trying to delete a file that doesn't exist.

    Perhaps you should check the job,...

    April 27, 2010 at 6:26 am

    #1158153

  • RE: Job Failed

    Brandie Tarvin (4/27/2010)

    Does that file even exist? If so, is it perhaps locked by another process?

    No that files is not exist and I could not find when & how it...

    April 27, 2010 at 6:12 am

    #1158141

  • RE: Job Failed

    Error Message from Maintanance Plan Text File...

    [5] Database DatabaseFive: Delete Old Backup Files...

    Unable to delete file G:\MSSQL\BACKUPS\DatabaseFive\DatabaseFive_db_201004251900.BAK. 0 file(s) deleted.

    End of maintenance plan 'Maintenance Plan' on...

    April 27, 2010 at 2:01 am

    #1158011

  • RE: Job Failed

    sani (4/27/2010)

    Hi,

    Please provide more information. Is it Maintenance Plan? If so, Right click on that and view history. Here you can find more detail about M.P. than history provided by...

    April 27, 2010 at 12:37 am

    #1157996

  • RE: @@Servername

    Sourav-657741 (4/25/2010)

    Sudhakara ,

    That's strange..! The serverproperty gives entire details of the SQL server.

    Again cross check the server name from services section.

    Refer the link:

    http://msdn.microsoft.com/en-us/library/aa933172(SQL.80).aspx

    Thanks for all,

    can you tell...

    April 26, 2010 at 1:00 am

    #1157466

  • RE: Services

    Hi,

    Is there any possibilities to get the server running status(Running or Stopped) from the registry?

    Thanks in Advance.

    April 23, 2010 at 8:07 am

    #1156874

  • RE: Database

    ALZDBA (4/22/2010)

    You should contact your mail server admin and ask him/her to allow smtp relay for you sqlservers IP adress.

    Can you share me the link where i can learn about...

    April 22, 2010 at 6:35 am

    #1156029

  • RE: sysmail_server

    Ratheesh.K.Nair (4/20/2010)

    account_idmail account id

    Servernameserver type (SMTP,MAPI)

    servernameMail Server Name

    portPort

    usernameUser name

    credential_id

    use_default_credentials0 for no and 1 for yes

    enable_ssl1 for no and 1 for yes(secure socket layer)

    flags

    last_mod_datetimemodified date

    last_mod_usermodified by user

    Hi thanks your reply... please...

    April 20, 2010 at 6:33 am

    #1154499

  • RE: Database Mail Profile

    Hi. thanks for your reply and query.

    April 20, 2010 at 3:54 am

    #1154427

  • RE: Database Mail

    Verify the following steps from your agent properties:

    1) From Alert System option click the enble profible option. Then select mail system and profile name from which you can send mail...

    April 19, 2010 at 7:57 am

    #1153842

Viewing 15 posts - 106 through 120 (of 243 total)