No, it's not... ignore me, I got...

That's probably because run_date is actually held as an integer in sysjobhistory, not a datetime.

Have a look at the advice you've been given on some of the other threads you...

You can also do the same in TSQL by executing sp_delete_backuphistory

I can't verify this, as I don't have access to a SQL2005 instance at the moment, but I'm fairly certain the default is to keep the history for a maximum...

Then it could be the transaction log (or another file in the database) that is taking up all the space.

Run sp_helpdb [dbname] ...that should tell you which file is taking...

Check out DBCC SHRINKFILE instead of DBCC SHRINKDATABASE

So the real answer is... Don't use Len, use Datalength, and don't use nVarchar or Unicode:-D

Paul White (10/30/2009)

You need to be careful with this method:

Declare @v varchar(100)

Declare @i int

Set @v = '1234 ~'

Select @i = Len(@v) - Len(Replace(@v,'~',''))

Select @i,@v

...apparently...

But are they always the same office... i.e. can an employee only provide services from the office...

Without understanding your data and your business, that's very difficult to answer, so I'll go back to my original point.

I presume a licence is granted to a given employee for...

I don't believe the end users have to register.

The link you posted is (I believe) intended for those who are bundling SQL Express as part of an application that they...

The error message says it all... have a look at the way you have defined the relationships in your tables, you have a circular reference, so SQL Server is refusing...

As requested, can you post the error message please.

Can you also post the code you are executing when you are getting this message.

Without these, everything is guesswork.

The last error looks as though the new node doesn't have access to the folder configured for the SQL Error logs ('I:\Microsoft SQL Server\MSSQL.3\MSSQL\LOG\ERRORLOG').

Can you verify that the disk with...

Well, Visio allows data modelling, and should follow the Windows standards as it's a Microsoft product... but in my opinion it's the worst of those I've used. For a large...