Forum Replies Created

Viewing 15 posts - 256 through 270 (of 285 total)

  • RE: how to enable auditing in sql server 2005

    anjan.ashok (5/6/2009)

    I am using Enterprise edition with sp3.

    Did you installed SP3 recently? check the log file of sp3 installation as may be due to some failure in sp3.

    Hope this helps...

    May 7, 2009 at 9:35 am

    #990435

  • RE: Job step edit error

    vmenon (11/4/2008)

    Please can you try out the following:

    RUN AT THE COMMAND PROMPT ON SERVER: REGSVR32.EXE dts.dll

    You can fing the dll file at the location :\Program Files\Microsoft SQL Server\90\DTS\binn

    Hi,

    I had the...

    May 4, 2009 at 8:07 am

    #988098

  • RE: Database Mail

    Todd,

    Try the following:

    account name: your SQL server instance name

    PORT: let it be the default

    smtp: your smtp server name (smoething like smtp.gmail.com)

    authentication: use any (like windows, SQL server or any)

    The...

    May 1, 2009 at 5:59 pm

    #987638

  • RE: Maintenance Plan - System Databases - More than just backup?

    mjcnospam-general (4/28/2009)

    Thanks to all who replied. This helped me get on my feet!

    Best,

    Mike

    HI Mike,

    This is a very good article by Brad M. McGehee

    http://www.sqlservercentral.com/blogs/aloha_dba/archive/2009/04/16/the-maintenance-plan-wizard-can-lead-you-astray.aspx

    It gives you a brief...

    April 28, 2009 at 9:14 am

    #985205

  • RE: Index Fragmentation

    radek (4/24/2009)

    Hi,

    I have clustered table with few nonclustered index. I need to do defragment.

    Which indexes firs? The clustred ? I think? ,then nonclustered? If I understand it correctly...

    April 25, 2009 at 9:31 am

    #983973

  • RE: Connection to SQL server 2005

    dmc (4/22/2009)

    You may have an issue with your VPN setup. Kind of hard to tell without knowing more about your setup. Can you ping your test server, telnet,...

    April 22, 2009 at 11:20 am

    #982365

  • RE: Index Fragmentation

    GilaMonster (4/20/2009)

    Except for the first one, all the others are far too small to even worry about fragmentation.

    Hi,

    Thanks for your quick reply. Just curious, how did u tell that "others...

    April 20, 2009 at 2:49 pm

    #981050

  • RE: Need to know what SQL code is generated by application

    Jack Corbett (4/17/2009)

    What about using replication?

    Hi Jack,

    Replication came to my mind first. But when I analyzed my situation, it is not a good solution to implement.

    In my situation, the...

    April 17, 2009 at 7:35 am

    #979662

  • RE: Need to reflect changes made in test to Production

    noeld (4/14/2009)

    Let me explain why I said that.

    - Replication can affect the Publisher if the subscriber is down. So Do you really want to affect Production if TEST has a...

    April 15, 2009 at 7:50 am

    #978076

  • RE: Need to reflect changes made in test to Production

    noeld (4/14/2009)

    Replication from TEST to PROD or from PROD to TEST is never a good idea.

    Thanks for your input..

    But my requirement is that what ever the change is made to...

    April 14, 2009 at 12:04 pm

    #977507

  • RE: Overwrite data in excel using SSIS

    Princess (4/1/2009)

    Hi,

    I have creted a package that gets data from a table and adds it to a excel worksheet. The problem is everytime I run the packge it appends to...

    April 2, 2009 at 9:10 am

    #970812

  • RE: Find out duplicate rows from multiple table

    Jeff Moden (3/4/2009)

    ... and, no... sorry... I don't know how to write a script to do it for 300 different tables auto-magically... no way to know which columns make up...

    March 5, 2009 at 12:18 pm

    #954290

  • RE: Find out duplicate rows from multiple table

    beezell (3/4/2009)

    This sounds like a bit of a complex problem. The issue will be that each table has a different column that will identifiy it as being duplicated. ...

    March 4, 2009 at 5:19 pm

    #953713

  • RE: Restore Script

    klnsuddu (2/18/2009)

    Hi,

    Could you give some simple Restore script. I found some on this forum, but I need some to understand.

    1.to restore full backups to different drives

    2.to restore diff backups

    3.to restore...

    February 19, 2009 at 7:45 am

    #946684

  • RE: Another Licence Question.

    Simon Smith (2/12/2009)

    Just a quick question on licencing (again) as I can`t deduce the answer from Microsoft.

    I have 10 SQL servers licenced on a CAL model and 10 SQL servers...

    February 13, 2009 at 8:03 am

    #943629

Viewing 15 posts - 256 through 270 (of 285 total)