Viewing 15 posts - 36,586 through 36,600 (of 39,771 total)
Pause does that. Let's everyone finish, no new connections. I think in your job, if it makes one connection, could pause the server, kill connections in the db, run the...
February 6, 2003 at 11:08 am
Possible tape issue. Have you changed tapes? Can you manually run a backup? Perhaps out of space on the tape?
This is the OS reporting and error. I never backup straight...
February 6, 2003 at 11:06 am
Do you have other databases on this server? If not, you can "pause" the server
Steve Jones
February 6, 2003 at 10:59 am
You'd have to use sp_oaCreate to create an ActiveX object. You could use the MS HTTP control and then have it execute the ASP page.
Steve Jones
February 6, 2003 at 10:57 am
Write a stored procedure to delete these.
something liek
delete x
where x.datetimefield < dateadd( y, -1, getdate())
Then schedule this to run every day or week, depending on what you need.
Steve Jones
February 6, 2003 at 10:46 am
Wow. Not sure I've seen a worse one. Granting rights to public is BAAAAADDDDDD!
Steve Jones
February 6, 2003 at 10:15 am
not sure what you mean? If you are in mixed mode, the "sa" account can log in. What do you mean "startup account". The SQL Service account?
Steve Jones
February 6, 2003 at 10:12 am
What is advanced data guarding? Is this RAID5? 1+0?
Sounds like a vendor term.
Steve Jones
February 6, 2003 at 10:08 am
We almost always use the websites (Google, TechNet, MSDN) first. A fair amount of senior people here, so we solve most problems in house, but we're also cutting edge with...
February 6, 2003 at 10:03 am
Not that I know of. There are some good Oracle sites, but since I don't do Oracle, I don't have any refs for you. Might try a Google search for...
February 5, 2003 at 3:33 pm
Thanks for the comment and tips. Glad you liked the article.
Steve Jones
February 5, 2003 at 3:31 pm
When you run the package in em, it runs as you. On the server it runs as SQLAgent. Log into the server as the SQLAgent account and run the package....
February 5, 2003 at 3:26 pm
Create an account, give it a role in that database, make that adtabase the default, remove guest from all other databases.
Steve Jones
February 5, 2003 at 3:24 pm
Spend a few $$ and get a couple more disks. Drop a RAID 1 (2 drives) for the OS and Log. Assuming you won't hit the OS drive much once...
February 5, 2003 at 3:22 pm
February 4, 2003 at 9:09 am
Viewing 15 posts - 36,586 through 36,600 (of 39,771 total)