Viewing 15 posts - 38,551 through 38,565 (of 39,456 total)
The cache clears it self of unused procedures over time.
You should only do this for testing.
Steve Jones
December 20, 2001 at 12:32 pm
There are a few articles on removing admins from SQL. Not too bad in SS2K.
I was more referring to restricting admins on the network,not SQL.
Steve Jones
December 20, 2001 at 12:32 pm
like
select *
from a
inner join b
on a.id = b.id
inner join c
on b.otherid...
December 20, 2001 at 10:10 am
December 20, 2001 at 10:08 am
December 20, 2001 at 10:06 am
December 20, 2001 at 10:02 am
Works on local SQL2K Personal, 2 SQL 2K Server SP1, and on SQL 7, SP2 boxes.
Steve Jones
December 19, 2001 at 5:35 pm
Flag should never be cleared. I control the source, so this as good as it gets. If the flag gets cleared by someone, they'll be explaining to the CTO and...
December 19, 2001 at 2:35 pm
Interesting. I have to admin I have no experience, but I would think that EMC could provide some guidence. I interviewed with a company that had an EMC array on...
December 19, 2001 at 2:33 pm
That's funny (also not). I've used a couple hosting companies and DataReturn did it the right way. They ran a procedure to backup to disk and then grabbed these to...
December 19, 2001 at 2:30 pm
Even easier. look over the article. For special cases, you will need to build a case statement to handle each.
Steve Jones
December 19, 2001 at 11:46 am
December 19, 2001 at 11:24 am
December 19, 2001 at 11:24 am
Are these in the same column or separate? Just makes it easier if they are.
Here's some notes:
http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp
Steve Jones
December 19, 2001 at 11:23 am
December 19, 2001 at 10:37 am
Viewing 15 posts - 38,551 through 38,565 (of 39,456 total)