oops sorry i skimmed over that part.

SQL server will automatically use all availalble processors. if you had a 4 proc, but licensing for only two, you'd be out of compliance...

there's lots of links on microsoft on this;

licensing is per physical processor, not per virtual processor/core .

If the motherboard has a single socket in it, (if you could afford it)...

Assuming you have SQL server installed on your laptop, you should be able to open Query Analyzer, Press F8, which will open the object browser...find the database>> open the treeview...

won't make any difference as far as databases go.... they are backed up to a specific format for SQL 2005,a dn in a manner backwards compatible with non-service pack-ed 2005...

yes, i mean run a trace in profiler, preferably against a test database, but it doesn't matter.

start a trace, and make them duplicate the error when the trace is running.

stop the...

I doubt it's happening every time right? I always call these intermittent network issues;

it's nothing to do with the code or even with SQL server, but the network;

it could be...

from some page on microsoft:

http://msdn2.microsoft.com/en-us/library/ms143506.aspx

Extended System Support

you said you were hyperlinking to the IttNumber; why can't you simply change the hyperlink to include the Id and the IttNumber? then you can obviously use it on the...

elegant solution as always from Jeff;

I'm decent with SQL, but I still haven't gotten my arms around the Tally table concept for processing;

someday I'll grow up and be like Jeff...

I don't store images in my database, but i do store information about them.

I wrote a program that gets the CRC of any file, and I store that in the...

no, because there's no central resource to ask for the information.

You'll want to use a utility like SQL Recon to find all the servers in your domain. Besides finding out...

here's how i would do it if restricted to just using TSQL:

--a table to loop thru filenames

CREATE TABLE ALLFILENAMES(WHICHPATH VARCHAR(255),WHICHFILE varchar(255))

--the source table: yours already exists, but...

Query Analyzer is just an application that gets the data from a SQL Server database. it doesn't contain the scripts. everything is contained in a database on the server.

typically, you'd...

like Matt said, it depends on what you mean by "integrate into".

you can add calls to extranal applications int eh toolbar, and there is a project(codeproject.com or planetsourcecode.com , i...

truncating where? in query analyzer? QA has a famous display issue with large varchar columns, it might be the default value of 256 here:

Tools>>Options>>Results>>Maximum Characters Per Column>>change to 8000

if you are...