Viewing 15 posts - 121 through 135 (of 478 total)
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....
September 8, 2003 at 2:40 am
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...
September 8, 2003 at 2:35 am
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...
September 5, 2003 at 12:17 am
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...
September 3, 2003 at 3:25 am
How many of these are the same guys forgetting their passwords? 🙂
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
September 3, 2003 at 3:22 am
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...
September 3, 2003 at 1:06 am
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...
September 2, 2003 at 7:25 pm
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? ...
September 2, 2003 at 7:20 pm
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...
September 1, 2003 at 7:36 pm
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...
September 1, 2003 at 6:52 pm
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...
August 31, 2003 at 7:07 pm
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...
August 31, 2003 at 7:03 am
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...
August 31, 2003 at 12:37 am
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...
August 28, 2003 at 9:30 pm
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...
August 28, 2003 at 9:21 pm
Viewing 15 posts - 121 through 135 (of 478 total)