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 TouchToneTommy 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 KABerasley
-
Converting SUSER_NAME to SUSER_SNAME
Thanks, MeanGreen, your suggestion turned out to work fine. I had intentionally not done this because it would not have worked in 6.5. Many of our procedures use temp tables created by parent procedures, tables that don't exist at compile time. Our script file creates the temp table...- KABerasley
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Converting SUSER_NAME to SUSER_SNAME
I'm piloting an upgrade from 6.5 to 2000. I find I need to use SUSER_SNAME now where I've used SUSER_NAME in the past. I have several hundred stored procedures and triggers which use SUSER_NAME. Has anyone developed or seen a way to do this without opening and running several hundred script...- KABerasley
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
