Finally found it!

Sql Server Configuration Manager >

Sql Native Client Configuration  > Client Protocols

> double-click (e.g. ) TCP/IP.

"Default port" is top item.

The server has it's own settings

See

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2276a5ed-ae3f-4855-96d8-f5bf01890640.htm

under "How To"...

I agree with Lowell.

What confused me was this: when I think of instances I normally think of multiple copies of the same sql release installed on a box. Originally, I thought that one could have...

I have found out this much:

"fixed width" format is for files with equal record lengths that do NOT end with <cr><lf>

"Ragged right" format is the correct option for fixed width records...

Jamie,

Now that sql 2005 (September) is relatively stable I am starting to look at it. I found the earlier betas painful to work with -- that is assuming I could even get...

Question answered!

Just saw this article on sqlservercentral.It's an excellent read and includes a good example to boot.

The New ETL Paradigm

Bill

I thought the article and example are quite interesting...but... what is the significance of " [Microsoft.SqlServer.Server.SqlFunction]" in

              public partial class UserDefinedFunctions

              {

               [Microsoft.SqlServer.Server.SqlFunction]

That, in summary, is a problem for me. I know...

Brenda --- correct !

That was my problem. I noticed that when the "SQL Server Setup" disk autoran "Disc 1 or 2"  appeared in faint text in the upper left-hand corner of the...

Veteran,

A simple yet powerful idea! Hadn't thought of it at all.

Thanks,

Bill

All excellent thoughts! Indeed I think the app has a flaw also and am discussing the matter with the programmers\analysts.

Thanks,

Bill

Rookie,

Good questions. I meant "local system account" but I didn't relaize that that account belongs to the local admins group.

I went into Control Panel, Services, and changed the startup account...

I'd be inclined to back out all the data from that Lender run for that day. The errors typically are "all date fields blank" as opposed to a bad record, But you definitiely...

Is there a t-sql command to display all temporary tables that currently exist in tempdb? Can this be done in EM?

TIA,

Bill

Thanks to all. Question: is there a difference in "lifespan"\visibility between the two types of temp table (i.e. "#" vs. "##")? (One responder suggested I use "#" instead of "##"....

Thanks to everyone for their responses but Chris's response really hit home with me. I don't think I understood the subtlety involved.

Bill

>>>

I have seen and heard of cases where either the log or data file was set to grow in small (like 1 megabyte) increments and sometimes the speed of the query...