I was having the same issue after installing SSMS SQL2008R2.

The regsvr fix worked like a charm. 😎

( I first changed my current directory in the command prompt to "C:\Program Files\Microsoft...

- Did you follow the BOL ref "How to: Notify an Operator of Job Status (SQL Server Management Studio)"

- did you create a dbmail profile to be used by...

sqlbrowser only translates instance name to port number.

So, if you don't want to specify port number with your connections, you should activate sqlbrowser.

You'll have to open the udp port for...

Just a little side note :

Keep in mind ms published a "sqlserver migration assistant for oracle"

This may get you started with your plan of attack 😉

If this is a brute force single action operation, you could use something like:

create table #wrk16_17 ( TbName sysname not null, Age17 bit, Age16_17 bit )

truncate table #wrk16_17

set nocount on

declare...

Some questions:

1) Do you really need this update "in transaction / in process" ?

If a single update in database y doesn't succeed (e.g. locked) your whole trigger...

What we do is we create a domain group to manage every server, add that group to the local administrators...

simple .... avoid xp_cmdshell.

There must be more optimal ways to perform the same thing without having to open xp_cmdshell and accept the risks that come with it.

Did you grant exec...

Any news on this matter ?

Good points Suresh.

If this...

That should be ok.

What level of SQL2005 are you on (sp/CU )

Select @@version

or

Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion

...

it's your exec statement that is bogy ....

exec [fnSplitString] [OPI:'0','XYZ','22.0','DES XYZ',\N'1','ABC',44.0','ABC DES',\N'0','XYZ','22.0','DES XYZ',\N'1','ABC',44.0','ABC DES',\N],':',','

should be something like

exec [fnSplitString] 'OPI:0,XYZ,22.0,DES XYZ,\N1,ABC,44.0,ABC DES,\N0,XYZ,22.0,DES XYZ,\N1,ABC,44.0,ABC DES,\N',':',','

have you been granted VIEW SERVER STATE permission ?

I think tosscrosby is spot on !

You should be able to pull that info (alter database) from the instances default trace data.

Have a look at :http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

My registration is completed :w00t:

(it have been two long years without ... :Whistling:)