I take it that the CompName column contains the name of the asset? If so, just remove the WHERE clause - you want to return data for all assets,...

stebennettsjb (5/27/2011)

---

Also if i want the file to delete will putting RETAINDAYS = 7 delete the file after 7 days? or does this only count if do backups to the...

I still don't think it'll help. BackupExec backups create backup files, so they'll appear in the backupset table. BACKUP LOG WITH TRUNCATE_ONLY doesn't create any files and so...

There's a username column in the backupset table, but since the...

Try opening the default trace, which you'll find in the same folder as your errorlog files. If it's not in there, and you don't have anything set up to...

http://www.lmgtfy.com/?q=UNC

As Gail said, end of discussion on this thread.

Then that's your problem. As I said in an earlier post, if it's not on your SQL Server, you need to use a UNC.

John

I see what's happened here. You need to use the following construction:

INSERT INTO MyTable (Col1, Col2, Col3)

SELECT @var1, @var2, COALESCE(CAST(Value AS varchar(5)),'0')

FROM MyOtherTable

WHERE Name LIKE 'timezone'

AND BoardID = @BoardID

John

This is the last time I'm going to ask. Please provide full table DDL (including constraints) and sample data in the form of INSERT statements.

John

Table DDL and sample data as requested, please.

The query you have posted cannot return those results, since the ABS function always returns a positive number.

Also bear in mind that an...

It occurs because when you remove the decimal point from the number, you end up with a number that's too big for the int data type. You can cast...

You just need to take the SELECT CAST out of the ISNULL expression.

John

In that case, I don't know what's happening. But I would look for that procedure SyncFunctions and see what it's trying to do.

John

I take it this error occurs when you create the function, not when you access it? Since, according to the error message, the error occurred in SyncFunction, I think...

I take it you have BIDS on your desktop? If you search the internet for "creating a deployment manifest" you should find plenty of content on how to deploy...