Viewing 15 posts - 39,496 through 39,510 (of 39,720 total)
you can have your page load a partial page with an image or text in a <div> tag. Then when the page completes, make this invisible.
I don't have an example...
October 10, 2001 at 11:52 am
October 10, 2001 at 11:44 am
I'd look at using DTS, but perhaps to a staging table. Then you can use stored procedures to queries to move the data while maintaining the foreign keys.
Steve Jones
October 10, 2001 at 11:39 am
Is this SQL 7 or 2000? Does the server have TCP/IP sockets setup? Check the server network utility as well as the client network utility on the client.
Steve Jones
October 10, 2001 at 11:28 am
October 10, 2001 at 11:24 am
How is the Unix job being started? To start a DTS job, AFAIK, you need to use a Windows client. This client will run the DTSRUN exe. This needs to...
October 10, 2001 at 11:12 am
Remove the data you no longer need. then issue a "dbcc shrinkdatabase" command. check Books Online for the options you may want.
Steve Jones
October 9, 2001 at 12:30 pm
October 9, 2001 at 9:28 am
You can save it as a vb file and then open it using notepad. Or post it and we'll try to decode it for you.
Steve Jones
October 9, 2001 at 9:27 am
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
Viewing 15 posts - 39,496 through 39,510 (of 39,720 total)