Hi John,

By far the easiest way is to create a maintenance plan and get that to clear out log files older than a certain amount. Typically, 48 hours worth...

Try this:

select ItemId, (Qty/(select SUM(Qty) from tblItem where ItemId = i.ItemId)) * 100 as ItemPct

from tblItem i

select file_id('logical filename').

Or select * from sysfiles.

However, your problem seems to be your interpretation of Page Number. Page Number is not dreived from the first column in sysindexes. ...

Hi Dinu,

Yes. Just reference the table by fully qualifying it with the database and owner name.

e.g. select * from somedatabase.dbo.mytable

Gregory,

Why don't you create a partioned view across your partitioned tables.

Once you've got a partitioned view, you just query the view. So if you query the view asking it...

Alternatively,

backup the database, copy the backup file to the destination server and restore.

Chris,

Glad that I was able to help and hope you can work things out from there.

Regarding your second problem, ideally, you'd want to handle this kind of thing on the...

Carl,

Regarding the query comparing telephone numbers on two seperate databases, you can do something like this.

select * from mydatabase.dbo.Table1

where Telephone in

(select Telephone from myseconddatabase.dbo.Table1)

The above query will only...

Hi Erik,

You would need to run that as dynamic SQL as follows:

Dim @CmdStr as varchar(200)

SET @CmdStr = 'select * from ' + @TableName

exec sp_executesq @CmdStr

By the way, you'll lose the...

Oh, and Ian is right about the security issues behind executing dynamic sql but it is the only way to do it in this case.

Unless you decide to change your...

Hi Jane,

I'm not sure I've completely understood your problem so correct me if I'm wrong.

You've got a view that looks something like this.

select

from a1

join a2 on a2....

Hi Chris,

You'd need something like this:

update tblMP3Skins

set Used_By = u.Used_By

from tblMP3Skins s

join

(

select p.Skin, count(*) as Used_By

...

Intellisense for SQL Server is nothing new. Quite a few apps have been providing it for a while now - including SQLDBcontrol (shameless plug).

The neat thing about this is...

Hi Luis,

I'm not certain on what you mean, but you could run the update statement with a begin tran and leave out the commit tran.

Like this:

begin tran

update table

set...

where...

You can then...

I've definately been in a position where I could work from home before - but some roles don't lend themselves well to this. I work freelance so it depends...