The link is quite funny. And if true then I bet those guys got a real good duty after that if not court martialed.

Good to know is RSA and DESX...

Even then when a stored procedure is run you cannot concatenate two vairables to a single parameter. Even if both where 4000 in length it is not valid syntax.

Then like...

Sorry, braindead some days. We have moved on to the same practice under ADO without a DSN. But we still only attach to one DB and then allow the app...

Very interesting article. I will have to play with the concept sometime.

That is a very good issue indeed. This is when you get into splitting some further where they are transactionally affected and mix only those that relate to each other...

Always limit counters to only what ytou need. Also if the server is not under extreme load run from there, otherwise closets box you can get to it reduce overall...

quote:

---

Thanks to you both for your timely replies. The cache ratio is NOT taking a hit, which is part of what...

Good article. However it is only a matter of time before someone will figure out how to crack the password schema of anything. Especially if the password storage is easy...

Actually MS has never changed their stance on Security of packages. You should password protect them (however you should keep up with the password too). And you should use a...

Nope MS has to make configurable to please mostly the government but other high end users.

First download the updated SQL BOL for most current information. But in Indexes type in "instances of SQL Server" and choose the "memory usage" subitem. There you will find additional...

If and application please let us know the name of the app as well. It should be sending something to the effect of

UPDATE tblX SET colx = valx (WHERE clause...

If connecting to a SQL Server to force it to use the logged in users security credentials instead thru Windows Authentication.

First the users must be logging into the local server...

It also means you are using the SQL 7 Enterprise Manager. Bills answer is correct.

However they got so many complaing that it was confusing as they thought red ZigZag meant...

Since SQL does not perform any better on XP than 2000 then there is no comparison. It does not cause any differences so there is nothing specific that will affect...