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....

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 books... save...

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...

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...

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"

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...

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...

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? ...

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...

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...

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...

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...

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...

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...

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...