Viewing 15 posts - 39,676 through 39,690 (of 39,899 total)
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
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
Viewing 15 posts - 39,676 through 39,690 (of 39,899 total)