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

Personally I save all changes in a script and practise the deployment.

The bigger the deployment the more important it is to have it automated.

SELECT COUNT(A) AS Total , SUM(CAST (A AS INT)) AS SLA_OK

FROM TABLE

At the end of the day if the app fulfills the business need then it is mission accomplished whether it was written in VB3, 4, 5, 6 or JFDI.NET.

Yes migrating...

I fully understand your point but from my limited experience with .NET the stories of M$ investing more in .NET than NASA did in the moon shot are entirely believable.

It...