Or make it easier and use the client network utility to set your own name to the instance name. Then use it as your server when setting up the linked...

I did just find this out. You can create a extended stored procedure to wrap the code to do the update and give you the new value. Of course this...

I do agree with the last statement on in QA/Dev test with them but also test without if you are considering. On small tables it is just simplier to...

Try doing in a script object. Using VBScript with ADO you can loop thru the columns and move the data row by row and not have to worry about this....

Actually look at your connection object in the DTS package. Odds are you have set to Windows Authentication which no matter how you connect the package is going to try...

Based on other information SP1 should have corrected in regards to Win 2K. However since you state you have check both client event logs and server side event logs when...

First and foremost check the SQL Server Logs and Event Viewer logs, they sometimes have additional details. Next start profiler and watch the commands occurring for replication on both servers....

I have had no issues with SP4. Are the backups when done thru Windows 2000 utility the same size as what would be produced by SQL Server? If not you...

First off I think I would on a box of this size consider using multiple instances. But to be sure I suggest you package the box and mail to me,...

Excellent input there with regards to SET NOCOUNT ON.

quote:

---

How can you have so good response time?

When I run a Select count(*) on a 7 million rows table with a where...

Also you will need to define you connection user account and password or use /T for trusted connection.

Try this

set @sql = 'master..xp_cmdshell ''bcp "select * from georgia_invoices_copy..daily_invoices order by invid"...

Yes I do not like the way MS has of pushing some products forward without bein able to go back. Especially with MDAC since several changes mean you may run...

WinZip has an exact file size limit of 4gb. Might try RAR or ACE as I am not sure if they have the same limit or invets if SQLLiteSpeed or...

Acutally, if the DTS package is created without a owner or user password they can edit and run. If you set an owner password and a user password anyone can...