You could even use a trigger to automatically rename the file upon updating the file path.

You could create a stored procedure that updates the file path in SQL and then uses xp_cmdshell to rename the file.

I am curious as to why you chose to store images in the db, if you need to take them out. Have you looked at only storing the file...

I like your method more than altering timeout values. Altering timeout values can lead to some serious problems, especially if you do not set it back to the default....

Great point Clive :cool:.

The only potential problem I see is the application cannot inform the user that the backup has completed or failed. This can cause a...

You have limited options because the maintenace plan is actually a SSIS package. The wizard creates a job to call the package.

Your best bet would be to create your...

ODBC connections time out after 30000 ms. You have to alter your DSN connection driver to accomodate the long running query.

This link has more information:

http://www.dbforums.com/showthread.php?t=436735

You should incorporte the inserted table in your join.

UPDATE PM10300

SET PM10300.NOTEINDX = PM20000.NOTEINDX

FROM PM10200

INNER JOIN PM20000 ON PM10200.APTVCHNM = PM20000.VCHRNMBR

INNER JOIN PM10300 ON PM10200.VCHRNMBR = PM10300.PMNTNMBR

INNER JOIN...

I agree with Michael here, you definitely do not want to use option 3. Since this table is big and seems to be a heavy hitter, I would make...

I dont know of any setting but you could create an alias name for each of your connections. The alias can be much shorter and easier to type.

You can...

I agree with Michael on this one. Usually the application tier will handle session length; however, in your case you have both application connections and users logged directly into...

You need to find out how the application connects to the SQL database. IIS does not connect to the database tier, the application does. Chances are that the...

I could not see the error image because is was either stripped or has a bad link. Your problem sounds like a binary issue. While restoring a Master...

here is a simple example

DECLARE @MyTable TABLE

(

ParentID INT,

AcctNbr INT,

[Level] INT,

Asset_Type varchar(25),

Amt money

)

INSERT INTO @MyTable

SELECT '1', 12345, 1, 'ASSETS', 10000000 UNION ALL

SELECT '1', 12345, 2, 'CURRENT ASSETS', 11000000 UNION ALL

SELECT '1',...

All common levels share the same parent ID correct? If so, why not group by parentid and sum the values. If you needed a breakdown you could...