Viewing 15 posts - 34,786 through 34,800 (of 39,723 total)
Drop them
Why would you want to? Updte them, I mean. They are not "rebuilt" on updates.
June 29, 2004 at 5:54 pm
June 29, 2004 at 10:35 am
You're having network issues. The backup routine is very intolerant of any network latency. Backup to the local drive and the move it to the shared drive.
June 29, 2004 at 10:22 am
Brian Knight has some articles on clustering on this site. As far as load balancing, I'm assuming you're active/active and you are looking to move some dbs to each server...
June 29, 2004 at 10:17 am
I hate applications like this.
, my buddy builds an accounting app like this and I always complain about this crap. He says they...
June 29, 2004 at 10:13 am
SELECT a.o_id
, a.o_tmst
, a.from_dept
, a.to_dept
, b.to_dept
from dummy a
inner join dummy b
on a.o_id = b.o_id
where b.o_tmst = ( select max( o_tmst)
from dummy c
where c.o_tmst < a.o_tmst
 
June 28, 2004 at 2:12 pm
I thought you had to have admin rights on the box. Are you sure these people don't have rights to stop/start services?
June 28, 2004 at 2:07 pm
Some other threads:
http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=120949
http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=111280
http://www.sqlservercentral.com/columnists/chedgate/fragmentation101.asp
http://www.sqlservercentral.com/columnists/ckempster/mappingdatabasefileobjectsandfragmentation.asp
June 28, 2004 at 1:58 pm
David, I assume you'd move it like you'd move any of the system dbs. Is this moving to a new location on the same server? Or a new server?
MS Ref:...
June 28, 2004 at 1:51 pm
As mentioned above, probably you are specifying NULL for the identity. Don't do that, just ignore it like it didn't exist.
June 28, 2004 at 1:39 pm
you might want to use replicaiton instead.
June 25, 2004 at 12:18 pm
Use this to build the loops
declare @i int, @j-2 int
select @i = 1
while @i < 36
begin
if @i < 27
select @j-2 = @i + 64
else
select @j-2 = @i + 48 -...
June 25, 2004 at 12:16 pm
Do they get this when EM starts? Perhaps they do not have master access?
June 25, 2004 at 12:12 pm
Did you change any other parameters?
Like the -d?
June 25, 2004 at 12:09 pm
I'm sure you can create an unattended installation file with the setup. BOL has instructions:
search: Performing an Unattended Installation
June 25, 2004 at 12:06 pm
Viewing 15 posts - 34,786 through 34,800 (of 39,723 total)