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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Duplicate Field
Hello, Here is one way you could put it all into one SQL statement. Select * From Price Where PartNumber In (Select PartNumber From Price Group By PartNumber Having Count(PartNumber) > 1) Order By Price.PartNumber- guest2
- Post #4
- Forum: Microsoft SQL Server: Programming
-
DTS secuirty issue - what option to prevent creation of packages
Hello swoodring, If you deny your user execute permissions on the sp_get_dtspackage stored procedure in the MSDB database, that user can no longer create, open, or execute a DTS package through Enterprise Manager. Furthermore, if the user has DTSRun and knows the name of the DTS package, they...- guest2
- Post #2
- Forum: Microsoft SQL Server: Programming
-
IP address
Does anyone know ... how to avoid ip edition? I don't want users change TCP/IP parameters!- guest2
- Thread
- Replies: 1
- Forum: Microsoft: Windows
