Viewing 15 posts - 991 through 1,005 (of 1,319 total)
GilaMonster (7/22/2008)
You are going to switch the autoshrink...
July 25, 2008 at 8:42 am
Are you certain this won't violate your support agreement with the vendor? Some vendors won't tolerate changes made to the database or the application. Also, modifications to third party applications...
July 25, 2008 at 8:37 am
Chris Morris (7/25/2008)
Hi TerryYou don't need to hold your breath - try the code in SQL Server 2k.
Cheers
ChrisM
Son-of-a-gun...I wonder what else I've been missing?? That just proves again that...
July 25, 2008 at 8:11 am
I keep mine on disk for a week but they are backed up to tape and archived daily, so if I need them I've got them. Tapes are reused after...
July 25, 2008 at 7:59 am
RyanRandall (7/25/2008)
Here's an alternative...
select cast(stuff(stuff('280908', 5, 0, '/'), 3, 0, '/') as datetime)
I'm still on 2000 so I though you guys were pulling somebody's chain with "stuff"! But lo and...
July 25, 2008 at 7:47 am
onlykevaly2k - First off, don't hijack threads. A new topic would probably get you faster responses, IMO. Second, what service are you having issues with, the Agent or SQL? Here...
July 25, 2008 at 7:39 am
Personally, I never do a percent growth (and 1% can kill performance if it's growing fast!). Always a fixed amount, depending on growth patterns. My best advice is to monitor...
July 25, 2008 at 7:27 am
First I'd run EXEC sp_change_users_login 'Report'. "Lists the users and corresponding security identifiers (SID) in the current database that are not linked to any login." - straight from BOL
July 24, 2008 at 1:01 pm
While I dont have a 64bit server, I do know if you allocated 18GB to SQL, it will take it. How do you know it's actively using it all? What...
July 24, 2008 at 12:39 pm
nisan.al (7/24/2008)
Tempdb suppose to be growing until there is no more space available.
Not sure that's the situation that I'd want to be in.....Proactive monitoring of your resources and system activities...
July 24, 2008 at 6:03 am
rbarryyoung (7/23/2008)
Yes. This is one of the big reasons why SQL, in its infinite wisdom has Views.
And I assume that you mean "table" and not "file" and that you...
July 23, 2008 at 3:22 pm
Forgot about Microsoft discontining support. I've been off of 7.0 for quite some time, though still on 2000....What I've read on several links is it's not corruption and you've proved...
July 23, 2008 at 12:48 pm
Wasn't sure if I was clear enough...There are multiple references with the Jave code to a table that no longer exists and I'm wondering if there is a way at...
July 23, 2008 at 12:46 pm
Glad you worked it out. Sometimes the most obvious solutions are the ones that'll bite the hardest. Now, about those network admins changing policies on you......:rolleyes:
July 23, 2008 at 9:47 am
Can you log onto the DB2 server using the account from the SQL server agent on DB1?
July 23, 2008 at 9:25 am
Viewing 15 posts - 991 through 1,005 (of 1,319 total)