I have an associative table between Teams and Issues. Many issues can have many teams, therefore the need for a linking table.
What I'm having trouble with getting a unique combination of Teams out of that table.
For instance, the table has the following values:
ISSUEID TEAM
1...
I have some files that are encoded in the USASCII format. I need to decode them into RTF or TXT format. Anyone know of a way to do this? I am struggling for an answer, but haven't found anything yet.
Any help would be greatly appreciated.
Thanks,
Drew
Yeah, I tried the DBCC SHRINKFILE also, and that didn't change anything. Very weird. I thought maybe you just can't shrink tempdb. I tried it on a user created db, and it did work. It shrunk the database. So I dunno.
I'm gonna try to start and stop SQLServer and see if that works...
We had a process continually run that totally filled up the tempdb which had the option of increase size and no max file size. So now the file size is 16 gig. It's taking up the whole server. It says that only 10 mb are actually being used, so I should be able to shrink it, shouldn't I?
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.