Hi there

Just a quick one - are you sure your running full duplex mode? (ie. 100Mbps?)

Also, did you try running netmon.exe to locate networking errors?

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k...

Hi there

Hmmm.. never heard of this one before. I checked the GUI options can cant find anything that would hide the option. What version btw? Also, who are...

Hi there

Upgrade to a minimum of 512Mb for performance reasons, it will run, but slowly. Esp if you also have a small DB running in the background, IE, IIS...

Hi there

I dont think this will help but...

By default SQL Server 2k FOR XML is UTF-8 encoded. The developer should also take into consideration the ADO command objects being used,...

Hi there

There is no equivalent. Here are some methods from other posters:

SELECT *

FROM

(

SELECT TOP 3000 *

FROM

)

SELECT TOP 5000 *

FROM ...

Are you interested in remote work via Australia? great cost effective solution. Email if you are interested, I also have a team of excellent system architects and senior...

Hi there

Good point with the senior dba comment. I am a "senior dba" apparently :), to be honest, its all about the deeper understanding with the dbms, its architecture,...

Hi there

Step 1. Buy my ebook

Step 2. Restore resume and leave current position 😉

Ok, seriously now...

The hardest task will be your code, the conversion of pl/sql packages...

Hi there

This is a very poor question actually and doesnt really

make sence. Sure, you can remove the role from all depts

but in reality this could be opening a...

Hi there

I cant really add to this, but similar posts in a range of groups have related similar issues to:

a) fibre mode

b) parallel operations being performed..

here is a...

Hi there

Check out "SQLXML", when you install ss2k, go to you program group and see "Configure SQL XML Support for SQL Server". This is a very fast and effective...

Hi there

I would do this:

a) check the memory config for your instance (more than one btw??) and knock the max memory value down 40 odd meg from the total...

Hi there

WinRAR rocks. I also use the free gzip.exe (try a search on our friend google.com). Its a simple command line util which ive wrappered a call to...

CREATE PROCEDURE usp_FindCodeStr

@dbname varchar(100),

@SearchStr varchar(1000),

@PrintOnly bit = 0

AS

SET NOCOUNT ON

DECLARE @sql nvarchar(4000)

SELECT

@sql = ISNULL(@sql + char(13) + 'UNION ALL' + char(13), '') +

'SELECT DISTINCT ''' + name + '''...

Hi there

What I do:

a) get latest version from VSS - search for the string

b) our sp sare not encrypted, so a simple text search over this (see script...