Viewing 15 posts - 34,726 through 34,740 (of 39,725 total)
It should be all changes that were not committed. Does this not seem to be the case?
July 26, 2004 at 10:27 am
I don't usually recommend this, but I'd use a cursor for this. Assuming that recno is an actual field in your table, use that and run a loop. Actually you don't...
July 26, 2004 at 10:21 am
There are some things in SQL Server that are extremely intolerant of delays. Backups is one and tempdb may be another. Since it is used at a low level by...
July 26, 2004 at 8:37 am
Never tried it and I don't see the option in XP. I'll see if I can dig something up.
July 26, 2004 at 8:33 am
Good question. I'm not sure. I need to dig into the forum code a bit and see. It's from the InstantForum.com guys, so they'd need to support it.
July 26, 2004 at 8:26 am
You can use the GUI or ALTER DATABASE command to set the initial size higher.
July 23, 2004 at 2:27 pm
Can't do it retroactively. You have to setup a process to check the space once a day or so and store it somewhere. I used to do this for backups...
July 23, 2004 at 8:28 am
It's been suggested and it's on our list. I agree with you, just a few things that are broken first. We'll get to it.
July 23, 2004 at 8:22 am
You should use IP or setup a local DNS to connect. Using the servername won't work across most VPNs. Only FQDNs.
July 23, 2004 at 7:35 am
I'd recode the triggers to do the same thing as the sp_start_job. In general, you never want to trigger some process with a trigger because the transaction will never complete.
July 23, 2004 at 7:32 am
Through a linked server, any query will do.
if exists( select top 1 * from sysusers) insert logtable
will do it from the source server.
July 23, 2004 at 7:28 am
If it's something regular, I agree with DMO. I had a DMO script to check all logins on all servers for blank passwords at my last job. I can try...
July 23, 2004 at 7:23 am
dateadd( h, x, cast( datefield as datetime))
where x is the hour difference. datefield is your column.
July 23, 2004 at 7:20 am
Is it one account, like a sysadmin account?
Have you checked for roles or perhaps some other changes that might have been made on one box you are not aware of? sounds...
July 23, 2004 at 7:15 am
Definiteiyl not a stupid question.
Using a second server or second instance is the best awy to go. It won't see your databases and so they will be suspect on the...
July 23, 2004 at 7:12 am
Viewing 15 posts - 34,726 through 34,740 (of 39,725 total)