Locally may not show network bottlenecking issues that will appear when done. It depends first on the amount of data to deliver first then how much will be moved each...

Who is going to see this output and how? If the users thru an application interface you built such as web or VB you can select top records to the...

Here is what I just found in BOL

Using AWE Memory on Windows 2000

Microsoft® SQL Server™ 2000 Enterprise Edition uses the Microsoft Windows® 2000 Address Windowing Extensions (AWE) API to support...

As long as you have a value you can use for a > statement that will make each record unique and they can be order that way, then you can...

This will do it

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

DECLARE @Cnt INT

DECLARE @Diff INT

DECLARE @OutCnt INT

SET @StartDate = '2/1/2002' --Starting point

SET @EndDate = '3/1/2002' --Ending Point but does not count this...

ALso you run into many issues based on the version of the Oracle server and the client you are using. I usually for speed purposes though, once I get it...

Strangest thing I have ever seen. I can reporduce it from this which ends up with 4095 rows but the file outs with 4096, when I decreased number of rows...

Check out http://support.microsoft.com/default.aspx?scid=kb;EN-US;q269587 and see if this fits.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Did you try using this way.

ip_InsertIt N'yourunicodedatahere', GETDATE()

Should work, however how are you running the procedure, application type?

How are you reorganizing your database and how much space does the largest table take up. You could reorg each table and index if they are not too large and...

From QA try

sp_dropserver old_server_name

GO

sp_addserver new_server_name, local

GO

This will update sysservers table, see BOL.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Edited by - antares686...

You can also use sp_helptext 'viewname' to get it as a recordset.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Found this on dbforums.com, let me know if this helps.

If I remember correctly, your cnfgsvr.exe was failing because a connection could not be established

to the SQL Server and the failure...

quote:

---

do you know exactly what happens here ?

---

Mostly adds system objects that only exist in...

quote:

---

Personally, I'd let the instances compete and then see what happens. SQL does a good job of managing itself, though I'm not...