could the entire row of each data be considered unique? or would there be multiple rows with identical data?

basically, if you can't identify what makes the row unique, you can't...

typically, you use SQL Server to store the blob, and something like ADO to do the actual stream-to-file operations.

as far as i know, if you were to try and do...

just wanted to confirm you must write to the registry at [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group],

adding it to the .Default does not work, so forget that idea.

much easier...

i know you can export the registry key and port it to other machines;

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group], but to add the items via a program would basically...

not sure about bcp, but you can easily do it like this:

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=D:\testing.xls;',

'SELECT * FROM [Sheet1$]') select * from SQLServerTable

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel...

if you have both SQL2005 and SQL 2000 , you can retore the 2005 on a 2005 instance, and then use SQL2000 DTS to connect to the 2005 server and...

if a table is assigned to a filegroup, it stays within that file group.

if the filegroup is comprised of more than one physical file, when inserts occur, the data...

on a slight tangent, in sql 2005 i know there is a SQL Native Client, which is the provider that replaces SQLOLEDB to connect to a SQL instance...maybe he's trying...

I seem to remember that the first time a query is run is typically the longest... SQL server builds an execution plan and saves it on the first time; subsequent...

If it were me, I think i'd add all the product details to the actual order detail table at the time of order creation. I'd add all the relevant product...

the usual story around my shop...we have tons of desktop-type machines, with a gig of ram and a P2.0 or above processor; I can have a dozen of em if...

Pretty sure you just set it's size in Enterprise manager:

right click on tempdb in EM and choose properties....

Click the Data File tab; my db was defaulted to 8meg; changed it...

SELECT ID FROM tblProjects WHERE

 NOT (ID IN (SELECT ProjectID FROM tblLinks))

the above would return no rows if there is a ProjectId that is NULL.

change to this:

SELECT...

you will have to update the base tables;

a view is really just a saved SELECT statement. this article might help a little bit:

http://www.sql-server-performance.com/nn_views.asp

you'd most likely want to create a...

this works for me, assuming the files and the folder structure exists: I'm moving a local file to a server named DAISY. The server has a share named C_DRIVE, and...