Forum Replies Created

Viewing 15 posts - 916 through 930 (of 1,413 total)

  • RE: SP_WHO2

    Try DBCC INPUTBUFFER.

    Also see this thread.

  • RE: sql server 2000 and sql server 2000 64 bit

    What did you execute? Open a new window in Query Analyzer and execute the line below (and only that line):

    SELECT @@VERSION

    Anyway, if you do not know which one you are...

  • RE: Response time measure

    No, you can not change that specific timing. However, you can use SET STATISTICS TIME ON to get some detailed timing information. Look it up in Books Online. Another way...

  • RE: Assign processor use

    Abraham, are you thinking of configuring SQL Server to only use some processors on a multi-proc box? If so, see affinity mask in Books Online for some information.

  • RE: Multiple Transaction log files

    Did they say anything more regarding the scenario in which multiple log files would be useful? It would be interesting to hear about it.

  • RE: Multiple Transaction log files

    The log file(s) are always written sequentially. If there are more than one then only one will be used at a time. When it is filled the log will move...

  • RE: Managemanet Studio Package

    Hm, just noted you did not say you were using SQL Server 2005 Beta 2. However you do say that you installed it 'a couple of weeks ago', so I...

  • RE: Managemanet Studio Package

    SQL Server 2005 Beta 2 is not compatible with Visual Studio 2005 Beta 2. You should download and install the April CTP of SQL Server 2005 from MSDN Subscription or...

  • RE: If Exists and @@Error

    I think Ron is actually looking for errors (and not numbers of rows in result). However I see no reason to do so. For instance, if the table has been...

  • RE: Create Variable Index During SP Execution

    >Even though the flags variable is not stored anywhere I would still like to create an index on it.

    If it is a variable, then no, you cannot create an index...

  • RE: Help needed to implement foreign language support

    Are you sure that this needs to involve SQL Server? If the language setting is on a per-session basis then it should probably only be stored in a cookie or...

  • RE: Importing MSSQL .trc files into MSSQL DB

    >Is there a better way?

    Replace the MySQL server with a SQL Server?

    No, I do not think there is a better way. I would...

  • RE: Error 557

    I think a nice analogy to think of is how texts are translated. If you would take an English text and start translating it into another language, Swedish for example,...

  • RE: dynamic cursor in T-sql

    Oh, I see. That's what I get for trying to tell someone how to use cursors when I never use them myself. Should have just posted the standard-anti-cursor response.

  • RE: dynamic cursor in T-sql

    (Removed incorrect information)

    Why are you using a cursor for this? You do not need a cursor here. And do you really need to be able to execute the query for...

Viewing 15 posts - 916 through 930 (of 1,413 total)