Forum Replies Created

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

  • RE: SQL Server sysprocess data

    Ninja's_RGR'us (8/9/2011)

    @SQLFRNDZ (8/9/2011)

    If you are working on 2008 version

    you can make use of this dmv in the script

    sys.dm_resource_governor_workload_groups

    See the comment lines in the above script

    Tx I forgot...

    August 9, 2011 at 1:40 pm

    #1366236

  • RE: how to run a sql from other servers without using linked servers

    Jayanth_Kurup (8/9/2011)

    deepak.a (8/9/2011)

    Jayanth_Kurup (8/9/2011)

    There are plenty of alternatices which one would be best depends on what your trying to achieve.

    I would add something too Registered Servers

    August 9, 2011 at 1:37 pm

    #1366232

  • RE: Need Help with a Question

    GilaMonster (8/9/2011)

    suhailtajraja (8/9/2011)

    interview

    What the interviewer was trying to ask, almost certainly, was for the names of the two pseudo-tables that are visible within triggers and nowhere else.

    A google search for...

    August 9, 2011 at 1:28 pm

    #1366218

  • RE: SQL Server sysprocess data

    If you are working on 2008 version

    you can make use of this dmv in the script

    sys.dm_resource_governor_workload_groups

    See the comment lines in the above script

    August 9, 2011 at 1:23 pm

    #1366214

  • RE: Need Help with a Question

    suhailtajraja (8/9/2011)

    I am referring to system tables accessible from DML triggers. please name them.

    SELECT * FROM sys.objects WHERE type='S'

    Execute this on a any database you are reffering to gives...

    August 9, 2011 at 1:18 pm

    #1366205

  • RE: Manage Resource

    vino5786 (8/9/2011)

    Hi ,

    Thanks for the reply.. what is VM?

    VM is Virtual Machine like VM ware.

    August 9, 2011 at 1:11 pm

    #1366196

  • RE: Opening .sql in SSMS - R2

    Yes that true , I'm not missing that

    SSMS is OPEN and CONNECTED,

    I'm telling that it prompts when you close first opened file(Query Analyzer) and open the Second .sql file

    in this...

    August 9, 2011 at 11:48 am

    #1366119

  • RE: Manage Resource

    First thing coming into my mind is VM.

    August 9, 2011 at 11:44 am

    #1366111

  • RE: Linked Server Basics - Who can use them

    Steve Jones - SSC Editor (8/9/2011)

    You can't put an Oracle login on the local side

    Might be I'm understanding wrong but

    You can have the Oracle Login on local side...

    August 9, 2011 at 11:40 am

    #1366107

  • RE: Opening .sql in SSMS - R2

    SQLRNNR (8/9/2011)

    @SQLFRNDZ (8/9/2011)

    schleep (8/3/2011)

    Hi all,

    But, when SSMS is already open, the query window opens connected to the last server against which I last ran a query.

    Thanks!

    Even when you have SSMS...

    August 9, 2011 at 11:26 am

    #1366097

  • RE: Opening .sql in SSMS - R2

    schleep (8/3/2011)

    Hi all,

    But, when SSMS is already open, the query window opens connected to the last server against which I last ran a query.

    Thanks!

    Even when you have SSMS Opened

    When...

    August 9, 2011 at 11:11 am

    #1366084

  • RE: SQL Server Management Studio installation

    Did you check the installation media(SQL Server Version) is compatible 32 bit? If it is 64 bit you would have get the error right away.

    Also retry restarting the services.

    August 9, 2011 at 10:57 am

    #1366074

  • RE: SQL Server Management Studio installation

    What version is the pre-existing one ? Just making sure you are installing only 2008 client tool ssms not the database engine right?

    August 9, 2011 at 10:56 am

    #1366072

  • RE: Plot graphs from SQL table

    you can use SSRS or Tableau for that.

    I prefer SSRS as it ships with sql server.

    August 8, 2011 at 5:03 pm

    #1365595

  • RE: Using SSIS

    Invalid Number of columns in Source and destination.

    August 8, 2011 at 3:37 pm

    #1365560

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