Forum Replies Created

Viewing 15 posts - 151 through 165 (of 248 total)

  • RE: 1130(Not enough server storage is available to process this command)

    vishal-713648 (9/17/2009)

    yes im taking backup of all db's through a single SP.....

    the job is failing for the first db itself

    To make sure where exactly the problem is, Can you please...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 17, 2009 at 11:26 pm

    #1055383

  • RE: dts creation

    Well, the best place to start is SQL Server Books On Line under topic "SSIS".:-)

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 17, 2009 at 3:23 am

    #1054852

  • RE: DBCC CHECKDB PROBLEM

    vchawla-1033989 (9/17/2009)

    Vishal,

    That's the best practice.But in my scenario, it's not like that and even we can't do without appropriate permissions & all....Now what can be done to resolve that problem...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 17, 2009 at 1:34 am

    #1054828

  • RE: how to find the default instance

    Default instance name is always same to your machine name. for example if your server name is mydbprodsvr, the default instance name will be same as SQL Server (mydbprodsvr).

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 17, 2009 at 1:26 am

    #1054823

  • RE: DBCC CHECKDB PROBLEM

    That's why TempDB should have more than one data file across disk drives.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 17, 2009 at 1:23 am

    #1054821

  • RE: SQL Server login problem

    Sergey Vavinskiy (9/16/2009)

    You don't need a separate job for logins mapping.

    I believe you have a scheduled job for you nightly restore.

    So, just add one more last step to this job...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 10:37 pm

    #1054800

  • RE: SQL Server login problem

    Vishal Singh (9/16/2009)

    Check what all jobs are running during night. Anything, related to Audit or users.

    Or incase you have anightly restore, you can use the below script for an automated...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 7:02 am

    #1054401

  • RE: SQL Server login problem

    Check what all jobs are running during night. Anything, related to Audit or users.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 7:00 am

    #1054397

  • RE: Primary file group tables move userdefined file group

    I would suggest you read "Alter Table" topic in SQL Server Books onLine.

    It has almost everything you need.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 6:58 am

    #1054395

  • RE: Login Failed - Login already has an account under a different user name

    Or Query sys.SQL_logins table.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 6:43 am

    #1054383

  • RE: Non-privileged users had the privileges to discover the password used in DTS

    SanthoshViswanathan (9/16/2009)

    Vishal,

    What I meant by Non-privileged users was users other than sysadmin users(DBA's)... Ofcourse the Non-privileged users have access to SQL Server...

    Sorry if I was not clear on that... 🙂

    Now...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 6:39 am

    #1054381

  • RE: Non-privileged users had the privileges to discover the password used in DTS

    SanthoshViswanathan (9/16/2009)

    Security audit was done by a third party... I believe they used some tools for this purpose... In their final output to the management they gave this point that...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 5:21 am

    #1054352

  • RE: mirroring and backup issue

    Can you give me more details how to set it up?

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/25a44245-e28d-41b5-ad65-7778d50c42ea.htm

    This is pretty much thorough.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 4:41 am

    #1054338

  • RE: Non-privileged users had the privileges to discover the password used in DTS

    Duplicate post.

    Please post on

    http://www.sqlservercentral.com/Forums/Topic788812-146-1.aspx?Update=1

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 4:38 am

    #1054334

  • RE: Non-privileged users had the privileges to discover the password used in DTS

    Firstly, Can you elaborate it how come a user who doesn't have privilege is able to discover the DTS password?

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    September 16, 2009 at 4:38 am

    #1054333

Viewing 15 posts - 151 through 165 (of 248 total)