Work habits of a tractor driver, that would be creating traffic bottlenecks and rescueing lost city boys from unfamiliar terrain would it?

David

I made one post and left it at that as I had nothing new to say. Not everyone subscribes to this behaviour concept though.

Maybe we should introduce an {ahem} eBay style rating...

The SME I work for sees no reason to upgrade to 2005, they have, in their view, a perfectly stable working 2000 environment. I suspect they will apply the same...

I wonder if you could use the ODBC function SQLBrowseConnect or the SQLDMO application method ListAvailableSQLServers() in some way?

David

Hi,

Rather than compromise the performance of the system, or leave a timebomb waiting to explode for that one particular record where row length > 8060 bytes you could

Hi,

page size in SQL Server is 8060, and the since a row cannot cross a page boundary, row size presumably cannot exceed that .

From Microsoft's Q & A http://support.microsoft.com/kb/260418

Q....

Hi,

The (ageing) DELPHI telecoms project management application I support has drop-down combos which only support the varchar datatype. Luckily I can over-ride the code which fills the combo with my...

Hmmm,

thank you, an interesting possibility

That may be possible, as all machines are given a name according to our standard network naming conventions

David

Hi,

I have had the same problem ever since I upgraded my SQL2K to SP4.

sp_addserver has no effect at all on this.

Luckily it doesn't seem to affect my DTS packages

Edit: Interestingly,...

No country is perfect, we should celebrate that we live in countries where we can say so

David

Too many fingers for first thing in the morning

David

Hi,

In IE7 (if thats what you are using ?) there is a setting in the Tools menu, Internet Options dialog, on the General tab, where it says Tabs click the...

I recently upgraded my 2Gb SQL Server 2K SP4 installation from Windows 2K to Windows 2K3, and immediately noticed that the server does not use as much memory for SQL Server...

Hi,

I have this problem as well because we chuck all the users off at the end of financial period so we can run our reports (yes I know we could...

In this case I think NULLIF() would be used rather than ISNULL() because it seems likely that the VARCHARs are empty strings (i.e. a known value), which is not the...