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 ?

did you configure the instance for remote connections (tcp/ip or named pipes) ?

we restore most db to test servers and every once in a while, we even restore the full sqlinstance (second split network).

and if the business wants it, we can...

k.przewozniak (3/12/2008)

---

I know there there is "verify" checkbox, but how do I know that this is doing the same thing like RESTORE VERIFYONLY ?

And how will I know that "verify"...