You should also be able to use the Client Network Utility to create a SERVER\INSTANCE alias for TCP, specifying the port number.

I have seen a similar error in the JDBC world. It was caused by a program where every object performed its own database call to populate itself (each call making...

I am not sure why connection pooling is needed at all. I thought the whole idea of pooling was to reduce the number of connections needed by intermediate (web or...

you might try: select * into data51.dbo.inventory from data01.db.inventory

try:

alter procedure JFM_process

as

begin

set nocount on

declare @myspid int

create table #inputbuf

(

EventType varchar(15),

Parameters int,

EventInfo varchar(255)

)

declare @cmd varchar(200)

declare curProcess insensitive cursor

for

select spid from master.dbo.sysprocesses

where spid >...

text or image columns? = 8KB minimum per non-null entry, with the only sure way to reclaim the space of deleted entries being to copy the table to a...

I think the point is being missed here. Both queries are incorrect.

Consider:

select convert(varchar, getdate(), 101), getdate(),

case when convert(varchar, getdate(), 101) = getdate() then 'equal' else 'not equal' end

03/24/2006 2006-03-24 20:45:04.533...

Nearly everybody who backs up across the network takes a performance hit. And a reliability hit. Period. The question is whether it is "good enough" for you. Personally, I wouldn't...

101 is mm/dd/yyyy, so is not canonical; i.e. the year has less significance in a character string representation than the month or day. Therefore, character comparisons are only valid for...

A rough approximation of the number of bytes for a row can be had by: select datalength(col1) + datalength(col2) + ....

Port 1433 is the default port for SQL Server connections. It is an exploit only to the extent that it is well known as the default, and is therefore easier...

In general, no, not in the query. Formatting such as this (between rows) is usually done by the client program. The query itself just returns a relation (table). Your second...

Don't know about your error, but fiber mode is set with the 'lightweight pooling' option:

sp_configure 'show advanced options', 1

go

reconfigure

go

sp_configure

go

-- observe state of "lightweight pooling 0 ...

neither one requires "offline". "Repair minor errors" in integrity checks requires single user mode.

If examining master..sysprocesses (sp_who, sp_who2) doesn't give you enough clues, then download and run pssdiag.exe and read80trace (rml.exe) from microsoft.com. They collect and analyze a ton of info for you.