Jeff Moden (3/14/2008)

---

I appreciate the feedback, Johan...

The problem is that most of the Devs nowadays are really GUI programmers that learned just enough SQL to be able to do...

most scripts at SSC need to be executed in a query panel or using sqlcmd unless mentioned otherwise.

So in Sqlserver Management Studio, open a query panel to the desired sqlserver...

- is msdtc running at both instances ?

- did you configure msdtc security ?

Windows 2003 vs other windows ?

- did you add the registry key ?

-- zie...

we monitor this in the sql errorlog by setting the Auditlevel

print 'adjust Auditlevel - Failure';

if charindex('\',@@servername ,0) > 0

begin

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, 2

...

Indeed 70% or our tuning time is actualy sql-education.

If our dev's would only apply the basic rules and also try to write their

code at least in two different ways,

they...

As you stated:

For sure the alternative is using triggers and storing differences only !

Any other alternative will take time ! No...

there is a nice script overhere:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=107424

Isn't that exactly what a sysnonym stands for ?

Check BOL

keep in mind sqlserver needs some background processes to manage the instance/sqlagent/.....

you could create a clustered index and drop it back again.

Keep in mind this will rewrite your table data twice ! as well as the index data.

If you can...

Jay (3/13/2008)

---

I have string data in a field.

0000010011

0020010234

0102020202

What's the datatype of you column ?

I suppose it is char(10).

In that case you would need :

[Code]

alter table yourtable

set yourcolumn char(15)

go

[/Code]

Keep...

- What version of sql2005 is this ? (+ sp + cu please)

- has the package been modified lately ?

- did you try sp_revoke_login_from_proxy and grant it again ?

- Can you post a create proc ddl for this ?

- what data type do you declare the output parameter ?

- Best is to know in front what data type...

I'd suspect someone has been tampering with the proxyaccount itself or that e.g. a password pollicy locked or revoked the user.

Check AD for the proxy user account that it hasn't...

I wouldn't think so. (I'd rather suspect it working on a sp3 and failing on a sp4)

Do they realy toutch the same set of data ?