-- Computername on which SQL server is running

SELECT 'MachineName: ' + CONVERT(char(20), SERVERPROPERTY( 'MachineName' ) )

-- Servername and Instance name of SQL Server

SELECT 'ServerName: ' + CONVERT(char(20), SERVERPROPERTY( 'Servername' ) )

/rockmoose

Hi,

You may have to deploy DMO - "SQL Distributed Managment Objects" on the client.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;248241

http://support.microsoft.com/default.aspx?scid=kb;en-us;258157

/rockmoose

Ok, sorry did not read the post very accurately 🙂

I would go for INT and maybe put a constraint on the column only allowing 0 and 1 as values. Performancewise...

What about using datatype: Tinyint.

/rockmoose

The question about the (ab)use of Identity Columns as Keys...

My standpoint is:

Don't use them!. - Except: - You have a good understanding of relational database...

You could find something useful here:

http://www.codegeneration.net/

/rockmoose

Probably you could set up the other server as a "Linked Server" and use SELECT INTO.

SELECT * INTO linkedserver.database.schema.TextTable FROM TextTable

Or create a copy of the table and use regular...

I seldom use a percentage for autogrow ether. When creating a database I make estimates for db initial size, and how much the db will grow over time.

Then I make...

try "is null" instead of "= null"

alter table ads

ADD CONSTRAINT

CK_ads_1 (not([ad_status] = 'approved, awaiting artwork files' and [approved_snapshot_id] is null))

if( null = null )

    print 'null = null'

if( null is null...

Yes, that was what I meant.

/rockmoose

Franks example could be written ( more lazily, if you don't want to spec the table&nbsp as:

CREATE FUNCTION LargeOrderShippers...

You may consider using table valued function instead of a stored procedure.

If You need to join on the result returned from the sp.

/rockmoose

You can change the logical filename after the database has been restored.

ALTER DATABASE database MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name)

( see BOL: ALTER DATABASE )

/rockmoose