Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by bporter
-
Expanding tempdb
I've moved tempdb around and resized it using a smilar approach, except I saw no need to restart with the minimal flag. Basic steps I did were:<br> <br> - create new default device of desired size<br> - move to RAM, 2 MB<br> - restart<br> - move from RAM<br> - restart<br> - expand tempdb to...- bporter
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Security in SQL Server 7
HIding table structures is practically impossible, as you have to see the table to query it, and they will have the SA password to install the database. It is possible to encrypt stored procedures with the ENCRYPT option which should give you some protection if you keep the database "smarts"...- bporter
- Post #3
- Forum: Microsoft SQL Server: Programming
