Viewing 15 posts - 39,241 through 39,255 (of 39,456 total)
I'm with Andy on this one. I used to use Hungarian notation in coding, but never in column or object names. I think it is a disaster. Tool or no...
October 8, 2001 at 2:37 pm
Perhaps. Personally, I'd pay for a subscription if the product would get better and more secure. Though it's not horrible if you keep up with the updates.
Steve Jones
October 8, 2001 at 11:08 am
wrap this in a transaction and use a stored proc. Keep triggers to a minimum.
Steve Jones
October 5, 2001 at 2:23 pm
Alternatively you can use multiple inserts in a single transaction, but I'd avoid this. If the client fails between the items, your transaction may die.
Personally I like one (not pretty)...
October 5, 2001 at 2:22 pm
What you should do is in fact wrap this in a transaction and a stored proc.
create proc GrabRec
as
begin transaction
declare @id int
select @id =
top 1 uid
...
October 5, 2001 at 2:19 pm
In EM, the properties for SQLAgnet include a "restart SQL Agent" if stoppped. Try that.
Steve Jones
October 5, 2001 at 2:10 pm
On a cluster, the clustered server has only one copy of the db. It is shared between teh servers but only availabel through the virtual server. If you have other...
October 5, 2001 at 2:07 pm
Save this as the DTS package and examine it. It may be including the collate option in the query to v6.5
Steve Jones
October 5, 2001 at 2:00 pm
October 5, 2001 at 1:58 pm
Thanks for the complements.
Nice solution. I wish I'd included this one :).
Steve Jones
October 5, 2001 at 1:57 pm
You could also do an spDropserver <servername> then an sp_addserver <newname>, local .
Steve Jones
October 5, 2001 at 10:09 am
They used to have them here:
http://msdn.microsoft.com/msdnnews/archive.asp
You might email the MSDN folks and ask. (and post back here).
Steve Jones
October 5, 2001 at 10:07 am
This is a good document:
I have my web servers dual homed (actually triple). It looks something like this:
...
October 3, 2001 at 10:15 am
October 3, 2001 at 9:59 am
Can you try starting with minimal config (-m I think) and check your sp_configure settings?
Steve Jones
October 3, 2001 at 9:57 am
Viewing 15 posts - 39,241 through 39,255 (of 39,456 total)