I have come across a scenario where I have to move a table from an application specific database to a database that is shared by all applications.

Given that it is...

I would vote for Innovasys DocumentX and Apex SQL Doc as documentation tools.

OK I am particularly interested in developing CLR functions, aggregates and procedures.

Does anyone know of a download that would provide the datatypes or is there a general work around...

I think censorship is OK provided it correctly identifies work related sites.

The problem comes in identifying those legitemate work related sites.

After shrinking the log look up ALTER DATABASE MODFIY FILE in Books on Line.

Firstly back up the transaction log.

Next run sp_helpdb 'YourDatabaseName'

Note the name of the log device

now run DBCC SHRINKFILE('TheLogFileName','Your desired size')

If the server is a linked server then SQLServer1.pubs.dbo.checkcontract should have worked.

You do have to tell SQL Server to create a linked server with the appropriate credentials though.

When my contracted hours were lower I used to do a lot of research in my own time. My wife works nights and I work days so there are...

CREATE DEFAULT df_now AS GETDATE()

CREATE DEFAULT df_today AS CONVERT(SMALLDATETIME,CONVERT(CHAR(10),GETDATE(),102),102)

CREATE TYPE dbo.ty_now FROM DATETIME NOT NULL

CREATE TYPE dbo.ty_today FROM SMALLDATETIME NOT NULL

exec sp_bindefault 'df_now','ty_now'

exec sp_bindefault 'df_today','ty_today'

I had SQL2K, SQL2005 and MySQL4.2 all coexisting on a development box.

I'm not sure if that is such a good idea on a production box but if you could have...

I would start reading up about full-text indexes in SQL Server.

I would also look at the Thunderstone website for their Webinator search engine. It is a spider, which means...

I think of the INFORMATION_SCHEMA views as being something like a programming interface. I know interfaces don't contain implementation, but as Andrew says, the underying tables may change but...

If you are in a job you love with people you enjoy being with, time just flies by and you don't keep track of the hours.

My first job was 37.5...

From what I remember both SQL2000 and SQL2005 are cluster aware, which means that the 2nd instance will install on both nodes.

The installation routine should detect the existing instance and...

DECLARE @TableName SysName ,
@ColumnName SysName
SET @TableName = 'tblAccommodation'

SELECT @ColumnName=COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_name=@TableName
AND COLUMNPROPERTY(Object_Id(TABLE_NAME),COLUMN_NAME,'IsIdentity')=1


PRINT @ColumnName