Forum Replies Created

Viewing 15 posts - 61 through 75 (of 351 total)

  • RE: Batch file in SQL Procedure

    Minnu (5/17/2013)

    Hi Team,

    Am trying to call a batch in sql server stored proc.

    CREATE PROCEDURE test_batch

    AS

    BEGIN

    tdeclare @bat varchar(200)

    set @bat = 'd:\test\test.bat'

    ...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    May 17, 2013 at 1:38 am

    #1616077

  • RE: SQL Service Broker suddenly stops working

    eamasalunga (5/17/2013)

    Hi,

    Yes I've tried disabling and re enabling the queue, restored the database, restarted the sql service and even restarted the server itself but still getting the said error.

    Please check...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    May 17, 2013 at 1:22 am

    #1616071

  • RE: SQL Service Broker suddenly stops working

    Have you tried Stopping and starting the queue..?

    here link

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    May 17, 2013 at 12:45 am

    #1616057

  • RE: Low Batch Requests/Sec?

    rsorrentino (5/2/2013)

    I have SQL server 2008 running on a Dell Server with 8 processors and 24 Gb RAM. Every few weeks the third party applications receives an SQL timeout...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    May 2, 2013 at 3:14 pm

    #1612034

  • RE: Ports and Firewall changes for named Instance

    Sqlism (5/1/2013)

    One more similar Question.

    I can connect to SQL Server by RDP to that server but not with my management studio. what i am missing here ?

    Thanks!

    Check TCP/IP is enabled.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    May 1, 2013 at 5:47 pm

    #1611754

  • RE: Sql server 2008 installation problem( must specify valid information for parsing the string)

    There are multiple ways to get the currently running queries,

    One way is through this script[/url].

    The script is same as you running the activity monitor.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    May 1, 2013 at 10:45 am

    #1611646

  • RE: Are my statistics being used?

    Usually statistics will be created when you created an index or when a select statement where condition column doesn't have index will also create statistics.

    Statistics will occupy some disk space...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    May 1, 2013 at 1:50 am

    #1611484

  • RE: read values in column from xlsx files in SSIS

    Take 2 excel sources and select only 1 attribute in each as you requeried then use a lookup tranformation and excel destination. i hope understand

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    April 17, 2013 at 4:43 pm

    #1607483

  • RE: Log File full / Database Down

    Why did you restore a dB ?

    Instead you would have been taken a log backup that should cleaned the log file.

    Is it a production database ?

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    February 25, 2013 at 7:48 pm

    #1591002

  • RE: Moving SQL Server 2008 R2 Single instance to new domain

    Guras (2/6/2013)

    We are migrating to a new domain and I have few questions -

    1. I need to change the SQL server start up service account from domain1\SVC_SQL to domain2\SVC_SQL

    No...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    February 6, 2013 at 1:00 pm

    #1585112

  • RE: SSRS report runs a lot slower on one of 2 SSRS instances

    Does S1 and S2 has same configuration of RAM, CPU, traffic and NETWORK Speed ? all of these makes a diffrence too

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    February 6, 2013 at 12:20 pm

    #1585093

  • RE: Compare two tables cell by cell

    adonetok (2/6/2013)

    I need to compare two tables cell by cell in order to delete one.

    They have the same size and data structure. (More than 5000 records, has the same columns'...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    February 6, 2013 at 12:15 pm

    #1585091

  • RE: Data file unused space issue

    You could shrink database to release the unused space anyways..and set to auto growth on data file.

    Even though your database is in simple mode, the log file will grow bigger...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    February 1, 2013 at 12:37 pm

    #1583556

  • RE: Corrupted Database

    I haven't queried that and I would try querying that in an hour or so.

    Could you please tell me what about it?

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    January 29, 2013 at 5:18 pm

    #1582429

  • RE: Corrupted Database

    Can you run CheckDB on the 2005 database? Or do you not have a pre-upgrade copy?

    --Cannot run dbcc checkdb, also no pre-upgrade backups

    Did the DB switch into emergency mode without...

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

    January 29, 2013 at 4:18 pm

    #1582421

Viewing 15 posts - 61 through 75 (of 351 total)