Redgate SQL...

When I had the issue, I went through all the suggestions of moving and removing files I even ended up changing some registry settings, but by the...

Another thing that i have tried is to start a new solution and import the package that is casuing problems into the solution, i have saved a few corupted packages...

I have had something similar happen when after i did a SP upgrade I couldn't find an easy answer, I ended up deleting the component that caused the issue...

try

DECLARE @str VARCHAR(100)

SET @str = '(EBS4) Access to Finance'

SELECT SUBSTRING(@str,CHARINDEX('(',@str) + 1,CHARINDEX(')',@str)-2)

though this will only work when there is one set of '(' + ')' any changes in this...

There is not much you can do, I hope this isn't a production database,

did you overwrite the data files when you restored the old backup?

if so, there is not a lot you can do

did you overwrite the data files when you restored the old backup?

if so, there is not a lot you can do easily without a new backup

Notepad.

ClipMagic (cut and paste history application)

Spotify.

Is there a reason you can't use a for-each loop.

doing this in .net is farily straight foward, start off...

Agree with what everyone else has said;

From a quick look, these joins do not really seem ideal for performance, perhaps consider a computed column with an index.

...

If this is transactional replication.

Have a look at agent history on the distributor, there will be a job for the snap-shot , log reader and one job for each...

Don't use auto shrink in production

http://www.sqlskills.com/blogs/paul/post/Auto-shrink-e28093-turn-it-OFF!.aspx

I think that you can install Enterprise as another instance, but I am not sure. maybe someone else will know for sure

because the replication agent needs a way to unqiuely identify the rows, otherwise how would the replication agent know what row to update on the subscribers?

also it is expected...