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...

Is unicode characters the same as high ascii characters?

this is the only way i could figure out how to do it so far, was with a function that loops thru...

with a copy/paste of your code, i get this error:

Server: Msg 1540, Level 16, State 1, Line 1

Cannot sort a row of size 8101, which is greater than the allowable...

creating the tables and migrating the data?

if exists(select name from db1.dbo.sysobjects where name='mastertable1') drop table db1.dbo.mastertable1

select * into db1.dbo.mastertable1 from db2.dbo.mastertable1

just moving new data?

insert into db1.dbo.mastertable1

select * from db2.dbo.mastertable1

left...

if it's just one or two tables, then you'd simply use something like

SELECT *

INTO MYTABLENAME

FROM OTHERDATABASE.DBO.MYTABLENAME

[WHERE <condition to exclude unwanted data>].

if...