Forum Replies Created

Viewing 15 posts - 121 through 135 (of 478 total)

  • RE: access denied

    Hi there

    Do you mean... "i have 2 named instances on a single server and can only connect to one?" not sure what you mean by "catalog" thats all....

  • RE: Which book to buy for 100$

    Hi there

    I have to say, Ken Henderson's T-SQL GURU book is a great buy. Other option I would seriously consider is http://www.books24x7.com, fantastic site and hundreds of...

  • RE: Goin to PASS!

    Here Here Phil - i put a fantastic proposal in, but in AU$ id have more chance of winning the lotto 🙂

    technet is great, lots of booze and parties are...

  • RE: QOD 03 Sep 2003

    Hi

    If your running a cluster, then fine, but the question didnt mention it.

    The EM is the best way to go, running these for you after the change..

    exec sp_grantlogin N'mydomain\sqlserveruser'

    exec sp_addsrvrolemember...

  • RE: >100,000 Members ? HippHippHurray !!!

    How many of these are the same guys forgetting their passwords? 🙂

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"

  • RE: Stored Procedure Development Cycle

    Hi Robert

    Good article. This and other "change management" process/procedures are critical for ongoing successful change, when I say successful, that mean change with rollout/rollback/hotfix which all cost resources (aka...

  • RE: Metada Services

    Hi there

    Not that I am aware of, it only stores lineage for packages. There is an API btw... use these steps to take a look at it then check...

  • RE: Proxy account does not function

    Hi there

    What privs does the user account have that is executing the xp_cmdshell?

    Are they sysadmin? and if so, does the account running the sqlserver service have appropriate NT privs? ...

  • RE: Invalid characters

    Hi there

    This is strange. FOR XML returns data in UTF-8 format, so this shouldnt be an issue. Then again, it could also be:

    a) the ADO objects being...

  • RE: counting records in tables

    Hi there

    This routines used are unreliable. The updateusage command is a good one before your routine (in a quiet period). Also take a look at sysindexes and the...

  • RE: IIf in sqlserver

    Hi there

    Be aware of this alternatives...

    select case when mycol is null then 'value is null' else 'not null' end

    ..or this..

    select case mycol when 'A' then 'value is A' else 'not...

  • RE: UPDATE (?)

    Hi there, here are some examples of the alternatives, the 1st is the alias example..

    UPDATE MYTABLEALIAS

    SET col1 = 100

    FROM dbo.cktest1 tab1

    INNER JOIN dbo.cktest2 MYTABLEALIAS ON tab1.id = MYTABLEALIAS.id

    OR THIS...

  • RE: How to Use OLE Automation

    Hi there

    One item to watch out for. The return values from the method call (sp_OAMethod) are restricted to 255 characters, so take care with returning large xml blobs for...

  • RE: Cancelling Long Running Reindexing jobs

    Hi there

    YOu didnt mention the actual command being executed here, this is important when debugging the issue. What other work is being run at the same time? lots of...

  • RE: Check Server Transaction Isolation Level

    Hi there

    Remember that transaction isolation is per connection, and not set globally.

    For a user connection, consider the command DBCC USEROPTIONS. I cant remember the exacte issues, but from memory...

Viewing 15 posts - 121 through 135 (of 478 total)