Viewing 15 posts - 991 through 1,005 (of 1,319 total)
GilaMonster (7/22/2008)
You are going to switch the autoshrink...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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...
-- You can't be late until you show up.
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:
-- You can't be late until you show up.
July 23, 2008 at 9:47 am
Can you log onto the DB2 server using the account from the SQL server agent on DB1?
-- You can't be late until you show up.
July 23, 2008 at 9:25 am
Viewing 15 posts - 991 through 1,005 (of 1,319 total)