you'll notice that this is really a way to store multiple values in a single data field....it kind of goes against the grain of a relational database...one field=one value and...

while I had the macro going for changing the data to a sql, here's the way to interpret STATUS2:

SELECT name as DBNAME,STATUS2,

CASE WHEN (STATUS2 &     16384)...

expanding on what David Web Posted, There's a SQL at the to help interpret what is on/off.

typical results:

assuming you know it is ok to kicke them out without ill effects, kill their connections with this procedure: put it in master;

usage is simply sp_kill dbname

typical results:

checksum() is just a function that returns a value...i like to think of it as being like MIN or MAX functions;

you said there is nothing that makes the data unique...so...

maybe it's just a typo, or the FK automatically assumes the PK of the referenced table but I thought itshould it be this:

CREATE TABLE dbo.Departments (

DeptID INT IDENTITY NOT NULL PRIMARY...

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