Viewing 15 posts - 7,351 through 7,365 (of 7,428 total)
I have not seen a way to do this tpe of URL directly in SQL DTS, however I have written a VB app using the IE component to navigate to...
February 7, 2002 at 4:17 am
Well at 56k about 10 hours minimum. But if your database has a datetime field that is updated when changes occurr you could perform a query on there server that...
February 6, 2002 at 5:34 pm
Bring up my own SQL Server, and have a DTS package to attach to my database of the ISP and copy all the data over (you will be able get...
February 6, 2002 at 3:50 pm
Memory management in SQL Server is by default dynamic, so it can in fact use as much as it wants. Note: SQL loves memory. With 4 instance you may seem...
February 6, 2002 at 3:43 pm
You will see this a lot with SQL Server code as I can script everything I pretty much want you to do so you can more easily go thru the...
February 6, 2002 at 3:25 pm
You may have to have a port added to the firewall that will allow you to pass thru if your network guys are willing to do.
February 6, 2002 at 2:08 pm
Most providers will make backups but to my knowledge few guarantee being able to recover your data if lost. Most all the contracts even if they do make backups state...
February 6, 2002 at 2:06 pm
1 other major thing to keep in mind is a replication only does the data normally and not stored procedures and views. You can have stored procedures in but I...
February 6, 2002 at 1:59 pm
One thing I notice is Step 2 of the full backup has a log backup to disk to a file VTI_LOG_BU but then in the hourly you state append but...
February 6, 2002 at 1:51 pm
I would be curious what happens if you run
BACKUP LOG [dbnamehere]
WITH TRUNCATE ONLY
and then try to shrink.
February 6, 2002 at 1:46 pm
Also if you have a standby server for quick return and it is running on the network you may want to consider some type of replication. If you use transactional...
February 6, 2002 at 1:33 pm
Also you may want to look into openquery if you will be running some pretty complex queries, so that they run on the DB2 server and the final data is...
February 6, 2002 at 1:29 pm
Does the drive to map require a login to connect to the AS400 share. If so you may need to also have the SQL Server account and password with access...
February 6, 2002 at 1:23 pm
What line was it barking about? In QueryAnalyzer you can double click the error message and it put you on the line it is barking about (sometimes not right).
February 6, 2002 at 1:12 pm
At this point I would be curious about wheat the SP does internally. The answer has to lie in the complexity of the procedures. You may need to rethink them...
February 6, 2002 at 12:53 pm
Viewing 15 posts - 7,351 through 7,365 (of 7,428 total)