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!
-
Crazy Tempdb
A Bulk Copy ran this weekend that maxed out the tempdb (by filling the drive). Details on tempdb.mdf - 37 gig - but only 1.44 MB used. DBCC shrinkdatabase had no effect - tried calling it from Enterprise manager and Query analyzer. Theoretically shouldn't I be able to just stop SQL server -...- boogin
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
Question about Set Ansi Nulls on and off
Create the stored procedure via query analyzer. As long as you have the linked server ANSI settings correct - this works. Just did it an hour ago. . . had the same exact problem.- boogin
- Post #8
- Forum: Microsoft SQL Server: Programming
