I don't have access to newsgroups at work, but does Microsoft still run its own security newsgroup?

Frank

http://www.insidesql.de

I hope this will stay bilateral !

Btw, thanks David for the word 'sycophants'. Guess, I will use this internally frequently from now on

Frank

http://www.insidesql.de

One premier source of information on SQL security is http://www.sqlsecurity.com . It contains several further links to white paper on injection, password cracking....

In addition you should consider joining some general...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=14368&FORUM_ID=61&CAT_ID=5&Topic_Title=Bad+practices&Forum_Title=Anything+that+is+NOT+about+SQL%21

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=16123

HTH

Frank

http://www.insidesql.de

Edited by - Frank Kalis on 10/22/2003 02:32:25 AM

But I think you cannot prevent this process.

Different departments in different companies have different needs.

Each uses its own specialities and this makes it difficult to use a standard programm...

but I used the same source of information as you

Frank

http://www.insidesql.de

quote:

---

You beat me by 11 seconds, and basically had the same answer....

---

Sorry, and thanks anyway...

Well, answered my own question.

For my case the use of the undocumented procedure

sp_reassign_dtspackageowner [@name =] 'name',

[@id =] 'id',

[@newloginname =] 'newloginname'

is sufficient.

Frank

http://www.insidesql.de

This topic has been discussed several times here. So when you do a search you will find some threads on this.

Common opinion was not to give programmers permissions to...

Is the original question answered?

Maybe we can get a feedback?

Frank

http://www.insidesql.de

quote:

---

That's interesting, as I would use something like 99991231 if they're not terminated. The termination date is not "unknown" in the...

...along with DBCC DROPCLEANBUFFERS

Frank

http://www.insidesql.de

If an T-SQL statement produces an error, this error is catched in @@error.

You might want to take a look at BOL for @@error -> Using @@error to get some...

Hi,

first take a look at BOL for system tables->overview

quote:

---

System tables should not be altered directly by any user. For example, do not...

Use a maintenance plan (maybe with assistance from the wizard).

You might notice a slight performance overhead, but depending on your hardware you shouldn't be affected too much.

However, although you can...